You can specify a search value that ignores a given number of characters. The underscore (_) in the following condition means to ignore the character between LE and DS. In other words, search for LE, followed by any one character, followed by DS.
LIKE 'LE_DS'
This singles out the name LEEDS from the NAMES column.
Enclose values containing underscore characters in single quotation marks (to prevent search values from being mistaken for example elements).
Use a specific number of underscores to indicate that you want that number of characters ignored. For example, for an 8-character column of part numbers, you can use the following condition to search it for the combination G2044 in positions 2 through 6. The first character and the last two can be any characters.
LIKE '_G2044_ _'