Note: I am using SQL's Full-text search capabilities, CONTAINS clauses and all - the * is the wildcard in full-text, % is for LIKE clauses only. I've read in several places now that "leading wildc...

Json received from the server has this form. [ { "id": 1103333, "name": "James", "tagA": [ "apple", "orange", "grape" ], "tagB": [ "red", "green", "blue" ], "tagC": null }, { "id...

I'm looking for a way to support with good performances case insensitive + accent insensitive search. Till now we had no issue on this using MSSql server, on Oracle we had to use OracleText, and no...

I am new to Go and Bleve (sorry if I'm asking trivial things…). This search engine seems to be really nice, but I am getting stuck when it comes to deal with my search results. Let's say we have a...

I am building a site in which I want to implement text search for the title and description of some objects. Since I will have little amount of objects (~500 documents) I am not considering Haystac...

Does silver_searcher support specifying multiple search expressions something like -e in grep? I could not find any option in the document/help.

A trie seems like it would work for small strings, but not for large documents, so not sure (1-100's of pages of text). Maybe it is possible to combine an inverted index with a suffix tree to get t...

I have collection which has two fields { name : 'text English', descr: 'Texto largo en español' } I would like to create a multi-language search, with more preferences for a name. Up till now I ...

I am create a simple app which can performance basic operations. SQLite is used as database. I want to perform wildcard search but I know that it has poor performance. I want to try out full text s...

NB: I could have used a dictionary like Pspell, Aspell or Hunspell but this case does not apply properly to business names or cities. Furthermore, I don't want to query the DB for all the sugges...

I'm developing a Python tool which uses a sqlite3 virtual table with FTS5 (Full Text Search). I would like to know how to properly install from a tarball (or any other means) the needed requirement...

I want to try and use Elasticsearch as a full text search engine for a website in Hebrew. I wanted to know if this Elasticsearch can produce good results for Hebrew and if there are any big website...

Using SQL Server 2012 (in general using SQL Server 2008 R2 up to SQL Server 2016) This question is a more specific re wording of SQL-Server Full Text Index Unexpected results. Please see here for ...

MS SQL SERVER 2012 I have a full text index configured on a database which for the main part seems to be functioning correctly. I have a keyword field that contains the following text: Veterinar...

I am using postgresql 9.6. I am trying to understand ts_rank I have a phrase "one two four" and my search query is 'one two three' So i am trying to get the ts_rank for all possible combinations a...

When I use 'a:*' (also 'i:*', 's:*', 't:*') SELECT id FROM mv_fulltextsearch1 WHERE to_tsvector(text) @@ to_tsquery('a:*') LIMIT 50; Takes forever and prints the following PostgreSQL output a lo...

I have the query: var query = DataContext.Fotos.Where(x => x.Pesquisa.Contais("myTerm") The SQL generated is: SELECT ... FROM Fotos AS [Extent1] WHERE [Extent1].[Pesquisa] LIKE N'%mytem%' ...

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 y...

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. S...

I need to be able to search for text in a large number of files (.txt) that are zipped. Compression may be changed to something else or even became proprietary. I want to avoid unpacking all files ...

Currently, I am running the following code: User.query.filter(or_(User.username.contains(query), User.name.contains(query))) But naturally, when you're hitting a few million records and searching...

I'm trying to query an FTS table using SQLite.swift. Previously I have done it in Android. The essence of what I am trying to do is this: SELECT * FROM t2 WHERE id IN (SELECT docid FROM fts_table...

I'm testing Amazon Cloudsearch for my web application and i'm running into some strange issues. I have the following domain indexes: name, email, id. For example, I have data such as: John Doe, [...

I'm currently working on a project where we have indexed text content in SOLR. Every content is writen in one specific language (we have 4 differents european languages) but we would like to add ...

I know how to do this with raw PostgreSQL commands, but want to know if there is a way to do this with Django PostgreSQL search. class Person(models.Model): name = models.CharField(max_length=64)...