Quantifying Text differences in TSQL

In TSQL there is a limit to the way you can compare text strings. They're either equal or not. Sooner...