I use a combination of SOUNDEX in MYSql and a collection of misspelled words with the correct spelling as a custom field, and the body as all the possible misspellings. But someone has to fill in all the possible misspellings in the second collection.
The SOUNDEX does some stuff well, then the alternate collection is used if both the search and SOUNDEX have no results. I am not sure if you can modify how Verity handles this-- I usually use Lucene. -- /Kevin Pepperman "They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety." - Benjamin Franklin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
