Similar Text Search

mkadayifci's Avatar, Join Date: Jan 2007
Newbie Member
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.

pradeep's Avatar, Join Date: Apr 2005
Team Leader
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.
0's Avatar
Go4Expert Member
Will give you suggestions in sql server

You can opt collation property to solve this problem.

Venkatesan Prabu. J