All geek questions in one place

"sound", "Did you mean THAT functionality" using full-text search in SQL Server 2005

I implemented a full-text search in the SQL Server 2005 database using the CONTAINSTABLE keyword. I was wondering if there is a way to add “sounds like” or google “did you mean THAT” if the original request does not produce any results.

+3
source share
3 answers

Soundex for SQL Server is very limited and frustrating; I really recommend that you take a look at Lucene.net http://incubator.apache.org/lucene.net/ . Lucene is a high-performance, full-featured text search library, and is also very easy to use in .NET projects. If you need a serious search engine for your application, go with Lucene.

Some functions extracted from http://lucene.apache.org/java/docs/features.html :

  • rating, best results
  • returned many powerful queries first
  • types: phrase requests, wildcards
  • requests, proximity requests, range
  • queries and other search queries (e.g. title, author, content)
  • sort by search range for all
  • search multiple indexes with
+2

SQL Server SOUNDEX DIFFERENCE

SO- : sql ?

0

, . : SOUNDEX, SOUNDEX , , . " ", .

Technically, you only need to normalize the actual index, not the data, but since your data is likely to be indexed, then it will need to be normalized.

This is the same process as generating words, removing plurals, etc.

0
source

Source: https://habr.com/ru/post/1709456/

More articles:


All Articles