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
Another alternative which I've implemented is a custom mechanism that retrieves a list of matching unique ids from a database table using a SQL LIKE, then passes this list as a filter to the main query. Its hacky, but I was building a custom handler anyway, so it was quite simple to add in. -sujit On Thu, 2011-12-29 at 11:38 -0600, 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 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 and individuals pretty exactly. > T-SQL's LIKE operator does this with decent performance, but I have a feeling > there is a way to configure Solr to do this better. I've tried using an edge > N-gram tokenizer, but it feels like it might be more complicated than > necessary. What would you suggest? > > I know this sounds kind of 'Golden Hammer,' but there has been talk of other, > more complicated (magic) searches that I don't think SQL Server can handle, > since its tokens (as far as I know) can't be smaller than one word. > > Thanks, > > Devon Baumgarten >
