Stack Overflow
Stack Overflow

Questions tagged [full-text-search]

Full text search involves searching documents, usually involving unstructured text, as opposed to searching text fields in a structured database.

Full text search involves searching documents, usually involving unstructured text, as opposed to searching text fields in a structured database.

Full text search capabilities often include ranking of results by relevance, similarity matching, boolean queries, text clustering, and more.

Popular Full-text Search Tags

Popular Full-text Search Tags related to Open Source solutions.

7909 questions
40
votes
5 answers

SQL Server 2008 Full Text Search (FTS) versus Lucene.NET

I know there have been questions in the past about SQL 2005 versus Lucene.NET but since 2008 came out and they made a lot of changes to it and was wondering if anyone can give me pros/cons (or link to an article).
ajma
  • 12,106
  • 12
  • 71
  • 90
40
votes
1 answer

Using Full-Text-Search in order to find partial words (SQL Server 2008)

I'm trying to build a facebook like search for my software. I'd like to query the table customers. I've set up a FULLTEXT Index and tried the next query SELECT * FROM Customer where CONTAINS(*,'*ann*') The query does return all the customers named…
Dig
  • 3,850
  • 3
  • 27
  • 33
39
votes
2 answers

Optimal data architecture for tagging, clouds, and searching (like StackOverflow)?

I'd love to know how Stack Overflow's tagging and search is architected, because it seems to work pretty well. What is a good database/search model if I want to do all of the following: Storing Tags on various entities, (how normalized? i.e.…
Winston Fassett
  • 3,500
  • 3
  • 36
  • 29
39
votes
2 answers

ElasticSearch vs SQL Full Text Search

I want to use full text search in my project... Can anyone explain me, what is the difference between ElasticSearch and SQL Full Text Search Or why SQL Full Text Search is better (worse) than elastic? documentations, presentations, schema...
Adam Bremen
  • 685
  • 1
  • 7
  • 18
39
votes
5 answers

7645 Null or empty full-text predicate

I have a query that ran fine on SQL2005 but moving the database to SQL2008 gives me the error from the title. The code that is the problem is a call to CONTAINS, CONTAINSTABLE or FREETEXT with an empty parameter. However I'm trying to only call or…
mjallday
  • 9,796
  • 9
  • 51
  • 71
38
votes
1 answer

"grep -rnw": search for a string in all files

Related question: How do I find all files containing specific text on Linux? I have been using the command mentioned in the answer of above question to search for string occurences in all files: grep -rnw '/path/to/somewhere/' -e "pattern" However…
shenkwen
  • 3,536
  • 5
  • 45
  • 85
38
votes
4 answers

What is an index in Elasticsearch

What is an index in Elasticsearch? Does one application have multiple indexes or just one? Let's say you built a system for some car manufacturer. It deals with people, cars, spare parts, etc. Do you have one index named manufacturer, or do you have…
LuckyLuke
  • 47,771
  • 85
  • 270
  • 434
37
votes
2 answers

Error when creating unaccent extension on PostgreSQL

I am trying to configure PostgreSQL to use fulltext search in my rails app as mentioned in this Railscast. I am using a fresh Ubuntu 12.04 server running PostgreSQL 9.1.5 installed using apt-get with the ppa:pitti/postgresql with precise. I get the…
fagiani
  • 2,293
  • 2
  • 24
  • 31
36
votes
1 answer

Get full list of full text search configuration languages

to_tsvector() supports several languages: english, german, french ... How to get full list of these languages ?
Oto Shavadze
  • 40,603
  • 55
  • 152
  • 236
35
votes
3 answers

Importing SQL Server's CONTAINS() as a model defined function

I am trying to import SQL Server's CONTAINS() function in my Entity Framework model so that I can use it in my LINQ queries. I have added this to my EDM:
Xavier Poinas
  • 19,377
  • 14
  • 63
  • 95
35
votes
6 answers

SQL to search objects, including stored procedures, in Oracle

I need to write some sql that will allow me to query all objects in our Oracle database. Unfortunately the tools we are allowed to use don't have this built in. Basically, I need to search all tables, procedures, triggers, views, everything. I know…
Glenn Wark
  • 1,499
  • 4
  • 19
  • 23
34
votes
2 answers

Postgresql prefix wildcard for full text

I am trying to run a fulltext query using Postgresql that can cater for partial matches using wildcards. It seems easy enough to have a postfix wildcard after the search term, however I cannot figure out how to specify a prefix wildcard. For…
Paul Carey
  • 516
  • 1
  • 4
  • 15
32
votes
8 answers

Rails 3 full-text search options (gems, plugins, etc)

I was wondering if there were any suggestions for how to best roll with full text searching in your Rails 3 apps? Thinking Sphinx and acts_as_ferret aren't updated for Rails 3 yet, and even basic activerecord search helpers like Searchlogic also…
shiftshane
  • 323
  • 1
  • 3
  • 5
31
votes
2 answers

Syntax error near 'of' in the full-text search condition 'control of'

I have the following WHERE clause: WHERE (@Keywords IS NULL OR (CONTAINS((p.Title, p.Area, p.[Message]), @Keywords)) ) If @Keywords = 'control', then the query executes successfully and filters my records If @Keywords = 'control…
Curtis
  • 101,612
  • 66
  • 270
  • 352
31
votes
9 answers

SQL full text search vs "LIKE"

Let's say I have a fairly simple app that lets users store information on DVDs they own (title, actors, year, description, etc.) and I want to allow users to search their collection by any of these fields (e.g. "Keanu Reeves" or "The Matrix" would…
Kevin Pang
  • 41,172
  • 38
  • 121
  • 173
1 2 3
…
99 100