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

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

57 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
delectations	15	4	745	(None)
delectation	14	4	855	1	delectation_
defecations	17	7	900	2	defec_ations
delectating	15	4	599	2	delectati_ng
delegations	13	4	803	2	dele_gations
desecrations	15	5	921	2	desecrations
detestations	13	4	758	2	detestations
reluctations	14	4	675	2	reluctations
affectations	20	4	343	3	affectations
celebrations	16	4	574	3	celebrations
cementations	16	5	901	3	cementations
deaerations	12	3	1167	3	deae_rations
decantations	15	4	794	3	decantations
dedications	15	3	1087	3	dedic_ations
defecation	16	7	980	3	defec_ation_
defections	16	15	1020	3	defec__tions
deflections	17	18	732	3	deflec__tions
deglaciations	17	5	391	3	deglaciations
degustations	14	4	483	3	degustations
dejections	20	16	835	3	dejec__tions
delations	10	26	1659	3	del___ations
delectates	13	4	819	3	delectat__es
delegation	12	3	888	3	dele_gation_
deletions	10	26	1093	3	dele___tions
delimitations	16	7	663	3	delimitations
delineations	13	4	676	3	delineations
denegations	13	4	854	3	dene_gations
denervations	16	5	709	3	denervations
denotations	12	3	985	3	de_notations
dentations	11	4	1363	3	d__entations
deportations	15	4	846	3	deportations
deprecations	17	4	856	3	deprec_ations
depreciations	18	4	658	3	depreciations
deputations	14	4	834	3	de_putations
desecration	14	4	1007	3	desecration_
desiccations	17	5	565	3	desiccations
detections	13	14	1004	3	detec__tions
detestation	12	4	836	3	detestation_
devastations	16	4	582	3	devastations
dictations	13	8	970	3	d__ictations
dilatations	12	4	641	3	dil_atations
elections	11	24	1497	3	_elec__tions
elevations	13	3	863	3	_ele_vations
elicitations	14	4	680	3	_elicitations
eructations	13	4	723	3	_eructations
execrations	20	4	892	3	_execrations
expectations	23	6	584	3	expectations
felicitations	18	7	458	3	felicitations
hebetations	16	5	646	3	hebe_tations
lactations	12	3	942	3	__lactations
molestations	14	7	547	3	molestations
peltations	12	3	1155	3	pel__tations
relegations	12	4	897	3	rele_gations
relocations	13	3	1114	3	reloc_ations
reluctation	13	4	796	3	reluctation_
selections	12	3	1087	3	selec__tions
vegetations	15	4	732	3	vege_tations

Search took 5 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.346	516448.0
2	DLD Change Limit	95024	57	3.936	24142.3
3	Display Results	57	57	0.046	1239.1
	(SQL Overall)	178691	57	4.328	41287.2