# Not enough efficient number search

**URL:** <https://discuss.elastic.co/t/not-enough-efficient-number-search/77811>\
**Category:** Elasticsearch\
**Created:** [March 8, 2017, 12:10pm UTC](https://discuss.elastic.co/t/not-enough-efficient-number-search/77811 "2017-03-08T12:10:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Grigorios\_Loukidis](https://avatars.discourse-cdn.com/v4/letter/g/f17d59/32.png) [@Grigorios\_Loukidis](https://discuss.elastic.co/u/Grigorios_Loukidis)\
**Post date:** [March 8, 2017, 12:10pm UTC](https://discuss.elastic.co/t/not-enough-efficient-number-search/77811/1 "2017-03-08T12:10:47Z")

</div>

I am trying to search to number fields in elastic.  
When I am searching for 39693 and type 39693 I get the right result.  
But when I am typing 963 I don't get any result.

var response = client1.Search(n =\> n.Index(index)  
.Type(type)  
.Query(q =\> q.ConstantScore(f =\> f.Filter(t =\> t.Term(documentField, searchWord))))  
.Size(searchSize)  
.From(0)

```
                    .Sort(s => s.Descending(SortSpecialField.Score))
                    .TrackScores(true));
```

---

<div class="post-metadata">

**Author:** ![xavierfacq](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/xavierfacq/32/8744_2.png) [@xavierfacq](https://discuss.elastic.co/u/xavierfacq)\
**Post date:** [March 8, 2017, 1:52pm UTC](https://discuss.elastic.co/t/not-enough-efficient-number-search/77811/2 "2017-03-08T13:52:50Z")

</div>

The doc says :

```
The term query finds documents that contain the exact term specified in the inverted index. For instance:

```

[https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-term-query.html#query-dsl-term-query](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-term-query.html#query-dsl-term-query)

---

<div class="post-metadata">

**Author:** ![Grigorios\_Loukidis](https://avatars.discourse-cdn.com/v4/letter/g/f17d59/32.png) [@Grigorios\_Loukidis](https://discuss.elastic.co/u/Grigorios_Loukidis)\
**Post date:** [March 8, 2017, 1:56pm UTC](https://discuss.elastic.co/t/not-enough-efficient-number-search/77811/3 "2017-03-08T13:56:18Z")

</div>

How can I set it finding numbers with one more or one less digit?

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [March 8, 2017, 2:10pm UTC](https://discuss.elastic.co/t/not-enough-efficient-number-search/77811/4 "2017-03-08T14:10:32Z")

</div>

It looks like you want to treat your number as a string and search for partial matches. If this is the case you may be able to use [ngrams](https://www.elastic.co/guide/en/elasticsearch/reference/5.2/analysis-ngram-tokenizer.html).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 5, 2017, 2:10pm UTC](https://discuss.elastic.co/t/not-enough-efficient-number-search/77811/5 "2017-04-05T14:10:32Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.