# Search function returning approximate results?

**URL:** <https://meta.discourse.org/t/search-function-returning-approximate-results/209536>\
**Category:** Bug\
**Created:** [November 18, 2021, 2:41pm UTC](https://meta.discourse.org/t/search-function-returning-approximate-results/209536 "2021-11-18T14:41:05Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)\
**Post date:** [November 22, 2021, 1:17am UTC](https://meta.discourse.org/t/search-function-returning-approximate-results/209536/6 "2021-11-22T01:17:24Z")

</div>

> [@Canapin](#):
>
> Are the lexemes language-related?

This stuff is configurable in Postgres, but the French implementation in Postgres is the thing reducing this all the way down:

```plaintext
discourse_development=# select to_tsvector('french', 'passants');
 to_tsvector
-------------
 'pass':1
(1 row)

discourse_development=# select to_tsvector('english', 'passants');
 to_tsvector
-------------
 'passant':1
(1 row)

```

There are more fancy dictionaries that can be used, but they are extremely complicated to configure.

---

_[View the full topic](https://meta.discourse.org/t/search-function-returning-approximate-results/209536)._