What is the best practice of filtering by unicode character? SQLite

What is the best practice of filtering by unicode character? SQLite

I am having hard time to find any solutions for my problem,
var sql = "select e.id, e.Word, e.Definition " +
"from words e " +
"where e.Word LIKE '%" + index + "%' order by e.Word LIMIT
64 ";
this code is working fine for latin alphabet, but doesn't filter cyrillic.
Also, I usually use charindex in MSSQL to filter words, which is way
faster then LIKE
Select top 100 word from words where charindex(' ' + '" + index + "',' '+
word)>0
but in SQLite there is no any information I found for me.
Would be great if you help me with this two issues.
Thanks.