Finding common phrases in a query

[shawjames]

I am looking for an easy way to find common phrases in a SQL query.

I have a database of products. Some broad queries could produce 100s or 1000s of products.

Is there an easy way to find common phrases in the list?

This way, I could give the searcher a tip of what phrases to add that would reduce their query length.

Thanks!

[nemonoman]

Can you be slightly more helpful in defining the problem set?

[shawjames]

Sure thing, sorry for being brief.

So I have a product database that my customers can search, I will simplify it to Shoes. The search term is "nike" which produces 1000 results. Within the product name field of these results is many common phrases. I would like to find out what these common phrases are, and list them out. Preferably listing the most common first.

For example, perhaps 200 of these products have the common phrase: "Air Jordan"

What would be the best way to determine the most common phrases within the search results?