Full-text Number of Occurrences

[Vaishal Sheth]

Hello All,

I am trying to write a query that will display the top 5 occuring words in a text column. If you think about it, its result should the same as what I would get if I print the index of that column and order it by the number of occurrences. Is there a way to accomplish this in a SQL statement?

It's not necessarily a full-text search since the user will not be supplying any search term. Somehow, the query has to read the index and display the 5 (or any configured number) of words that occur the most number of times in a field.

I would appreciate any ideas and help,

Thanks,
vps