How to optimize search query work fast?

How to optimize search query work fast?

query = "SELECT" + " e.id AS _id," + " ke.id AS ke_id,"
+ " ke.fk as ke_fk," + " ke.value as ke_value,"
+ " re.id AS ke_id," + " re.fk as re_fk,"
+ " re.value as re_value," + " s.id AS s_id,"
+ " s.fk as s_fk," + " g.id AS g_id," + " g.fk as g_fk,"
+ " g.lang," + " g.value as g_value" + " FROM entry e"
+ " INNER JOIN k_ele ke ON e.id = ke.fk"
+ " INNER JOIN r_ele re ON e.id = re.fk"
+ " INNER JOIN sense s ON e.id = s.fk"
+ " INNER JOIN gloss g ON s.id = g.fk"
+ " WHERE re.value like '" + hiragana
+ "%' OR g.value like '" + lookingFor
+ "%' OR g.value like '%" + strSpace + lookingFor
+ "%' GROUP BY s.id LIMIT 5 ";
This query takes data from SQLite database and taken data is put into
listview. It is working very slow even if I have put LIMIT 5. What should
be done in order to make search work fast?