You could simple report potential misspellings Google-style: "Did you mean 'artifacts'?". I set something like this up using the spell checker tool from cfdev.com many years ago. Or you could use the same tool to take the first correct spelling in its list of suggestions as the word you're searching for. You'd need to make sure all the Aboriginal words and artists' names etc were in the dictionary of course.
Or you could set up a table of common misspellings and their correct translations. This would probably be the easiest to implement and wouldn't have the false positive problems a dictionary would have. You'd simply take the search string, split it into words, look up each word in the misspellings table, swap in the correct spelling if found, reassemble the search string and search! -----Original Message----- From: Parker, Kevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, 15 June 2005 1:11 p.m. To: CF-Talk Subject: Antiques and artefacts I'd appreciate some advice please. I'm knocking up a little site for someone to store and display details about Aboriginal Art online. From the available product line people can select items of interest and lodge and expression of interest in buying them (because they're also available from the gallery floor). The owner has asked me if the application can handle misspellings. All data is stored in SQL Server tables. The issue is that the word artefacts is commonly misspelt as artifacts and they've asked that if someone puts in artifacts then the system will interpret that as a search for artefacts. All searches are done via SQL queries. Any clues greatly appreciated. TIA!!!! ++++++++++ Kevin Parker Web Services Consultant WorkCover Corporation p: 08 8233 2548 m: 0418 806 166 e: [EMAIL PROTECTED] w: www.workcover.com ++++++++++ ************************************************************************ This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ************************************************************************ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209508 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
