Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “clarifications” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

34 similar words found! Changes to Transform each Found Word to your word are shown as:
~~remove a letter~~ ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
clarifications	21	5	526	(None)
clarification	20	4	576	1	clarification_
calcifications	20	4	541	2	calcifications
caprifications	23	8	556	2	caprifications
classifications	22	8	308	2	classifications
coalifications	21	5	570	2	coalifications
glorifications	20	7	458	2	glorifications
scarifications	21	5	576	2	scarifications
basifications	20	13	706	3	_basifications
beatifications	21	15	746	3	beatifications
calcification	19	4	582	3	calcification_
caprification	22	5	605	3	caprification_
certifications	21	4	779	3	certifications
citifications	20	4	854	3	c_itifications
classification	21	11	321	3	classification_
claudications	18	5	288	3	cla_udications
coalification	20	4	613	3	coalification_
codifications	21	12	762	3	c_odifications
cornifications	21	4	595	3	cornifications
falsifications	22	4	497	3	falsifications
gasifications	19	11	684	3	_gasifications
glorification	19	8	489	3	glorification_
gratifications	20	4	598	3	gratifications
nazifications	27	4	552	3	_nazifications
nitrifications	19	8	663	3	nitrifications
pacifications	22	6	735	3	_pacifications
petrifications	21	4	802	3	petrifications
purifications	20	4	746	3	_purifications
qualifications	28	4	458	3	qualifications
ramifications	20	8	753	3	_ramifications
ratifications	18	9	978	3	_ratifications
scarification	20	5	640	3	scarification_
verifications	21	15	997	3	_verifications
vitrifications	22	7	596	3	vitrifications

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	43548	0.296	603685.8
2	DLD Change Limit	43548	34	1.780	24465.2
3	Display Results	34	34	0.033	1030.3
	(SQL Overall)	178691	34	2.109	84727.8