: Solr, SQL Server's LIKE
On 12/29/2011 3:51 PM, Devon Baumgarten wrote:
N-Grams get me pretty great results in general, but I don't want the results
for this particular search to be fuzzy. How can I prevent the fuzzy matches
from appearing?
Ex: If I search Albatross I want Albert
Thanks, Erick! That sounds great. I really do have to upgrade.
Chantal
On Sun, 2012-01-01 at 16:42 +0100, Erick Erickson wrote:
Chantal:
bq: The problem with the wildcard searches is that the input is not
analyzed.
As of 3.6/4.0, this is no longer entirely true. Some analysis is
On 12/29/2011 3:51 PM, Devon Baumgarten wrote:
N-Grams get me pretty great results in general, but I don't want the results
for this particular search to be fuzzy. How can I prevent the fuzzy matches
from appearing?
Ex: If I search Albatross I want Albert to be excluded completely, rather
[mailto:hossman_luc...@fucit.org]
Sent: Thursday, December 29, 2011 7:00 PM
To: solr-user@lucene.apache.org
Subject: RE: Solr, SQL Server's LIKE
: Thanks. I know I'll be able to utilize some of Solr's free text
: searching capabilities in other search types in this project. The
: product manager
The problem with the wildcard searches is that the input is not
analyzed. For english, this might not be such a problem (except if you
expect case insenstive search). But than again, you don't get that with
like, either. Ngrams bring that and more.
What I think is often forgotten when comparing
are the source of all my current
problems. :)
Thanks!
Devon Baumgarten
-Original Message-
From: Chris Hostetter [mailto:hossman_luc...@fucit.org]
Sent: Thursday, December 29, 2011 7:00 PM
To: solr-user@lucene.apache.org
Subject: RE: Solr, SQL Server's LIKE
: Thanks. I know I'll be able to utilize
for a simple, hackish (albeit inefficient) approach look up wildcard searchers
e,g foo*, *bar
On Thu, Dec 29, 2011 at 12:38 PM, Devon Baumgarten
dbaumgar...@nationalcorp.com wrote:
I have been tinkering with Solr for a few weeks, and I am convinced that it
could be very helpful in many of
I have been tinkering with Solr for a few weeks, and I am convinced that it
could be very helpful in many of my upcoming projects. I am trying to decide
whether Solr is appropriate for this one, and I haven't had luck looking for
answers on Google.
I need to search a list of names of companies
SQLs like is usually handled with ngrams if you want
*stuff* kinds of searches. Wildcards are interesting
in Solr.
Things Solr handles that aren't easy in SQL
Phrases, phrases with slop, stemming,
synonyms. And, especially, some kind
of relevance ranking.
But Solr does NOT do the things SQL is
, December 29, 2011 3:44 PM
To: solr-user@lucene.apache.org
Subject: Re: Solr, SQL Server's LIKE
SQLs like is usually handled with ngrams if you want
*stuff* kinds of searches. Wildcards are interesting
in Solr.
Things Solr handles that aren't easy in SQL
Phrases, phrases with slop, stemming
Hi Devon,
Have you considered using a permuterm index? Its workable, but depending
on your requirements (size of fields that you want to create the index
on), it may bloat your index. I've written about it here:
http://sujitpal.blogspot.com/2011/10/lucene-wildcard-query-and-permuterm.html
: Thanks. I know I'll be able to utilize some of Solr's free text
: searching capabilities in other search types in this project. The
: product manager wants this particular search to exactly mimic LIKE%.
...
: Ex: If I search Albatross I want Albert to be excluded completely,
: rather
12 matches
Mail list logo
