Stack Overflow
Stack Overflow

Questions tagged [fuzzy-search]

A search mechanism where the objective is to find all approximate, relevant or possibly relevant results for the search-key rather than finding an exact match.

Fuzzy search is a search mechanism based on , where the objective is to find all approximate, relevant or possibly relevant results for keywords rather than finding an exact match. This allows for matches even where the keywords are misspelled or only hint at a concept.

Related tags

954 questions
-1
votes
1 answer

Group comma seperated values in a row and create a new pandas column

I have a situation where I need to create a new pandas column based on the comma separated values that are present in the corresponding using some matching of the phrases. For examples: My data frame looks like this : ID INFORMATION 1 …
Django0602
  • 797
  • 7
  • 26
-1
votes
2 answers

Analog SQL LIKE command for ElasticSearch

Tell me the analog SQL LIKE command for ElasticSearch. SQL command: SELECT * FROM cities where 'blah Chicago blah' LIKE CONCAT('%', name, '%'); Expected output: [{id: 123, name: 'Chicago'}]. This is supposed to be used for fuzzy search of entities…
Вячеслав Русов
  • 1
  • 1
-1
votes
1 answer

fuzzy matching in one dataframe in R

I have one dataframe with less than 5000 rows (csv file). I have plenty of columns, one of them is the company name. However, there are many duplicates with different names, for example, one company can be called: HH 785 EN And his duplicate could…
BeijaxBI
  • 1
  • 1
-1
votes
1 answer

jquery select input field search

How can I create an input field that automatically narrows the options in a selectbox? I have a selectbox with hundred names and it would be nice if you could enter anything fuzzy in the input field, so the selectbox only shows the fitting names
rubo77
  • 19,527
  • 31
  • 134
  • 226
-1
votes
1 answer

After installing a module, it still says my module isn't installed

I will attach a screenshot of my terminal, please can you explain what I'm doing incorrectly? Sorry if this is a stupid question, it seems very unobvious to me.
PolkaDot
  • 520
  • 1
  • 7
  • 18
-1
votes
1 answer

Google Sheets - Matching Company Names

I have 2 databases, both have names of companies, but in different formats. I have been able to do exact matching using vlookup. I want to extract companies that were written differently, but they are actually the same company and extract the…
Lenny n Carl
  • 72
  • 4
-1
votes
1 answer

Search algorithm options for ontology querying?

I have developed a tool that enables searching of an ontology I authored. It submits the searches as SPARQL queries. I have received some feedback that my search implementation is all-or-none, or "binary". In other words, if a user's input doesn't…
kaixas K
  • 111
  • 12
-1
votes
1 answer

fuzzy string match python

I'm looking for a function in python that works exactly like '%' does in SQL for matching strings. I need this to match some strings that have weird spacing due to the way they were exported so I'll need to put % in between every single word to find…
mikehuuuu
  • 111
  • 1
  • 1
  • 6
-1
votes
1 answer

Fuzzy-Score batch of records against existing table

I'm trying to create a mechanism by which I can score each record in a data set based on their similarity to existing records in my database. My objective here is to identity duplicates, or potential/likely duplicates in my new list, by giving…
Andrew Williams
  • 55
  • 1
  • 10
-1
votes
1 answer

python fuzzy regex with nested or regex

I'm trying to do some fuzzy matching on a string of DNA reads. I'd like to allow for up to 1 substitution error while at the same time allowing a particular basepair to be one of two options (A or G in this case). I've started with the…
Constantino
  • 2,243
  • 2
  • 24
  • 41
-2
votes
1 answer

Fuzzy comparison of strings in lists of huge length (taking into account performance)

I have two lists: The first list I get from the database is the names of various companies (can be written in uppercase, lowercase or a combination) list_from_DB = ["Reebok", "MAZDA", "PATROL", "AsbEngland-bank", "Mazda INCC", "HIGHWAY lcc",…
Paul
  • 53
  • 3
  • 21
-2
votes
1 answer

A question about mysql timestamp query fuzzy range

thank you for you answer!!! enter image description here table is this picture SELECT * FROM vehicle_warning_message v WHERE v.capture_time >= "2023-10-03%" AND v.capture_time <= "2023-11-03%"; enter image description here Why…
a8030962
  • 1
-2
votes
1 answer

Fuzzy match and get index of a pattern from a string

I have a list of company names that I want to match against a list of sentences and get the index start and end position if a keyword is present in any of the sentences. I wrote the code for matching the keywords exactly but realized that names in…
Clock Slave
  • 7,627
  • 15
  • 68
  • 109
-2
votes
2 answers

What is the best way to search multiple columns of a database for user/client inputted information?

I have data in the following format: +---------+---------+----------+-----------+-----------+-----------+ | id | title | author | keyword_1 | keyword_2 | keyword_3 | …
Jac Frall
  • 403
  • 7
  • 15
-2
votes
1 answer

Fuzziness Setting and Meaning Matching Results in Elasticsearch in Laravel

My query is { "query": { "bool": { "filter": [ { "match": { "haloha_id": "5f2f33c2c6f0fc27e725ee8a" } } ], "must": [ { "match": { "text": { …
Programmer
  • 178
  • 1
  • 2
  • 15
1 2 3
…
63
64