Add the synonym field in the country table
synonymfield is a
stringcontaining values separated by a comma.
- if a country is not found, then look to the synomym. If nothing match, reject the record. Latter on the user can add a new country or synonym and catch the faulty record.