common words in same field

[Mucello]

I want to find what words are common between n number of strings. The strings will come from a mysql database. I might be comparing 2 strings, or 200 strings... the number is dynamic.

An example:
input1 = "The credit card was denied because it has expired.";
input2 = "The snowman melted because he expired.";
input3 = "Because the time had expired, the game was over.";

I want to loop through my input strings, explode them, and do some kind of intersection to return this array:
[0] = the
[1] = because
[2] = expired

What do you think is the best way to approach this problem? Because my input strings are in a database, are there any mysql functions that could help?

Thanks and Merry Christmas!!

Mark

[big_nerd]

Mark,

I have some source posted [thread=10333870]Here[/thread].

It looks for the top 10 'common' words in the database. It is slow and heavy on the processor due to some poor programming on my part, it can give you a general idea, as it does work, and does output to an array (additionally counts the number of like strings).

And if you can think of a more efficiant way to do similar / same thing, I'm all ears.

Regards,

Michael (big.nerd)

[rajug]

In what context you want this to find common words. If you are fetching the data from mysql table and you really want to search the words try with mysql full text indexing.

Does this make any sense?