While ranitb's solution will work, you're going to run into problems doing the similarity check based only on the leading word or even a couple of words.  There will also...

Do you spend any time outside of work, on your own, learning new features?

Why not just change the Dev database to the SIMPLE recovery model?

Heh.... "Updated_By".  One of the most commonly overlooked reasons for massive fragmentation both physical and logical.

How many hours per day do you work?

So far, we've all speculated.  What we need is to hear from the OP as to a wee bit more detail about the DDL for the table, number of rows,...

It sounds like the drive where your logfiles are stored went offline or somehow lost connection.  This likely won't be an SQL Server problem.

Although there is some good merit in a guaranteed "only 2 values" (pickup/dropoff) type of table, a proper CROSSTAB would likely blow the doors off of any view you might...

As always, "It Depends".  What will the computed columns be doing?