Thanks, I'm looking at metaphone in php now and want to do some testing with that. My app is relatively straight forward in that I can build a table of single words that I want to search.It will come from a couple of different places, including some hierarchical category information that is static in the system in other tables and some words from a title that the user will put in for their full text entry. I am not really interested in searching the full text at this point. This is more of a keyword search to find the text and their is plenty of information in the categories and title to do that.
I'm thinking I can parse the user title to get the non-common words and explode that out and then enter them in a table as single entries, and also enter my static words in the same lookup table associated to the id for their text entry.
So the only real problem is being flexible in the search for misspellings, pluralization, etc.
Do you have experience with metaphone or know of something on the php side that would be better?