[postgis-users] Fuzzy Address Matching - PostgreSql equivalent to FuzzyStringComparer using Python difflib module

[Shaozhong SHI]

Hello,

I got a few questions as follows:

1.  Which one is the best way for Fuzzy Address Matching?

2.  FME FuzzyStringComparer uses  Python difflib module.  Which one in
Postgres is equivalent or similar to it?

3.  Often, addresses collected by different people may well be correct.
But, there may be typing errors, or addresses are composed not in a
consistent manner.

For instance, South Great Avenue, A City, Planet Earth may be put down as
the following:

S. Great Aveue, City A, Earth Planet
Great Avene South, A City, Earth Planet
Great Avenue S, A City, Planet Earth

Surely, there would be solutions to deal with this problem.

Can anyone enlighten me?

Regards,

Shao
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200511/4caec180/attachment.html>