17.10 - Soundex Coding Guide - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.