Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get count of key words used in full text index

Status
Not open for further replies.

ntm0n

Programmer
Jun 22, 2001
30
US
I have a database with a full text table created on it. How can I get a list of the keywords used in the full text index and a count of those words. What we are trying to find are the top words used in a database. This should provide us with a list reports that can be reviewed for trends analysis.

For example, if fenders was on the list as a word used most often, we could review those records to see what problems were being found with fenders.

We are looking for a way for the database to tell us what are the most popular words used. We would also like to filter out noise words such as "the", "as", "how" etc...

Thanks in advance for your help!

Gary
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top