Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Programming (http://www.go4expert.com/forums/programming-forum/)
-   -   Similar Text Search (http://www.go4expert.com/forums/similar-text-search-t2442/)

mkadayifci 5Jan2007 14:10

Similar Text Search
 
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

pradeep 6Jan2007 14:24

Re: Similar Text Search
 
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.

venkatesanj@hcl.in 4Mar2008 08:03

Re: Similar Text Search
 
Will give you suggestions in sql server

You can opt collation property to solve this problem.

Regards,
Venkatesan Prabu. J


All times are GMT +5.5. The time now is 22:30.