Synonym catalogs are used to replace and standardize values to their master terms, in order to avoid multiple terms for the same real world thing.
There are many real life examples of synonyms that make for messy data, for example:
Company and brand names, like "Coca-Cola", "Coca cola" and "Coke".
Titles, like "Doctor", "Dr." and "Doc"
In the following sections we will describe how to set up synonym catalogs that can be used in a variety of ways to standardize your database.