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 |
|
sanjeevka08
Starting Member
18 Posts |
 Posted - 2014-05-15 : 01:35:12
|
| I want to perform auto suggest search in my web application. For that i need a query or SP when returns similiar words from searched word. For example: if user searched 'carporch', query should return as 'car porch'.or if user searched 'dfdfheadfdggg', query should result 'head'. or if user searched 'fdfinmoviecafe', query should result 'in movie cafe'The words 'car porch','in movie cafe' and 'head' are available in a column in SQL Table. Thanks in Advance |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-05-15 : 11:15:39
|
| Look up SOUNDEX and Full Text Searches in BOL to see if either would be of use to you.===============================================================================“Opportunity is missed by most people because it is dressed in overalls and looks like work.” - T.A.Edison |
 |
|
|
|
|
|
Get similiear words using query or SP