We have a requirement to peform the Fuzzy Query on external database. Lets say we have the below table where it has all CITY, STATE, ZIP combinations in the table. Before sending the address to Loqate address verification, we wanted to check if the given city state postal code combination exists in the external table or not.
|MOUNT ST HELENS||WA||98611|
If the user keys SAINT LOUIS, it should check this table with the %LOUIS% and then return the result. similarly for ST-LOUIS it should fire the query ST%LOUIS. Basically it should find the matches in bits and pieces.
Please let us know if the Fuzzy lookup is possible against the external database.