Searching for best matches in string query

I need to return a list of best/ranked matches from a field in a table. 
For 
example, if the user searches for "Bob Jones Roofing Company", I'd like it
to 
return results that may contain all or any of those words, which the best 
matches listed first.  In that example, "Jones Roofing Company"(3 hits) 
should come up before "Bob Smiths Plumbing Company"(2 hits).

I'm not sure of the best approach to accomplish this and I haven't been
able 
to word my google search term well enough to get meaningful results.

Any help is appreciated.

Thanks.