Problems with Jira Text-Search

[Ulrich Kaemmerer]

I'm trying to find issues ( under issues->search for issues ) containing the text "Spaltendefinition".

When I execute this query : text ~"Spaltend" I get no result.

When I execute this query : text ~"Spaltendef" I get 2 results.

When I execute this query : text ~"Spaltendefi" I get 1 result

When I execute this query : text ~"Spaltendefinit" I get 37 results.

As far as I understand "~" means contains ( or is similar to the regex "~" case insensitive )
How can I get this results ? 

Thanks in advance

[Mykenna Cepek · Accepted solution]

This might help explain the features Jira Server offers when searching text fields: 

https://confluence.atlassian.com/jirasoftwareserver/search-syntax-for-text-fields-939938747.html

[Ulrich Kaemmerer]

I raised my question because I read the documentation.

"~" means substring(case insensitive) 
Therefore I expect that the search: 'text ~ ''New"' always returns more or equal to results than the search: 'text ~ ''New York"', or not ?
This is what I wrote in my question

[Mykenna Cepek]

Perhaps your original post results are due to Word Stemming? I don't know German, but my brief research suggests that as a possibility.

Might be worth experimenting with that setting in Jira (warning: it's a global setting).

Word Stemming is detailed near the end of the page I linked above.

[Ulrich Kaemmerer]

Hi Mykenna,

this might be an issue.
I thought the "~" is a real substring()-search but it seams it is not.
I will ask the administrator regarding the stemming settings and I will add the outcome here.