Soundex code was developed to help defeat the effects of all spelling variations, which can occur in similar-sounding name (Smith, Smithe, Smythe, etc.). This allows users to index is based on the Soundex code is based on votes and "no", as it is written.
The Soundex system is not foolproof - after Gough sounding names and Goff (Goff), but a different code is generated for these two names. Soundex can however be more widely used to obtain a desired result (closer to a desired result atleast) This is an algorithm commonly used by many researchers.
Depending on SQL string is available for this and usually come handy. SOUNDEX () function.
It accepts a string (name) as a parameter and returns a 4 character. This code is known as code name soundex / string is sent as a parameter.
For example:
Choose Soundex ('Smith') O / P: S580
Select SOUNDEX ('Smith') O / P: S580
SELECT SOUNDEX ('green') O / P: G652
Another use for this is contrary to a user enters a field where you need to search for specific words, but words can be wrong (even if it can not produce 100% conversion).
No comments:
Post a Comment