Wildspeed: http://www.sai.msu.su/~megera/wiki/wildspeed
Looks like a great way to do Like '%term%' matching in a fast efficient way, albeit with huge indexes.
I'm looking for something similar for Sql Server. Full Text Search is not working for partial word matches, so please don't suggest that unless you have a way to use Full Text Search for a fast like wildcard match.