Add the synonym field in the country table
- The
synonym
field is astring
containing 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.