Coded UI: Data source for world wide counties, states, and provinces
I'm working on a database stored with county, province, and state names from countries around the world. There are several issues that I'm seeing in this database: 1) Some values are duplicates 2) Some duplicates are in different cases (lower vs upper) 3) Some values are spelled incorrectly.

What I'd like to do is validate these values against a public free database/API that contain counties, provinces, and states from around the world. What I'm finding is a lot of these resources are geolocation or localization. The database I'm using does not store geolocation or localization data. All values are in English. I just need to be able to use Coded UI to compare the location names (county, province, state) from my database with another public / open database to validate whether the values are spelled correctly.

I'm thinking another possibility is to query Wikipedia and if Wikipedia returns a results page instead of an article page, then I know the spelling is incorrect. Although coding this would be more complex than just querying a database for comparison.

My scenario is to validate something like Arizona but its spelled "Arzona", so I want to be able to validate this as incorrect. Any suggestions?
Coded UI: Data source for world wide counties, states, and provinces
===

I'm working on a database stored with county, province, and state names from countries around the world. There are several issues that I'm seeing in this database: 1) Some values are duplicates 2) Some duplicates are in different cases (lower vs upper) 3) Some values are spelled incorrectly.

What I'd like to do is validate these values against a public free database/API that contain counties, provinces, and states from around the world. What I'm finding is a lot of these resources are geolocation or localization. The database I'm using does not store geolocation or localization data. All values are in English. I just need to be able to use Coded UI to compare the location names (county, province, state) from my database with another public / open database to validate whether the values are spelled correctly.

I'm thinking another possibility is to query Wikipedia and if Wikipedia returns a results page instead of an article page, then I know the spelling is incorrect. Although coding this would be more complex than just querying a database for comparison.

My scenario is to validate something like Arizona but its spelled "Arzona", so I want to be able to validate this as incorrect. Any suggestions?