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 |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2010-12-22 : 17:15:18
|
| I have 2 tables as such table A [ID,PRODUCTNAME] and Table B [ID,PRODUCTNAME]. The table A has all valid productsname without spelling mistakes [basically clean], meanwhile Table B productname has incorrect spelling. Basically what I need to do is match the incoming productname's from Table B that match roughly with Table A column productname.Example Table A : Mango Table B : MangoesI know this can be accomplished by using Fuzzy in SSIS or If I want to go based on sound use SOUNDEX function.i have also seen some functions that have been written by other for this. We are currently in the midst of choosing the best method to accomplish this matching.Therefore I wanted to test how can Full Text Search help me match the 2 columns and what would be the results.I have create a full text index on column Productname on both tables.Can someone tell me how can I join the 2 tables and test the FREETEXT and CONTAINS functions? |
|
|
|
|
|
FullTextSearch in Query