My gosh, I'd be scared out of my mind if I got an injury half as bad as yours! May you continue to have strength as you work through this!
Honestly there really wasn't a lot of pain when I got my sprain, just the initial nasty twinge when the injury occurred. Sometimes when I was sleeping and turned wrong or sitting/bending a certain way I would get these "spasms" like, but other than that it was a constant, dull ache that burned a little bit.
I started taking the Glucosamine/Chondroiton/MSM on that Sat. night, just a few hours after the sprain occurred. I used ice off and on the first few days. After three days (and day 1 of chiro) there were no more "spasms", just kind of a tight feeling in that area. Now, after a week, I feel almost completely normal. It could be the supplement and/or the chiro, maybe not, but I feel better so I'm not concerned one way or another.
It can take a long time for ligaments (and other tissues) to heal, especially in your back. Nearly all we do uses our back, which makes it difficult to stop everything so we can experience a total recovery.