Solr difficulty getting fuzzy search with multiple terms

Question

Suppose someone's name is Alessia Keeling. I'm having difficulty getting the following queries to work

q=Alessia Keeling returns a result

q=Alessia returns a result

q=Alessia Keel returns a result

however,

q=Alessia Keeli and q=Alessia Keelin returns no results

I've tried quite a few things here in my schema.xml file, but I don't have much METHOD to my MADNESS.

<fieldType name="text" class="solr.TextField" omitNorms="false">
  <analyzer type="index">
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.StandardFilterFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.ReversedWildcardFilterFactory"/>
  </analyzer>
   <analyzer type="query">
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.StandardFilterFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.EdgeNGramFilterFactory" minGramSize="2" maxGramSize="20" side="front"/>
  </analyzer>
</fieldType>

Solr Admin Analyzer shows that it will match both "Alessia" and various forms of "Keeling", but Sunspot is still returning no results.

Edit 1

Here is console testing

(byebug) Sunspot.commit 
(byebug) Sunspot.index
(byebug) User.search {|q| q.fulltext "Alessia Keeling" }.hits 
[#<Sunspot::Search::Hit:User 4>]  
(byebug) User.search {|q| q.fulltext "Alessia Keelin" }.hits 
[]

Edit 2 I was finally able to get somewhere. I looked in some of my log files and noticed that the call my app was making to solr was using the query string

"http://localhost:8981/solr/select?fq=type%3AUser&q=Eli+Donnelly+I&fl=%2A+score&qf=email+first_name_text+last_name_text+username_text+name_text+description_text&defType=dismax&start=0&rows=30&debugQuery=true

This printed out some useful information, most useful being "parsedQuery" I was able to see that another field was conflicting. I have another field that handles emails and in this latter case where my query string was "Eli Donnely I", the sole letter token "I" was breaking the query because of the email field. Adding a length filter fixed it.

Answer 1

I've tried this from the Solr side with an example core, and the match is returned with the NGram filter while indexing. You might want to check the server side logs to see that you're actually reindexing, at least.

The field definition is as follows:

<fieldType name="text" class="solr.TextField" omitNorms="false">
  <analyzer type="index">
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.StandardFilterFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.ReversedWildcardFilterFactory"/>
    <filter class="solr.EdgeNGramFilterFactory" minGramSize="2" maxGramSize="20" side="front"/>
  </analyzer>
   <analyzer type="query">
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.StandardFilterFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
  </analyzer>
</fieldType>

data.json:

[{"id": 1, "text": "Alessia Keeling"}, {"id": 2, "text": "Alessia Fubar"}]

Populate it with data:

curl http://localhost:8983/solr/collection1/update\?commit\=true --data-binary @data.json -H 'Content-type:application/json'

Searching:

GET http://localhost:8983/solr/collection1/select\?q\=alessia%20keelin\&q.op\=AND 
[..]
<result name="response" numFound="1" start="0"><doc><int name="id">1</int><str name="text">Alessia Keeling</str><long name="_version_">1473248002863792128</long></doc>  </result>

.. which returns the promised document, while keeping the non-matching document out of the result.