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 |
|
singh.guru
Starting Member
3 Posts |
 Posted - 2011-03-24 : 06:03:42
|
| Dear Members, i have a requirement, which i need to provide suggestionsi have to make the search query intelligent i.e. if someone searches for ‘tractors’ results for ‘tractor’ would also come up and also relevancy should be taken care. please advice, i am ready to use the third party tool as well..cheersthanks in advance. |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2011-03-25 : 07:00:18
|
| www.google.com-----------If debugging is the process of removing software bugs, then programming must be the process of putting them in. |
 |
|
|
singh.guru
Starting Member
3 Posts |
Posted - 2011-03-25 : 07:17:38
|
| thx, already did that.any other suggestion? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-03-25 : 08:02:41
|
| Full text search--Gail ShawSQL Server MVP |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2011-03-25 : 12:46:36
|
| Soundex perhaps?http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2011-03-25 : 14:46:39
|
| If you are really talking about just setting up some synonyms then, as Gail mentioned, Full Text Search will probably work for you. What I tend to find people are really after is what is called a Taxonomy. If that is what you are really after people make careers out of creating/defining/implementing these. So, best to determine/understand what the business really needs before you proceed. |
|
|
|
|
|
|
synonym dictionary