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
16
votes
1 answer

How to use FreeText in EF core 2.1

I see that Entity Framework core 2.1 has a new feature to use FREETEXT, but I am not sure how to use it as there are no examples that I can find online. https://github.com/aspnet/EntityFrameworkCore/issues/11484 Has anyone used it yet and could give…
chobo2
  • 83,322
  • 195
  • 530
  • 832
8
votes
2 answers

SQL Server Freetext match - how do I sort by relevance

Is it possible to order results in SQL Server 2005 by the relevance of a freetext match? In MySQL you can use the (roughly equivalent) MATCH function in the ORDER BY section, but I haven't found any equivalence in SQL Server. From the MySQL…
Cebjyre
  • 6,552
  • 3
  • 32
  • 57
7
votes
1 answer

Where can I get an English Thesaurus file for SQL Server 2008?

SQL Server can use a thesaurus file to do substitutions in free text queries, so that a search for 'IE' might return results with 'Internet Explorer' or 'Quirky Browser' in the text. Unfortunately the thesaurus file with SQL Server 2008 is empty!…
Ryan
  • 3,924
  • 6
  • 46
  • 69
6
votes
3 answers

Parameterizing a full text query in sql server

I have a problem using the sql server full text feature. I'm converting some forum software to use the full text search and I have everything setup and working. My problems are related to full text queries. I have designed a few queries which run as…
Ronoc
  • 61
  • 1
  • 2
6
votes
4 answers

Slow SQL Query due to inner and left join?

Can anyone explain this behavior or how to get around it? If you execute this query: select * from TblA left join freetexttable ( TblB, *, 'query' ) on TblA.ID = [Key] inner join DifferentDbCatalog.dbo.TblC on TblA.ID = TblC.TblAID It will be very…
Kevin Berridge
  • 6,251
  • 6
  • 41
  • 42
6
votes
3 answers

SQL Azure CONTAINS not returning all results

We added a free text search on the following table: | 1 | kayer-meyar | | 2 | KA-ME | But, select * from Names where CONTAINS(name, '"ME*"') returns only: | 1 | kayer-meyar | While, select * from Names where CONTAINS(name, '"KA*"') returns…
Guy Korland
  • 9,139
  • 14
  • 59
  • 106
6
votes
1 answer

Google like search query using Full Text Search in SQL Server

I am running a small website wherein I would like to make a functionality like Related Links section. For that I created fulltext catalog and index. So far I tried many ways to create search query which behaves like google, but I would say i was not…
dotnetguts
  • 735
  • 3
  • 7
  • 8
5
votes
1 answer

SQL SELECT FREETEXT order by Rank

I have this query in SQL Server 2008 SELECT TOP 1000 * FROM Quotes INNER JOIN QuoteImages ON Quotes.Id = QuoteImages.QuoteId WHERE FREETEXT(QuoteText,'some text') How can I order the results by most relevant or highest rank ? I have read the…
Mario
  • 13,941
  • 20
  • 54
  • 110
5
votes
4 answers

How to detect keyword stuffing?

We are working on a kind of document search engine - primary focused around indexing user-submitted MS word documents. We have noticed, that there is keyword-stuffing abuse. We have determined two main kinds of abuse: Repeating the same term, again…
Dave Bish
  • 19,263
  • 7
  • 46
  • 63
5
votes
1 answer

SQL fuzzy search and Google-like improvements

Interesting challenge; my client enters some product information in a SQL database. The product is a painting of a famous old Russian composer called Rachmaninoff. So that name is in the description field. Now, only a few of their customers…
Tys
  • 3,592
  • 9
  • 49
  • 71
4
votes
1 answer

FREETEXT queries in SQL Server 2008 not phrase matching

I have a full text indexed table in SQL Server 2008 that I am trying to query for an exact phrase match using FULLTEXT. I don't believe using CONTAINS or LIKE is appropriate for this, because in other cases the query might not be exact (user…
MKing
  • 518
  • 1
  • 4
  • 18
4
votes
2 answers

SQL Server 2005 FREETEXT() Perfomance Issue

I have a query with about 6-7 joined tables and a FREETEXT() predicate on 6 columns of the base table in the where. Now, this query worked fine (in under 2 seconds) for the last year and practically remained unchanged (i tried old versions and the…
Zenon
  • 1,436
  • 1
  • 11
  • 21
4
votes
6 answers

FreeText Query is slow - includes TOP and Order By

The Product table has 700K records in it. The query: SELECT TOP 1 ID, Name FROM Product WHERE contains(Name, '"White Dress"') ORDER BY DateMadeNew desc takes about 1 minute to run. There is an non-clustered index on DateMadeNew and…
Eric P
  • 2,907
  • 2
  • 24
  • 33
4
votes
3 answers

Python: convert free text to date

Assuming the text is typed at the same time in the same (Israeli) timezone, The following free text lines are equivalent: Wed Sep 9 16:26:57 IDT 2009 2009-09-09 16:26:57 16:26:57 September 9th, 16:26:57 Is there a python module that would convert…
Adam Matan
  • 128,757
  • 147
  • 397
  • 562
3
votes
1 answer

Netsuite SQL Expressions

I need to use Netsute SQL expressions on a custom field. There are certain criteria that the field needs to follow; If the cell contains only 1 (or none) capital letters, return the first 2 characters, capitalized. If the cell contains 2 (or more)…
Simon G
  • 217
  • 8
  • 24
1
2 3 4 5 6 7 8