Soundex Coding Guide

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

The following process outlines the Soundex coding guide:

  1. Retain the first letter of the name.
  2. Drop all occurrences of the following letters:

    A, E, I, O, U, Y, H, W

    in other positions.

  3. Assign the following number to the remaining letters after the first letter:

    1 = B, F, P, V

    2 = C, G, J, K, Q, S X, Z

    3 = D, T

    4 = L

    5 = M, N

    6 = R

  4. If two or more letters with the same code are adjacent in the original name or adjacent except for any intervening H or W, omit all but the first.
  5. Convert the form “letter, digit, digit, digit,” by adding trailing zeros if less than three digits.
  6. Drop the rightmost digits if more than three digits.
  7. Names with adjacent letters having the same equivalent number are coded as one letter with a single number

    Surname prefixes are generally not used.