I'm looking at potential ways to speed up the performance of Craig Boyd's recently posted free VFP spellchecker class (check it out!)
http://www.sweetpotatosoftware.com/SPSBlog/PermaLink,guid,8800bdb9-a9c2-484f-942f-6a08947d903a.aspxMy thought was to build a cursor of all words in a block of text and compare that cursor to a cursor containing a list of all words in a dictionary. The result should be a list of misspelled words.
To keep things simple, assume both cursors have a single field called cWord of the same length and that all words are lowercase. What is the most efficient way to compare my curWords to curDictionary to get a list of all words in curWords that are not in curDictionary?
Here's my first pass:
select cWord from curWord ;
where curWord.cWord not in ( select cWord from curDictionary ) ;
into cursor curMisspelled
Any suggestions welcome. Also be sure to check out Craig's free spellchecker class!
Malcolm