Search creiteria using sql server : I need to create a procedure to return the matching criteria for the passed parameter from the table
example
parameter - The big
related match from the table - The Big Bang
                               The Big
                               The big 
                               The big bang
I can do the case sensitive search using collation

The output should be "The big". It has to get the closest match possible

Could anyone help me to get that?
