Probably use some kind of spelling engine (I like aspell) that will generate suggestions for misspellings. create a table that has two columns 'word' and 'suggestions' (normalize as you see fit). WHen you get a search term, check and see if it's in the table. If it is, just use the suggestions, but if it's not, run it through aspell, and store the suggestions in the table for next time. I'm sure there's better ways, but that should get you started, and shouldn't provide a terrible amount of processing overhead.
cheers, barneyb On Thu, 17 Mar 2005 18:07:14 -0500, Umer Farooq <[EMAIL PROTECTED]> wrote: > Hi, > > for a person like me.. who can't spell to save his life.. whats the best > way to enhance a search to have it search by like terms.. what would you > use.. to do this.. a dictionary to look up the right spelling.. or > would you store common misspelling in a DB field.. etc.. > > Any thoughts on this are much appreciated. > > Regards, > -- > Umer Farooq > Octadyne Systems > +1 (519) 489-1119 voice > +1 (519) 635-2795 mobile > +1 (530) 326-3586 fax -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199264 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
