>>>The problem here is that there is no lookup or validation table for cities - can't be, too many cities, towns, or villages all over the world - and the user can write anything. Michel could merge that information, and it might indeed be a good idea to do so. But new members will continue to write just about anything (others
>>might write "S.P.", "S.P", "SP", "S.Paulo", or "S. Paulo" for example).
>>
>>We have something for that. When you see something like that, simply forward me the information about the possiblities and we will enter that into our city matches. Basically, on new upcoming accounts or existing ones, when an update is made, it will be readjusted automatically. This also implies that when we add new similar matches, that all actual data is also corrected. So, basically, for this one, what would be the most common ways that users from there are entering that city?
>
>OK, here is the information for Bolivia:
>
>Cochabamba, Cochamba, and Cbba should all be merged into Cochabamba. (The second is clearly a mis-spelling, the third is a common abbreviation.)
>
>I don't see this kind of duplicates with other cities in Bolivia. I believe there used to be some more; perhaps they were corrected already.

Couple of years ago I was doing some cleaning of wrong cities spellings (and my son helped a lot, BTW). Then Michel came with the idea of some auto-check. So, new entries should be better.