Incorrect result (submitted data mis-interpreted; not a data problem)

[jimcraner]

I submitted several test requests and got proper responses.

When I submitted "Peoria, IL" (no quotes), the returned result was:

In Prole, Iowa you are on Iowa land.

I tried the same request multiple times and always got the Prole, IA result.

For reference, "Peoria Heights, IL" (no quotes) did correctly return Peoria Heights and its associated land data.

To Reproduce:

1. Submit Peoria, IL as a city to the land_acknowledgement test number
2. Note result.

(BTW, this is a very awesome project, thanks to all of the contributors and participants!! :-)

[mark-meyer]

This is an interesting case where the megaphone-based fuzzy matching fails. The megaphones of PEORIAIL PROLEIA are a match.

postgres=# select metaphone('PEORIAIL', 10);
 metaphone
-----------
 PRL
(1 row)

postgres=# select metaphone('PROLEIA', 10);
 metaphone
-----------
 PRL
(1 row)

This is currently fixed by temporarily disabling fuzzy matching, but a better alternative would be to find a way to prefer exact matches or look for exact matches and only look for a fuzzy match if that fails.