COLOGNE_PHONETIC

Purpose

This function returns a phonetic representation of a string. You can use it to compare words which sounds similar but are spelled different.

Syntax

cologne_phonetic::=

Cologne Phonetic

Usage Notes

  • For a description for the algorithm used, see Kölner_Phonetik and Cologne Phonetics.
  • The result is a string of digits, whose length has as maximum the double length of the input string.
  • This function is similar to SOUNDEX, but is more appropriate for German words.
  • To calculate the difference between two strings, you can use the function EDIT_DISTANCE.

Examples

SELECT COLOGNE_PHONETIC('schmitt'), COLOGNE_PHONETIC('Schmidt');
Result
COLOGNE_PHONETIC('schmitt') COLOGNE_PHONETIC('Schmidt')
862 862