Stack Overflow
Stack Overflow

Questions tagged [freetext]

FREETEXT is an SQL text-search predicate that uses stemming (e.g. -ing, -ly) and a thesaurus to search for the given string.

FREETEXT is a predicate used to search columns containing character-based data types for values that match the MEANING and not the exact wording of the words in the search condition. When FREETEXT is used, the full-text query engine internally performs the following actions on the freetext_string, assigns each term a weight, and then finds the matches.

109 questions
3
votes
1 answer

SQL Server FREETEXTTABLE not returning result

I have used SQL Server FREETEXTTABLE function to search in a table column based on the user entered words like a search engine and return best matching rows. Table column will contain many questions and user will type something in textbox (in any…
Hiren Khatri
  • 41
  • 6
3
votes
3 answers

Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?

There is a request to make the SO search default to an AND style functionality over the current OR when multiple terms are used. The official response was: not as simple as it sounds; we use SQL Server 2005's FREETEXT() function, and I can't find a…
Chris
  • 6,761
  • 6
  • 52
  • 67
3
votes
1 answer

sql server full text search - looking for an example usage of thesaurus in full text search

I am running a few selects over adventure works. (i.e. SELECT * FROM Production.Product WHERE FREETEXT(*, 'screw washer spaner'); ) I have yet to encounter a select that uses the thesaurus and displays the finding of synonyms. How can I know if I…
Bick
  • 17,833
  • 52
  • 146
  • 251
3
votes
1 answer

CONTAINSTABLE does not work on single character

I am doing search using containstable() on a table but it is not working if I enter only single character in search string. Below is the query I am using. DECLARE @FreeTextSearch VARCHAR(500)='a' SELECT tblProjectIDs.[KEY] FROM…
Microsoft Developer
  • 5,229
  • 22
  • 93
  • 142
2
votes
1 answer

Slow inital query when using FreeTextTable in SQL Server 2005

The following FreeTextTable query takes > 10 seconds on the first request, but about a second for subsequent requests: SELECT [Key], [Rank] INTO #matches FROM FREETEXTTABLE(Book, [Description], @searchWord) After approx. 10 minutes of inactivity…
user97280
  • 75
  • 3
2
votes
3 answers

Searching a column with comma separated values

I have SQL server 2008 r2 edition, which am working on and a .Net webpage as front end. Coming to the issue, there is a column in the database which basically consists of various skill sets separated by a comma. For example some candidate has a 3…
santosh s
  • 41
  • 1
  • 6
2
votes
1 answer

issue with MSSQL fulltext search

original table contains json, but i've stripped it down to the table below: id json 1 "name":"one.it.two" 2 "name": "one.it.two" difference between the two rows is the space after : catalog has no stopwords. searching for CONTAINS…
hmad
  • 159
  • 8
2
votes
4 answers

SQL Server 2012 Full Text Search match results

I would like to know if there is a way to get the words that were matched from a full-text search using FREETEXT. For example: SELECT * FROM table WHERE FREETEXT(column_name, 'search term') I'd like to be able to see which parts of the text in…
Tyler Bristol
  • 23
  • 2
2
votes
0 answers

C# Multiple Keywords Fulltext Freetext Parameterized Query

I have a SQL 2008 database with a fulltext catalog setup for one of my tables and the goal is to be able to conduct a freetext search against that table from an asp.net c# website where the freetext value could have multiple keywords. Using SQL…
Mike Weisz
  • 21
  • 2
2
votes
3 answers

Spell Checker for Search in ASP.NET

I am building a search where I need to implement couple of features in it among others. 1- It should bring all synonyms, like if someone searches for couch, it should bring in matching results for that couch plus linguistic matches like (sofas,…
Ashar Syed
  • 1,236
  • 6
  • 16
  • 28
2
votes
1 answer

SQL Server 2016 Full-Text Index suddenly stops working

We are successfully using Full-Text Indexing, but multiple times a week it suddenly stops working. Going to the affected table and disabling the Full-Text Index, then enabling it again brings it back to life. But that's no good in a production…
Bob
  • 65
  • 7
2
votes
0 answers

Return column name from a FreeText SQL query

I have a SQL table with a 20 to 30 columns that I need to to search. I've set up the free text search so that I can run queries such as: Select * from dbo.table1 where Contains(*,'asdf'); The problem is I don't know which column actually contains…
Alan
  • 140
  • 9
2
votes
3 answers

Why or How does FREETEXTTABLE give a rank value higher than others

There is a store procedure that uses FREETEXTTABLE twice on two tables and then merges the results and returns the top 50. The problem is if I do a search on "Women of Brewster", the results returns "Confession of an ex doofus motha" with a rank of…
avgbody
  • 1,382
  • 3
  • 15
  • 31
2
votes
1 answer

Sql Server 2005 Fulltext case sensitivity problem

I seem to have a weird bug in Microsoft SQL Server 2005 where FREETEXT() searches are somewhat case-sensitive despite the collation being case-insensitive (Latin1_General_CI_AS). First of, LIKE queries are perfectly case-insensitive, so WHERE…
Zenon
  • 1,436
  • 1
  • 11
  • 21
2
votes
3 answers

FreeText COUNT query on multiple tables is super slow

I have two tables: **Product** ID Name SKU **Brand** ID Name Product table has about 120K records Brand table has 30K records I need to find count of all the products with name and brand matching a specific keyword. I use freetext 'contains' like…
Eric P
  • 2,907
  • 2
  • 24
  • 33
1
2
3 4 5 6 7 8