1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Similar Text Search

Discussion in 'Programming' started by mkadayifci, Jan 5, 2007.

  1. mkadayifci

    mkadayifci New Member

    Joined:
    Jan 5, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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
     
  2. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    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.
     
  3. venkatesanj@hcl.in

    venkatesanj@hcl.in New Member

    Joined:
    Oct 19, 2007
    Messages:
    24
    Likes Received:
    1
    Trophy Points:
    0
    Will give you suggestions in sql server

    You can opt collation property to solve this problem.

    Regards,
    Venkatesan Prabu. J
     

Share This Page