Using sql server queries in elasticsearch 5.6.3

How can I use LIKE condition in calling search url?
using LIKE condition is diffrent and seperate from autocomplete option?
I used this:
http://localhost:9200/_search?q=servername:"*name*"+OR+action:"*convert*"
but it results wrong

Please ask Elasticsearch questions in the Elasticsearch category.

How can I set "Subject" and "Decription" columns on an index with having CompletionField property for using suggestion on search,
For implement a complete search structure what I needed? and how can I make the structure for that (mean defining index and type...)?
My this question is related to this topic?

Is there any recommendation?