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 |
|
tftr_si
Starting Member
6 Posts |
 Posted - 2008-02-20 : 08:41:40
|
Hi guys,I was wondering if you could help me. I have a keyword matching system idea and I need to figure out if it is feasible and if so, roughly how I would go about doing it.Basically, I have an article being posted on my site. The hard part is that each word of that article then needs to be used as a 'keyword' to match up against users (via a comma seperated list of words in the users table) and return the list of matches. Ideally, i'd like to remove any unnecessary words such as 'the', 'and', 'it' etc from my large bulk of text and match against the substance in there.Is there a way of doing this? Would Full-Text Indexing help? Any comments would be greatly appreciated!!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-20 : 11:06:05
|
| Full text indexing by itself removes some words distiguished as noise words from search criteria |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-02-20 : 11:22:02
|
| Yes full text indexing does remove most noise works like "a" and "it" etc but also using the freetext function will find the best matches not the exact match like contains |
|
|
|
|
|
|
Select/Full Text indexing - Lots of keywords!!