CODEWITHSUNDEEP
sqlsql-serversql-server-2005
Ronald McDonald
Ronald McDonald

Reputation: 2911

Spellcheck Data in SQL Server

We have a large database with hundreds of tables that have lookup text stored in them with spelling errors from when the application was originally written offshore. Is there a way to run a spellcheck on the data in sql server so we can find all of these errors quickly?

Upvotes: 3

Views: 8827

Answers (3)

Andre
Andre

Reputation: 108

Just stumbled across this one.

Another way to do this is using Microsoft Access, using ODBC, link to the tables on SQL side, then open the table in access and run the spellcheck in Access, you can update the corrections on the fly.

Upvotes: 0

Wil
Wil

Reputation: 4270

  1. Export your data to Excel.
  2. Distribute the sheets to multiple people to break up the work load
  3. Have them run spell check to identify the misspelled words.
  4. Gather up the bad records and create update statements from the db.
  5. Don't offshore applications where English spelling is important.

EDIT: I should have pointed out, you might use the spell check to identify the issues but you want human eyes on the actual data as well as suggested fixes. Thus, being able to spread the work around to run the spell check is important. There won't be any fully automated solution that will catch everything, or worse it will catch too much and muck the data up worse.

Upvotes: 1

Joe Stefanelli
Joe Stefanelli

Reputation: 135858

One thought - You could write a CLR function to access the spell checker included with Microsoft Word. See: Walkthrough: Accessing the Spelling Checker in Word for a starting point.

Upvotes: 3

Related Questions