i am developing a geocode application using oracle database and c#2.0 . But i have a big problem. I cant use "like" word for database search. Because address strings not regular always. I know soundex func. in oracle and SqlServer but it is in English. My project will work only Turkish. Can I find an algorithm that finds similar words. Ex. "Istanbul" "Istanbol". Only character order and length maybe. Because Turkish character set has special chars like Unicode 231(ç),Unicode 287(ğ) and more than 10. Thanks Mehmet KADAYIFÇI
You can you soundex, Soundex is a phonetic algorithm for indexing names by their sound when pronounced in English. The basic aim is for names with the same pronunciation to be encoded to the same string so that matching can occur despite minor differences in spelling. Soundex is the most widely known of all phonetic algorithms and is often used (incorrectly) as a synonym for "phonetic algorithm". Red more here.
Will give you suggestions in sql server You can opt collation property to solve this problem. Regards, Venkatesan Prabu. J