Implement AKA in SQL Server Master Data Services
You would use a separate entity and a derived hierarchy.
Ingredient(Code, Name, ...)

IngredientAKA(Code, Name, Ingredient)

Where the Ingredient.Name is the &quot;official&quot; or &quot;canonical&quot; name, and IngredientAKA.Name is has all the alternate names.