Find phonetic word in SQL
-
Dear all, I'm new comer in SQL, I have problem in web development, in my system there is searching for phonetic name like nielsen and nelson. Example: If I enter test word 'nielsen' then output can be 'nilsen','nelson'. I've used sounds like but it given so many return and the return have far distance with test word. Also I have implemented it with traditional way, but the searching running slow, I compare some data (from excel, the number of data 200 record) with database record about 600.000 record.Does anyone have idea with my problem?Or have implement this case? Thank you for helping..:)
-
Dear all, I'm new comer in SQL, I have problem in web development, in my system there is searching for phonetic name like nielsen and nelson. Example: If I enter test word 'nielsen' then output can be 'nilsen','nelson'. I've used sounds like but it given so many return and the return have far distance with test word. Also I have implemented it with traditional way, but the searching running slow, I compare some data (from excel, the number of data 200 record) with database record about 600.000 record.Does anyone have idea with my problem?Or have implement this case? Thank you for helping..:)
As you haven't said what the database is, I'm going to assume you are talking about SQL Server. Most "real" databases provide a SOUNDEX[^] function which can be used to do this form of matching.
*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington
"Mind bleach! Send me mind bleach!" - Nagy Vilmos
CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier
-
Dear all, I'm new comer in SQL, I have problem in web development, in my system there is searching for phonetic name like nielsen and nelson. Example: If I enter test word 'nielsen' then output can be 'nilsen','nelson'. I've used sounds like but it given so many return and the return have far distance with test word. Also I have implemented it with traditional way, but the searching running slow, I compare some data (from excel, the number of data 200 record) with database record about 600.000 record.Does anyone have idea with my problem?Or have implement this case? Thank you for helping..:)
Please try out this Code Project Article[^]. It has a total of 6 parts and the current one handles your situation. Also you can try out with Metaphone approach which performs better that Soundex. Here[^] is an implementation for the same. Hope that helps
Niladri Biswas (Code Project MVP 2012)
-
Please try out this Code Project Article[^]. It has a total of 6 parts and the current one handles your situation. Also you can try out with Metaphone approach which performs better that Soundex. Here[^] is an implementation for the same. Hope that helps
Niladri Biswas (Code Project MVP 2012)
Hi Niladri, Thank you for your answer.. I want to, can that solution if we want to compare 100 data in table a with 100000 data in table b. so it looks like google search, when program compare 1 data to 1000, the system doesn't compare to all data, but only similar data, and the system give return hit, example: 1 data is suspected similar with 8 data in table b. Can the solution solve the problem niladri? Thank you, Regards
-
As you haven't said what the database is, I'm going to assume you are talking about SQL Server. Most "real" databases provide a SOUNDEX[^] function which can be used to do this form of matching.
*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington
"Mind bleach! Send me mind bleach!" - Nagy Vilmos
CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier
Hi nagy, Thank you for your answer, I used MY SQL, and I've used soundex, but it return too many result which not match to my keyword, how about you idea bro? Thank you, Regards.