Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: City name 'spell checker'
Thanks for your reply. The 'city names' may not be mappable to zip codes
because they don't necessarily conform to post office standards and I've
found soundex lacking in accuracy. I am really looking for something closer
to a spell checker.
Aubrey Soper wrote in message <3847FFFD.F41916A2_at_bigfoot.com>...
>hello
>
>how about using a zipcode database, either to get the city
>from the zipcode, or to use soundex on the city names
>[limiting queries by state]?
>
>regards
>aubrey
>
>Keith Morgan wrote:
>
>> I want to provide a city name spelling checking and suggestion facility
for
>> a data entry application. I don't need the advanced linguistic analysis
of
>> natural language spell checkers, but I would like to provide a suggestion
>> list of possible corrections.
>>
>> I am leaning toward producing a suggestion list based on edit distance
(AKA
>> Levenshtein Metric). The edit distance is easy enough to compute but I
>> haven't figured out how to efficiently access likely candidates to apply
the
>> criterion without a full table scan.
>>
>> I am open to any suggestions, references, or other ideas. Thanks for your
>> help.
>>
>> Keith Morgan
>
Received on Fri Dec 03 1999 - 13:00:34 CST
![]() |
![]() |