Frequency of Words in Memo Fields

[Angrybox]

I currently have a database that collects forums posts from my site. I would like to have some system when I can get a pulse on what people are talking about by running a query on my field "First Post" that has the body of the first post of the thread. I could run a query by predetermined keywords but ultimately I want something that would find the frequency of any word above a character size of 5 or so.

Does anybody have some experience with a query like this or would be able to get me pointed in the right direction?

[orange]

There is a free tool called NoteTab Light which has a built in feature to show the frequency of words.

It is free, but there are other versions Pro, that may have costs.

You copy your memo field to a new NoteTab window
Go to Tools, then More and there is your word distribution list.

Depends on how sophisticated you want to get as to how you proceed.
What I gave above is totally manual - but you could do the whole thing including download and install in less than 2 minutes.

If you want to automate, you could look at Shell and some NoteTab options. I haven't tried to automate it.