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
24
votes
5 answers

Keyword analysis in PHP

For a web application I'm building I need to analyze a website, retrieve and rank it's most important keywords and display those. Getting all words, their density and displaying those is relatively simple, but this gives very skewed results (e.g.…
Jeroen
  • 13,056
  • 4
  • 42
  • 63
24
votes
5 answers

How to sort MYSQL fulltext search results by relevancy

I am relatively new to MYSQL and have had an issue that has been bugging me for a while. I've tried googling all over the place for the answer, but have unable to find an acceptable solution as of yet. Here is the query I am running currently to…
user125591
  • 251
  • 1
  • 2
  • 5
23
votes
7 answers

Fastest way to find string by substring in SQL?

I have huge table with 2 columns: Id and Title. Id is bigint and I'm free to choose type of Title column: varchar, char, text, whatever. Column Title contains random text strings like "abcdefg", "q", "allyourbasebelongtous" with maximum of 255…
msergey
  • 592
  • 1
  • 4
  • 12
23
votes
1 answer

Search by pattern on Cloud Firestore collection

I'm trying to perform a filter by pattern over a Firestore collection. For exemple, in my Firestore database I have a brand called adidas. The user would have an search input, where typing "adi", "adid", "adida" or "adidas" returns the adidas…
Augustin R
  • 7,089
  • 3
  • 26
  • 54
23
votes
1 answer

Full text search(Postgres) Vs Elastic search

Read Query In Posgres, Full text indexing allows documents to be preprocessed and an index saved for later rapid searching. Preprocessing includes: Parsing documents into tokens. Converting tokens into lexemes. Storing preprocessed documents…
overexchange
  • 15,768
  • 30
  • 152
  • 347
23
votes
3 answers

Lucene Standard Analyzer vs Snowball

Just getting started with Lucene.Net. I indexed 100,000 rows using standard analyzer, ran some test queries, and noticed plural queries don't return results if the original term was singular. I understand snowball analyzer adds stemming support,…
alchemical
  • 13,559
  • 23
  • 83
  • 110
22
votes
1 answer

Solr: What are the benefits of length normalization/omitNorms=false?

We're using Solr to search articles of various lengths. We index both descriptive metadata (title, author, category, keywords, etc) and the full article text. We do not boost relevance at index time - all boosts are done at query time (we use…
Oskar Austegard
  • 4,599
  • 4
  • 36
  • 50
22
votes
7 answers

Why the Full-Text indexing option is greyed out?

I installed SQL Server 2008 Express with Advanced Services, but when I try to create a new database, the option Full-Text indexing is greyed out, I believe the full-text indexing has been installed, because I did a query as below: use…
silent200
22
votes
6 answers

Find most repeated phrase on huge text

I have huge text data. My entire database is text format in UTF-8 I need to have list of most repeated phrase on my whole text data. For example my desire output something like this: { 'a': 423412341, 'this': 423412341, 'is': 322472341, …
Mohammad Hossein Fattahizadeh
  • 2,651
  • 5
  • 35
  • 50
22
votes
2 answers

Escape string for use in MySQL fulltext search

I am using Laravel 4 and have set up the following query: if(Input::get('keyword')) { $keyword = Input::get('keyword'); $search = DB::connection()->getPdo()->quote($keyword); $query->whereRaw("MATCH(resources.name, resources.description,…
chipit24
  • 6,509
  • 7
  • 47
  • 67
21
votes
4 answers

Best way to deal with misspellings in a MySQL fulltext search

I have about 2000 rows in a mysql database. Each row is a max of 300 characters and contains a sentence or two. I use mysql's built in fulltext search to search these rows. I would like to add a feature so that typos and accidental mispellings are…
Travis
  • 213
  • 1
  • 2
  • 5
21
votes
10 answers

What are some Search Servers out there?

I'm looking to find alternatives to Solr from the Apache Software Foundation. For those that don't know, Solr is an enterprise search server. A client application uses a web-services like interface to submit documents for indexing and also to…
bpapa
  • 21,409
  • 25
  • 99
  • 147
21
votes
4 answers

Count total number of matches in directory with ag

I'm attempting to find the number of matches for a given string across a large project. Currently, to do this with ag I am using the following command: $ echo 0$(ag -c searchterm | sed -e "s/^.*:/+/") | bc which is obviously a bit lengthy and not…
SnoringFrog
  • 1,479
  • 1
  • 16
  • 30
21
votes
2 answers

ElasticSearch - cross_fields multi match with fuzzy search

I have documents that represent users. They have fields name and surname. Let's say I have two users indexed - Michael Jackson and Michael Starr. I want these sample searches to work: Michael => { Michael Jackson, Michael Starr } Jack Mich => {…
Michal Artazov
  • 4,368
  • 8
  • 25
  • 38
21
votes
2 answers

Confused whether to use FREETEXTTABLE or CONTAINSTABLE

So I'm using SQL Full Text Search and from what I read, CONTAINS returns matches near words, while FREETEXT returns words that have similar meaning, however I can't find any examples that validate this. Anyway, to the point, I am using Full Text…
David
  • 2,083
  • 3
  • 17
  • 14
1 2 3
…
99 100