Finding similar adress records in database with query

[Antitax]

I have a database with more than 800 adress records

Some of the are similar because some letters in the street adress for
example are not identical, altough they point to the same adress.

Does anyone have the syntax for a query that shows similar adresses
thar could be duplicates?

Thank you

 

[Jeff Boyce]

Define "similar"... (as in, how would YOU decide?).

Are the following "similar" enough?

12345 Main Street
12345 Main St
12345 Main St. SW
12354 Main St
1234 Main Street

(by the way, they are ALL the same address, but the last two are typo's --
MY definition)

Good luck!

Jeff Boyce
<Access MVP>

 

[Antitax]

Define "similar"... (as in, how would YOU decide?).

Are the following "similar" enough?

12345 Main Street
12345 Main St
12345 Main St. SW
12354 Main St
1234 Main Street

(by the way, they are ALL the same address, but the last two are typo's --
MY definition)

Good luck!

Jeff Boyce
<Access MVP>

at least some letters from name and adress should be the same :

It should report "J.Doe main street" and "john Doe main str" as doe
and main are the same. I shouldn't enter a variable

 

[John Vinson]

at least some letters from name and adress should be the same :

It should report "J.Doe main street" and "john Doe main str" as doe
and main are the same. I shouldn't enter a variable

So

Jane Herridge, Maple Ave.

and

Juan Hernandez, Appleton St.

should be the same?

Both have J, A and N in the first name, HER starting the last name,
PLE and A in the street...

Of course not - your "some letters the same" is obviously too loose a
criterion!

This is unfortunately a problem beyond the very limited intelligence
of computers; it needs a human brain to solve the problem reliably!
There are commercial "de-duping" services for mailing lists that use a
combination of (proprietary) computer techniques and human
proofreaders to correct these errors. They don't come cheap.

 

[Antitax]

So

Jane Herridge, Maple Ave.

and

Juan Hernandez, Appleton St.

should be the same?

Both have J, A and N in the first name, HER starting the last name,
PLE and A in the street...

Of course not - your "some letters the same" is obviously too loose a
criterion!

This is unfortunately a problem beyond the very limited intelligence
of computers; it needs a human brain to solve the problem reliably!
There are commercial "de-duping" services for mailing lists that use a
combination of (proprietary) computer techniques and human
proofreaders to correct these errors. They don't come cheap.

In fact it should be enough if some letters from the street adress
(for example 5 ) AND the street number field where the same.