Could somebody direct me to a way to implement
phonetic pattern matching (or "nearly correct" pattern matching for
misspelled words and word fragments.
Somebody suggested using the Soundex method for phonetic
spelling, but upon plugging in suggested code in the SQL editor/Tstrings
property
for the TQuery Object, and running, a runtime 'capability not implemented'
error
was given.
I am searching several fields against an input variable that holds a string
value like %wordfragment% and then currently uses the LIKE operator in the
SQL editor of TString property of Tquery, which works fine for finding
correctly
spelled word fragments and pulling out those records where the word
fragment
is found. But I would also like to find words based on phonetic matching,
catching variants of the words, and also match on spelling 2/3rd of target
word
correctly in correct character order.
I have available both the professional (not client server) Delphi 3 and
Delphi 1 packages
(and one target user needs a Delphi 1 version).