Company Name Cleaning Combines Brand Normalization Rules, Phonetic Matching and AI
A developer describes a three-part method for cleaning messy company names in databases: normalization rules, phonetic algorithms, and a language model for ambiguous cases. The approach was first built around 2.3 million names gathered from ad exchanges, CRM exports and forms, where no validation existed at entry. Because the same firm can be written many ways, exact matching fails, so comparing how names sound works better than comparing spellings. The method relies on lists of legal-form suffixes and filler terms to strip as noise, applied in a strict order: standardize casing and punctuation, replace longest terms first, and use word boundaries.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)
Log in to join the discussion and vote.
Log in