Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-24 : 01:25:13
|
| Matt Reine writes "Say I have a HUGE table with titles of books indexed on the ISBN#, with a full text search on all columns...I need to do a query that will search all books for anything the user puts in... the trick is sometimes the user puts in misspelled words, spaces, commas...etc etc all junk that wont help me mach up the right book they want.On top of it all im getting these errorsSyntax error occurred near 'king'. Expected ''''' in search condition 'bb king'.and I need to return the % match also... can you help me out with a sample query that I could use as an example? Thanks!-Matt" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-06-24 : 08:09:33
|
| Post the query you are currently using plus the table DDL. How static is this table - is it update throughout the day or in batch ?Punctutation is ignored by FTS anyway so does not affect your searchmisspelled words you can't do much about unless you parse input on the client with a spell checker component. Search phrases can be parsed on the client or the server for removal of noise words.CONTAINSTABLE and FREETEXTABLE return rank columnHTHJasper Smith |
 |
|
|
MakeYourDaddyProud
184 Posts |
Posted - 2002-06-24 : 09:00:05
|
| Certainly, however this is an issue about Fuzzy Logic computing where valued scorecard approximations of key content is required. I havent seen one, is there a UDF for such functionality...i.e.You can have consonant based FS in this manner...'retrieve' is matched by 'rtrieve' or 'rtrv'or rule based FS...'retreive' is matched by 'retrieve' and 'reetrive'Example is where i and e could get confused or too many of one vowel is chosen.'work from home' should show up 'wrok from hom' in a combination of both of the above.Take a search on Google for 'Fuzzy Logic' and see if anything there helps, remember that a lot of this type of logic is based on guestimates.Hey, I might write a UDF today... I wonder???My quids worthDanwww.danielsmall.com Factoring |
|
|
|
|
|
|
Full Text Search Question