I am trying to recreate the same functionality Google has in regards to suggesting words/phrases (not names), when you misspell something it comes up with suggestions. We have a list of words in the database to match against.
I've looked at SOUNDEX but it is not close enough, DIFFERENCE is even worse. The only way I can get SOUNDEX to be more accurate is with SELECT [word] FROM [tbl_word] WHERE ( SOUNDEX( word ) = SOUNDEX( 'test' ) AND LEN( word) = LEN( 'test' ) ) I've been looking at Regular Expression matching in MS SQL Express 2005 which I reckon would provide more accurate matches. Not sure how that will affect performance, as we could be talking about 20,000 records. Is there something else that I am missing, anyone know what to use in a situation like this? Using ColdFusion MX7 and MS SQL 2005 Thanks in advance. -- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutions an industry leader with commercial IT experience since 1994 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
