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.

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