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

Here are the results of your fuzzy-string dictionary search for “deflagrating” 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.

67 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
deflagrating	18	5	266	(None)
deflagration	17	7	347	2	deflagration
deflagrations	18	8	302	2	deflagrations
deaerating	12	3	1156	3	de__aerating
defalcating	18	4	434	3	def_alcating
deflagrate	15	14	339	3	deflagrat__e
deflagrated	17	13	299	3	deflagrat_ed
deflagrates	16	13	324	3	deflagrat_es
deflating	14	26	1071	3	defl___ating
delegating	13	3	767	3	de_leg_ating
denigrating	14	14	692	3	de_nigrating
beflagging	18	4	282	4	beflag__ging
celebrating	16	4	611	4	ce_lebrating
decelerating	16	4	559	4	decelerating
declaration	14	4	783	4	decla_ration
declarations	15	4	680	4	decla_rations
declarative	17	5	431	4	decla_rative
declaring	13	3	957	4	decla_r__ing
decorating	14	3	1207	4	de__corating
defatting	14	3	610	4	def_a__tting
defaulting	15	4	339	4	def_a_ulting
defeating	14	23	1197	4	def___eating
defecating	17	23	778	4	def__ecating
defleaing	14	4	474	4	defl__ea_ing
deflecting	17	3	650	4	defl__ecting
defloration	15	4	726	4	defl_oration
deflorations	16	4	606	4	defl_orations
defoliating	16	4	582	4	def_oliating
defragging	17	4	282	4	defrag__ging
defraying	17	3	585	4	def___raying
degenerating	15	4	566	4	degenerating
degrading	13	13	737	4	de___grading
dehydrating	20	4	365	4	de_hydrating
delaminating	16	4	568	4	de_laminating
delating	10	31	1960	4	de_l___ating
delectating	15	4	599	4	de_lectating
deliberating	16	4	512	4	deliberating
delighting	16	4	499	4	de_lig_hting
delineating	13	4	637	4	de_lineating
demarcating	17	4	520	4	de_marcating
denitrating	13	12	833	4	de_nitrating
departing	13	4	951	4	de_pa_r_ting
deprograming	19	6	336	4	deprograming
depurating	14	3	864	4	de__purating
derating	10	32	2228	4	de____rating
derogating	13	4	863	4	de_rog_ating
desalinating	14	7	631	4	desalinating
desecrating	15	4	809	4	de_secrating
desiderating	15	4	469	4	desiderating
designating	14	4	607	4	de_signating
deuterating	13	4	727	4	de_uterating
devaluating	16	4	505	4	de_valuating
devastating	16	4	470	4	de_vastating
diagraming	15	4	438	4	d__iagraming
divagating	16	4	400	4	d_ivag_ating
edulcorating	16	5	205	4	edulcorating
elaborating	14	4	486	4	_e_laborating
emigrating	14	6	750	4	_e_migrating
meliorating	14	4	656	4	me_liorating
reflagging	16	4	348	4	reflag__ging
reflating	13	25	1471	4	refl___ating
refloating	14	19	832	4	refl__oating
refrigerating	18	5	318	4	refrigerating
regrating	11	13	1621	4	re___grating
relegating	12	3	948	4	re_leg_ating
remigrating	15	4	759	4	re_migrating
separating	13	4	864	4	se_pa_rating

Search took 8 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	124790	0.390	458182.1
2	DLD Change Limit	124790	67	6.576	18976.6
3	Display Results	67	67	0.033	2030.3
	(SQL Overall)	178691	67	6.999	25530.9