The search is not sensitive to the case (uppercase/lowercase).

% means every char.

Ie: hit good% in the English field will return every match starting with good like good, goodbye, good night,...

Ie: hit %day% in the English field will return every match whith "Day" in it like day, good day, daytime