Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

SQL Server full text search with spelling mistakes in content

Tags:

sql-server

full-text-search

We have a database filled with OCRed data and manually typed data.

When doing searches with CONTAINS command, not all of the results are appearing. So a search for "monkey man" doesn't return the records that have m0nkey man, momkey man in the data.

Is there a way to allow for these issues in the data?

I've had a cursory glance at Lucene.NET and Soundex but can't see these being of much use.

Thanks for any ideas

like image 392
jimmy Avatar asked Jan 17 '14 17:01

jimmy

People also ask

Does SQL Server support full text search?

Full-Text Search in SQL Server and Azure SQL Database lets users and applications run full-text queries against character-based data in SQL Server tables.

How do I enable full text search in SQL Server?

If you are going to install a new SQL Server instance, then you don't need to do much except click the checkbox near "Full-Text and Semantic Extractions for Search" option on the feature selection window in the SQL Server setup. This feature will be installed along with other components on your server.

1 Answers

I believe you are looking for something called Fuzzy matching.

Similar post:

SQL Fuzzy Matching

Maybe useful:

http://web.archive.org/web/20100209050309/http://anastasiosyal.com/archive/2009/01/11/18.aspx

like image 94
Zzyrk Avatar answered Sep 18 '22 23:09

Zzyrk
Sign in to Comment

Related questions

Why clustered index is update on update of field which not included in that index (Ms SQL)?
Deadlock graph showing unknown Index name
What is the preferred way to identify whether a stored procedure exists
creating view in sqlserver
SQL server modulus operator to skip to every n'th row on a large table
Export values from SQL Server to txt file
SQL: Creating temporary variables
C# Getting Return Value from Stored Procedure Is Not Working
How to specify max length for a computed column
Gender Storage and data types [duplicate]
Why is "TRANSFER" colored blue in SSMS?
How can I get around differences in column types when using unpivot?
Create To script for a temporary table [closed]
SQL CE file sharing violation for multiple processes on local machine
sql insert rows from another table based on condition
No exception when opening SqlConnection in C#
A powerful management tool for MySQL with similar features to SQL Server Management studio [closed]
STRING_AGG is not a recognized built-in function name
SQL query to find Primary Key of a table?
SQL Server : stored procedure transaction

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!