I'm not sure a function is required for this. Have you considered:

declare @ToFind varchar(10)

declare @InString varchar(20)

set @ToFind = 'llo'

set @InString = 'Hello World, Hello World'

select LEN(@InString) - CharIndex(reverse(@ToFind),reverse(@InString)) - 1

This returns: 16