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 >>