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

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

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.

76 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
deflagrations	18	8	302	(None)
deflagration	17	7	347	1	deflagration_
declarations	15	4	680	2	decla_rations
deflagrating	18	5	266	2	deflagrati_ng
deflorations	16	4	606	2	defl_orations
conflagrations	20	5	272	3	conflagrations
deaerations	12	3	1167	3	de__aerations
declamations	17	4	530	3	decla_mations
declaration	14	4	783	3	decla_ration_
defalcations	18	4	519	3	def_alcations
defamations	17	4	589	3	def_a_mations
deflagrates	16	13	324	3	deflagrat__es
deflations	14	3	971	3	defl___ations
defloration	15	4	726	3	defl_oration_
deglaciations	17	5	391	3	deglaciations
delegations	13	4	803	3	de_leg_ations
denigrations	14	4	735	3	de_nigrations
celebrations	16	4	574	4	ce_lebrations
conflagration	19	5	301	4	conflagration_
deaeration	11	3	1301	4	de__aeration_
dealations	11	3	1137	4	de__a_lations
debarkations	19	4	365	4	de_barkations
decantations	15	4	794	4	de_cantations
decelerations	16	4	642	4	decelerations
declamation	16	4	610	4	decla_mation_
declinations	15	4	1022	4	decl_inations
decorations	14	3	1288	4	de__corations
defalcation	17	4	622	4	def_alcation_
defamation	16	4	684	4	def_a_mation_
defecations	17	7	900	4	def__ecations
deflagrate	15	14	339	4	deflagrat___e
deflagrated	17	13	299	4	deflagrat__ed
deflation	13	3	1065	4	defl___ation_
deflections	17	18	732	4	defl__ections
defoliations	16	4	759	4	def_oliations
deformations	18	4	684	4	def_ormations
degenerations	15	4	635	4	degenerations
deglaciation	16	5	430	4	deglaciation_
degradations	15	4	455	4	degra_dations
dehydrations	20	4	340	4	de_hydrations
delaminations	16	4	794	4	de_laminations
delations	10	26	1659	4	de_l___ations
delectations	15	4	745	4	de_lectations
delegation	12	3	888	4	de_leg_ation_
deliberations	16	4	553	4	deliberations
delineations	13	4	676	4	de_lineations
demarcations	17	4	612	4	de_marcations
denaturations	14	4	495	4	denaturations
denegations	13	4	854	4	de_neg_ations
denigration	13	4	846	4	de_nigration_
depravations	18	8	537	4	depra_vations
dermabrasions	18	6	84	4	dermabrasions
derogations	13	4	939	4	de_rog_ations
desalinations	14	4	1018	4	desalinations
desecrations	15	5	921	4	de_secrations
desiderations	15	4	567	4	desiderations
designations	14	5	694	4	de_signations
desperations	15	5	952	4	de_sperations
deuterations	13	4	808	4	de_uterations
devaluations	16	4	635	4	de_valuations
devastations	16	4	582	4	de_vastations
dilatations	12	4	641	4	d_ila_tations
divagations	16	10	383	4	d_ivag_ations
elaborations	14	4	492	4	_e_laborations
emigrations	14	18	715	4	_e_migrations
inflammations	20	10	254	4	inflammations
meliorations	14	6	675	4	me_liorations
reclamations	16	4	571	4	recla_mations
reflations	13	3	1123	4	refl___ations
refrigerations	18	6	377	4	refrigerations
relaxations	18	4	564	4	re_la_xations
relegations	12	4	897	4	re_leg_ations
remigrations	15	22	779	4	re_migrations
reparations	13	6	1166	4	re_pa_rations
replantations	15	4	486	4	replantations
separations	13	6	927	4	se_pa_rations

Search took 6 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	95024	0.360	496363.9
2	DLD Change Limit	95024	76	5.046	18831.5
3	Display Results	76	76	0.046	1652.2
	(SQL Overall)	178691	76	5.452	32775.3