# Crate db full text search phrase\_prefix does not return everything need to be returned

**URL:** <https://community.cratedb.com/t/crate-db-full-text-search-phrase-prefix-does-not-return-everything-need-to-be-returned/1937>\
**Category:** CrateDB\
**Created:** [December 26, 2024, 11:37am UTC](https://community.cratedb.com/t/crate-db-full-text-search-phrase-prefix-does-not-return-everything-need-to-be-returned/1937 "2024-12-26T11:37:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yusuf\_Cansiz](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/yusuf_cansiz/32/1320_2.png) [@Yusuf\_Cansiz](https://community.cratedb.com/u/Yusuf_Cansiz)\
**Post date:** [December 26, 2024, 11:37am UTC](https://community.cratedb.com/t/crate-db-full-text-search-phrase-prefix-does-not-return-everything-need-to-be-returned/1937/1 "2024-12-26T11:37:45Z")

</div>

In CrateDB we are makıng Fulltext search we have a huge data like 69 million rows. When we make searches with analyzer only with standart tokenizer and lowercase filter and phrase\_prefix included it seems like cratedb does not match everything. It is missing many rows with valid matches. with small db it works good. Did anybody make same kind of search in such big data and faced similar issue? Is there anybody who can help us the trace what is happening.

---

<div class="post-metadata">

**Author:** ![hernanc](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/hernanc/32/676_2.png) [@hernanc](https://community.cratedb.com/u/hernanc)\
**Post date:** [December 27, 2024, 8:38am UTC](https://community.cratedb.com/t/crate-db-full-text-search-phrase-prefix-does-not-return-everything-need-to-be-returned/1937/2 "2024-12-27T08:38:12Z")

</div>

Hi, could you share your table and analyzer definitions, the query you are using and examples of strings that match and strings you would expect to match and are not matching?

---

<div class="post-metadata">

**Author:** ![Yusuf\_Cansiz](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/yusuf_cansiz/32/1320_2.png) [@Yusuf\_Cansiz](https://community.cratedb.com/u/Yusuf_Cansiz)\
**Post date:** [March 14, 2025, 2:12am UTC](https://community.cratedb.com/t/crate-db-full-text-search-phrase-prefix-does-not-return-everything-need-to-be-returned/1937/3 "2025-03-14T02:12:42Z")

</div>

> [@Yusuf\_Cansiz](#):
>
> se\_prefix included it seems like cratedb does not match everything. It is missing many rows with valid matches. with small db it works good. Did an

Hello Hernanc thank you for your answer we found the problem it seems like there is a parameter called max\_expansions it was causing this error we fixed the issue by increasing the value of max\_expansion