F_SOUNDEX
<< F_ROT13 | IBExpert UDF Functions | F_TELEFONNR >>
F_SOUNDEX
- function from adhoc
F_GENERATESNDXINDEX
- compatibility to FreeUDFLib, FreeUDFLib AvERP
- Compatible with UTF-8
- Input VARCHAR(8190) String to generate Soundex
- Output VARCHAR(6) original (american) soundex of string
Soundex is a phonetic algorithm to indexation of words and cliches after its sound in the English language. Equalequivalent words are to be coded thereby to an identical character sequence. Considered starting from the 2. place counted only the first 6 consonants with the determination, whereby repeated occurrence is only once considered (in the example the l,m,y,w,r,d). Therefore it is unsuitable, around longer strings to compare.
Example
SELECT 'H4564' AS ISCORRECT, F_GENERATESNDXINDEX('Hello my world') FROM RDB$DATABASE;
Expected results:
ISCORRECT F_GENERATESNDXINDEX ========= =================== H4564 H4564
Example
SELECT 'H4564' AS ISCORRECT, F_GENERATESNDXINDEX('Hello my world on my earth') FROM RDB$DATABASE;
Expected results:
ISCORRECT F_GENERATESNDXINDEX ========= =================== H4564 H4564
Example
SELECT 'H4564' AS ISCORRECT, F_SOUNDEX('Hello my world') FROM RDB$DATABASE;
Expected results:
ISCORRECT F_SOUNDEX ========= =================== H4564 H4564
Example
SELECT 'H4564' AS ISCORRECT, F_SOUNDEX('Hello my world on my earth') FROM RDB$DATABASE;
Expected results:
ISCORRECT F_SOUNDEX ========= =================== H4564 H4564
Example
SELECT NULL AS ISCORRECT, F_SOUNDEX(NULL) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_SOUNDEX ========= ================ <null> <null>
back to top of page
<< F_ROT13 | IBExpert UDF Functions | F_TELEFONNR >>
