Pitney Bowes MapInfo Professional - Manual (Page 378)

matching is not case sensitive; upper and lower case letters are successfully matched with one another.
MapInfo Professional does not get an exact match in many cases and uses a file of abbreviation
equivalences to improve its "hit rate". Once you understand the various ways in which a match can fail,
you are in a better position to understand what you can do to improve things.
The next table illustrates exact matching. The first column contains a street name from a target table
and the second column contains the corresponding street name from a source table. The third column
says why they do not match. The fourth column indicates whether the particular problem is one which
can be corrected through using the abbreviation file. This table assumes that the addresses are the
contents of a single column in a table. While the street number would often be in the same column, we
do not indicate street numbers here because they are handled differently than street names.
Correctable with
Abbreviation File? Comment Source Address Target Address
No "LaSal" is the wrong
spelling. LaSalle St LaSal St
No "La Salle" is the wrong
spelling. LaSalle St La Salle St
No "Ave" does not match
"St". LaSalle St LaSalle Ave
Yes "Street" does not match
"St". LaSalle St LaSalle Street
Yes "Ave" does not match
"Av". LaSalle Av LaSalle Ave
Yes The target address has
a period after "St". That LaSalle St LaSalle St.
period is not in the
source and causes the
match to fail.
No "St" is missing from
target. LaSalle St LaSalle
No Target has "St" and
source does not. LaSalle LaSalle St
No Target has "North,"
which is not in source. LaSalle St LaSalle St North
Yes Target has "North"
instead of "N". LaSalle St N LaSalle St North
Yes Target has "North"
instead of "N". N LaSalle St North LaSalle St
No Target has "North,"
which is not in source. LaSalle St North LaSalle St
Yes Target has an apartment
number which does not LaSalle St LaSalle St Apt 3
match anything in the
source.
Yes "Tenth" and "10th" do
not match. 10th St Tenth St
MapInfo Professional 12.5 378
Geocoding - Assigning Coordinates to Records