Fixing the Spelling Problems
Bottom-up strategy: correct errors as needed and get on with it
Top-down strategy: standardize spellings and redesign system to double check when entering the data
Loosely coupled strategy: use local ‘lookup’ tables to cross-reference original and corrected spellings