SQL wildcard match part of value

In a table I store the names of people and I wanted to use a wildcard to check if a part of students name is found. I tried using wild cards and this works if the condition value length is shorter than a value already in the database e.g

WHERE name LIKE '%Stu%'

And I have a person called 'Stuart', this will return a row, however if say I miss type the students name and it is longer than the stored i.e:

WHERE name LIKE '%Stuarfd%'

there I will get no results returned. Is there anyway to match only part of the string?