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

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

68 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
mitigation	13	4	864	(None)
litigation	11	4	817	1	litigation
mitigations	14	4	762	1	mitigations
litigations	12	4	733	2	litigations
mitigating	14	4	743	2	mitigating
mitigative	16	4	409	2	mitigative
mitigator	12	4	541	2	mitigat_or
motivation	15	4	808	2	motivation
mutilation	12	4	975	2	mutilation
titivation	13	4	703	2	titivation
vitiation	12	3	956	2	viti_ation
activation	15	6	1013	3	activation
castigation	14	4	797	3	castigation
ciliation	11	11	1249	3	cili_ation
citation	10	3	1436	3	cit__ation
divagation	15	10	437	3	divagation
divination	14	13	923	3	divination
estimation	12	4	1084	3	estimation
estivation	13	4	981	3	estivation
filiation	12	11	1024	3	fili_ation
fumigation	16	4	562	3	fumigation
fustigation	15	4	521	3	fustigation
imitation	11	5	1085	3	_imitation
immigration	16	4	417	3	immigration
initiation	10	4	1210	3	initi_ation
instigation	12	4	924	3	instigation
intimation	12	4	1304	3	intimation
irrigation	11	4	780	3	irrigation
iteration	9	5	1503	3	_iteration
levigation	14	4	702	3	levigation
ligation	9	23	1309	3	__ligation
limitation	12	4	915	3	limitation
literation	10	5	1141	3	literation
litigating	12	4	674	3	litigating
litigator	10	4	550	3	litigat_or
marination	12	3	1281	3	marination
mastication	15	6	1029	3	mastication
maturation	12	4	951	3	maturation
mediation	12	3	1229	3	medi_ation
medication	15	4	1117	3	medication
meditation	13	4	1074	3	meditation
metrication	15	4	1065	3	metrication
migration	12	17	970	3	mi_gration
miscitation	15	4	777	3	miscitation
mitigate	11	4	869	3	mitigat__e
mitigated	13	4	708	3	mitigat_ed
mitigates	12	4	825	3	mitigat_es
mitigators	13	4	537	3	mitigators
mitigatory	16	4	399	3	mitigatory
motivations	16	4	709	3	motivations
multination	13	4	897	3	multination
mutation	10	14	1288	3	mut__ation
mutilations	13	4	864	3	mutilations
navigation	14	4	600	3	navigation
nitration	9	3	1344	3	nit_ration
obligation	13	4	678	3	obligation
patination	12	3	1257	3	patination
pixilation	19	4	591	3	pixilation
satiation	9	3	1343	3	sati_ation
sibilation	12	12	877	3	sibilation
situation	9	4	942	3	sit_uation
titillation	11	4	504	3	titillation
titivations	14	4	626	3	titivations
titration	9	3	1054	3	tit_ration
unitization	20	4	813	3	unitization
urtication	12	4	911	3	urtication
visitation	13	4	859	3	visitation
vitiations	13	3	874	3	viti_ations

Search took 7 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	140603	0.156	1145455.1
2	DLD Change Limit	140603	68	5.890	23871.5
3	Display Results	68	68	0.033	2060.6
	(SQL Overall)	178691	68	6.079	29394.8