RE: Solr, SQL Server's LIKE

2012-01-04 Thread Devon Baumgarten
t: Re: 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

Re: Solr, SQL Server's LIKE

2012-01-02 Thread Shawn Heisey
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

Re: Solr, SQL Server's LIKE

2012-01-02 Thread Chantal Ackermann
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 >

Re: Solr, SQL Server's LIKE

2012-01-01 Thread Erick Erickson
; > -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 some of Solr

RE: Solr, SQL Server's LIKE

2011-12-30 Thread Devon Baumgarten
me realize that the n-grams 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

RE: Solr, SQL Server's LIKE

2011-12-30 Thread Chantal Ackermann
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 '

RE: Solr, SQL Server's LIKE

2011-12-29 Thread Chris Hostetter
: 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, : rat

Re: Solr, SQL Server's LIKE

2011-12-29 Thread Sujit Pal
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 Anothe

RE: Solr, SQL Server's LIKE

2011-12-29 Thread Devon Baumgarten
ilto:erickerick...@gmail.com] Sent: Thursday, 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 Sol

Re: Solr, SQL Server's LIKE

2011-12-29 Thread Erick Erickson
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 i

Re: Solr, SQL Server's LIKE

2011-12-29 Thread Shashi Kant
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 wrote: > 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 t