*Update:* Newer versions of Android now include this functionality. However as of 4.1.2 I still can't get it to work. I set up all my family and friends with different patterns and notification sounds, but I always get the default text sound no matter who texts, so I'm keeping this...
This is a free Demo of Personalized SMS Notifications. It does everything the full version does, except play the sounds. If you are unsure you want to buy the full version, we suggest you download this free version and test first.