In Snowflake, there is another function that is SOUNDEX-like that can give slightly different results – SOUNDEX_P123.
For those cases where the first and second letters of the string have the same SOUNDEX number, the SOUNDEX_P123 function will keep the number for the second letter. This variant is used in a few other database systems, for example, Teradata.
Click through for a demonstration of the two
SOUNDEX() variants and how results can differ.