fts-alfresco search provides wrong result when searching with keyword s*

[sheljit]

I was searching for nodes(in node browser) with an attribute containing value *pks*(@xyz:attribute\:*pks*)and in result am getting the node with value pkk. Below is few test cases and results

search keyword        results

*pks*                         node containing "pkk"

*pkq*                         no results found

*pkk*                         node containing "pkk"

The same can be replicated with cm:name field also. 

For cm:name:*xls*  -- > results have nodes with xls, xle, xlu

Alfresco version : 5.0.3.5

It would be so helpful if someone could help me on this.

Thanks in advance!

[jpotts]

This is cross-posted at Stack Exchange where a discussion of stemming has already begun.

[sheljit]

I was advised to use a different field type in Stack Exchange. I would like to know is there any other way to get the correct result without changing the indexing, may be by modifying the query or something. We are using the Alfresco out of box schema for indexing and would like to continue the same way.