How to get a sorted RealmResult based on the query string position in index fields string?

[razon30]

When performing query, I want to get a RealmResult where the search field starts with query text will be added first, then the strings that contains the query string somewhere in the search field except start and end. And at last there will be objects whose search fields ends with search query.

For example, I have data = {"razon", "zebra", "fixar", "razib", "furan"} . Now, if I query with "ra", I want the realm result to return data in this order, result = {"razon", "razib" , "furan", "zebra"}

In the example, "razon" and "razib" starts with "ra", so they are in the front, then comes "furan" as ra is in somewhere in the string except start and end. And at the last "zebra" is added cause it ends with "ra".
How can I do it with a single query or in a efficient way?

[Zhuinden]

Realm sort by string is lexicographical, so that would mean you'd need to do this transformation yourself on detached instances.

[cmelchior]

Yes, this unfortunately not something you can express directly in our sorting logic.
Being able to do it is a duplicate of #2744

For now, you would need to use copyFromRealm and do custom sorting.