How to search based on first alphabet of consecutive words

[rubs sin]

Hi,

We have a requirement to search for first alphabet of the consecutive words, for example if the column contains values:
This is new car
This is car new
This is old car
Tin is old

When user search for "tin" then it should only return first row since t i n are 1st alphabet of consecutive words. We can do following in SQL Server so trying to find equivalent fulltext query in mysql:
SELECT * FROM dbo.TBL_NAME
WHERE contains(field_name,N'"t* i* n*"') ;