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
31
votes
8 answers

Full Text Searching with Rails

I've been looking into searching plugins/gems for Rails. Most of the articles compare Ferret (Lucene) to Ultrasphinx or possibly Thinking Sphinx, but none that talk about SearchLogic. Does anyone have any clues as to how that one compares? What…
Matt Grande
  • 11,964
  • 6
  • 62
  • 89
30
votes
6 answers

Stack Overflow Related questions algorithm

The related questions that appear after entering the title, and those that are in the right side bar when viewing a question seem to suggest very apt questions. Stack Overflow only does a SQL search for it and uses no special algorithms, said…
lprsd
  • 84,407
  • 47
  • 135
  • 168
30
votes
3 answers

How does `#:~:text=` in URL works to highlight text?

TL;DR How/why are some browsers able to search and highlight text in the HTML body which is followed by #:~:text= in the URL? Explanation One day I was searching for something on Google, which lead me to Quora's result. I observed that 2 sentences…
BhaveshDiwan
  • 669
  • 10
  • 22
30
votes
4 answers

'Find All' in Android Studio

New to Android Studio and I wanted to find all instances of something across all java files. I read that shift+shift would bring up a 'Search Everywhere' box but it doesn't work. You can see from the image below that the text is in the open class…
user1091524
  • 865
  • 1
  • 15
  • 28
30
votes
7 answers

Search engine solution for Django that actually works?

The story so far: Decided to go with Xapian as search backend because it has all search-engine features I was looking for, knows about Unicode, stemming, has few dependencies and requires no bloated app-server installation on top of it. Tried Django…
nikola
  • 2,241
  • 4
  • 30
  • 42
29
votes
3 answers

SQL 2008: Turn off Stop Words for Full Text Search Query

I'm having quite a bit of difficulty finding a good solution for this: Let's say I have a table of "Company", with a column called "Name". I have a full-text catalog on this column. If a user searched for "Very Good Company", my query would…
John
  • 17,163
  • 16
  • 65
  • 83
29
votes
2 answers

MySQL - Efficient search with partial word match and relevancy score (FULLTEXT)

How can I do a MySQL search which will match partial words but also provide accurate relevancy sorting? SELECT name, MATCH(name) AGAINST ('math*' IN BOOLEAN MODE) AS relevance FROM subjects WHERE MATCH(name) AGAINST ('math*' IN BOOLEAN MODE) The…
BadHorsie
  • 14,135
  • 30
  • 117
  • 191
29
votes
3 answers

Why can't I create this sql server full text index?

I have a database table with the primary column defined as: ID bigint identity primary key I also have a text column MiddlePart. I'm trying to create a full text index, like so: CREATE FULLTEXT INDEX ON domaining.dbo.DomainName ( MiddlePart …
Nathan Ridley
  • 33,766
  • 35
  • 123
  • 197
29
votes
6 answers

Django MySQL full text search

I need to implement full text search for my Django application, running MySQL as backend. Let's say I've got a model as follows: class MyItem(models.Model): title = models.CharField() short_description = models.TextField() description =…
edkirin
  • 507
  • 1
  • 4
  • 11
29
votes
3 answers

Does Oracle support full text search?

Is there an Oracle equivalent to MS SQL's full text search service? If so, has anyone implemented it and had good / bad experiences?
JosephStyons
  • 57,317
  • 63
  • 160
  • 234
28
votes
6 answers

.NET library for text algorithms?

Do you know any .NET library for text algorithms?? Especially I'm interested in strings match, and full-text-search algorithms like Bitap algorithm Levenshtein distance Damerau–Levenshtein distance I know the one I have mentioned are pretty simple…
Alex Burtsev
  • 12,418
  • 8
  • 60
  • 87
28
votes
3 answers

How to implement a MySQL fulltext search across multiple tables?

I’m trying to do a full-text search in three seperate tables and sort the results by relevancy. During my searches for the answer, I found out that I can’t use fulltext search in multiple tables. So I added a separate fulltext index for each column…
keune
  • 5,779
  • 4
  • 34
  • 50
28
votes
2 answers

Add a FULLTEXT index in Doctrine 2 using annotations?

I know that Doctrine 2 doesn't support FULLTEXT indexes. I'm actually using a result set mapping and native queries to FULLTEXT search innodb tables (MySQL 5.6). But I still need to mark one or more entity fields as part of the index. Is there any…
gremo
  • 47,186
  • 75
  • 257
  • 421
28
votes
4 answers

Elasticsearch 503 error when checking server status

I've been using elasticsearch as a search engine for my Rails application, however it stopped working properly due to a reason i can't understand. When making a curl request to elasticsearch server i get a 503 error. curl -XGET…
roman
  • 5,100
  • 14
  • 44
  • 77
27
votes
2 answers

Use multiple words in FullText Search input string

I have basic stored procedure that performs a full text search against 3 columns in a table by passing in a @Keyword parameter. It works fine with one word but falls over when I try pass in more than one word. I'm not sure why. The error…
Dkong
  • 2,748
  • 10
  • 54
  • 73