Avoid duplicate entries in the location table

Hello Community,

I am looking for you help to avoid the duplicates in the cmn_locations table. As all of you know Name, Street, City, State, Zip and Country are the key fields in the Location table but we are seeing some duplicates there. 

Suppose one street written like 'East Coast Street' and other user may write it like 'E Coast Street' so technically both of them are same but 2 records are there.

Pls share your thoughts how can we design a solution to avoid such kind of duplicates.

Thanks

#serviceNow "cmn_location