If you want really good search results, look into Lucene. I believe you can use the "Did you mean" functionality, which I think is what you're going for.
Russ > -----Original Message----- > From: James Smith [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 03, 2008 9:35 AM > To: CF-Talk > Subject: Re: SOUNDEX() in MSSQL > > > I'm not sure soundex is what you want to use here. Soundex is for > searching for words that sound alike but may be spelled differently, ie > searching for a person named "Smyth" and you search for "Smith". > > I know, I was hoping to use this to match "runner" when a user types > "runer" into the search box... > > -- > Jay > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302589 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
