Ok I know how to find duplicates thats not the tricky part. However the data I am trying to process has the address listings in a way that some maybe dupes however the format is veried.
Example:
100 Main St Apt 1
100 Main St Flr 1
100 Main St Apt A
All of these could be considered dupes, is there a way to create a query to allow for this variation?
Example:
100 Main St Apt 1
100 Main St Flr 1
100 Main St Apt A
All of these could be considered dupes, is there a way to create a query to allow for this variation?