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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

133 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
decapitates	16	5	564	(None)
decapitate	15	4	587	1	decapitate_
decapitated	17	4	494	1	decapitated
decapitator	16	5	380	2	decapitator
decapitators	17	5	326	2	decapitators
decrepitates	17	9	307	2	decrepitates
capitate	12	17	1218	3	__capitate_
capitated	14	15	904	3	__capitated
cavitates	14	16	896	3	__cavitates
deactivates	17	4	439	3	deactivates
deaminates	13	4	938	3	de_aminates
debilitates	14	4	447	3	debilitates
decapitating	18	5	495	3	decapitating
decapitation	17	4	868	3	decapitation
decapitations	18	4	766	3	decapitations
decimates	14	4	1069	3	dec__imates
decrepitate	16	9	309	3	decrepitate_
decrepitated	18	7	261	3	decrepitated
delaminates	14	5	690	3	delaminates
depilates	12	3	1092	3	de__pilates
deracinates	14	4	586	3	deracinates
desalinates	12	4	621	3	desalinates
devastates	14	4	466	3	deva_states
dilapidates	15	5	261	3	dilapidates
precipitates	18	5	463	3	precipitates
recapitulates	17	5	268	3	recapitulates
agitates	9	3	1088	4	___agitates
califates	14	3	1011	4	__califates
capacitates	17	5	301	4	capacitates
capiases	12	3	925	4	__capi_ases
capitals	12	20	945	4	__capita_ls
capitulates	15	5	442	4	__capitulates
captivates	17	4	549	4	__captivates
caritases	11	3	976	4	__caritases
cavitate	13	15	983	4	__cavitate_
cavitated	15	17	735	4	__cavitated
cogitates	12	4	786	4	__cogitates
crepitates	14	8	590	4	_crepitates
deactivate	16	4	462	4	deactivate_
deactivated	18	4	373	4	deactivated
deaerates	10	3	1364	4	de_a_erates
dealates	9	27	1668	4	de_a__lates
deaminases	13	4	528	4	de_aminases
deaminate	12	4	1017	4	de_aminate_
deaminated	14	4	801	4	de_aminated
debilitate	13	4	486	4	debilitate_
debilitated	15	4	381	4	debilitated
decaliter	12	4	798	4	decali__ter
decaliters	13	4	521	4	decalit_ers
decapodans	16	5	190	4	decapoda_ns
decarbonates	17	5	391	4	decarbonates
decathletes	17	5	235	4	decathletes
decelerates	14	4	679	4	decelerates
decemvirates	20	5	208	4	decemvirates
deciares	11	5	1063	4	dec__i_ares
decilitres	13	4	499	4	decilit_res
decimate	13	4	1112	4	dec__imate_
decimated	15	4	895	4	dec__imated
decollates	13	13	715	4	dec_ollates
decorates	12	3	1474	4	dec__orates
decorticates	17	12	434	4	decorticates
decrepitudes	18	6	117	4	decrepitudes
decussates	13	4	324	4	dec_ussates
dedicates	13	3	1169	4	de__dicates
defalcates	16	4	454	4	defa_lcates
defoliates	14	4	633	4	defoli_ates
dekalitres	15	4	296	4	dekalit_res
delaminate	13	4	737	4	delaminate_
delaminated	15	4	578	4	delaminated
delectates	13	4	819	4	de_lectates
delicates	12	3	1431	4	de__licates
demarcates	15	4	597	4	dema_rcates
denitrates	11	6	951	4	de__nitrates
denominates	14	16	720	4	denominates
depilate	11	3	1170	4	de__pilate_
depilated	13	3	965	4	de__pilated
depopulates	16	4	403	4	depopulates
depurates	12	3	982	4	de__purates
deracinate	13	5	656	4	deracinate_
deracinated	15	4	486	4	deracinated
derivates	13	3	1009	4	de__rivates
desalinate	11	4	667	4	desalinate_
desalinated	13	4	577	4	desalinated
despites	11	4	1031	4	de_spi__tes
despumates	15	4	354	4	de_spumates
destitutes	11	5	652	4	de_stitutes
detoxicates	21	5	406	4	detoxicates
devaluates	14	26	606	4	deva_luates
devastate	13	4	495	4	deva_state_
devastated	15	4	412	4	deva_stated
deviates	12	3	1273	4	de__vi_ates
dictates	11	3	1138	4	dic___tates
dilapidate	14	5	274	4	dilapidate_
dilapidated	16	5	228	4	dilapidated
divaricates	17	4	387	4	divaricates
emaciates	13	4	788	4	_emaci_ates
epilates	10	3	1350	4	_e__pilates
epitases	10	3	893	4	_e__pitases
eradiates	10	20	1078	4	_eradi_ates
eradicates	13	4	826	4	_eradicates
evaginates	14	7	599	4	_evaginates
evaporates	15	4	546	4	_evaporates
excogitates	21	5	260	4	excogitates
expatiates	19	4	489	4	_expatiates
expiates	17	8	1021	4	_e_xpi_ates
facilitates	16	4	430	4	facilitates
felicitates	16	4	420	4	felicitates
gravitates	14	4	484	4	_gravitates
hesitates	12	6	979	4	he__sitates
incapacitates	19	9	175	4	incapacitates
lapidates	12	4	714	4	__lapidates
levitates	12	4	786	4	le__vitates
meditates	12	3	981	4	me__ditates
necessitates	14	5	244	4	necessitates
nictitates	12	4	495	4	nic_titates
palpitates	14	4	530	4	_palpitates
pectates	12	22	1395	4	pec___tates
precipitate	17	5	532	4	precipitate_
precipitated	19	5	402	4	precipitated
reactivates	16	4	561	4	reactivates
reanimates	12	4	785	4	re_animates
recalibrates	16	6	346	4	recalibrates
recapitalizes	26	11	480	4	recapitalizes
recapitulate	16	5	254	4	recapitulate_
recapitulated	18	5	243	4	recapitulated
recaptures	14	7	446	4	recap_tures
recuperates	15	4	560	4	recuperates
reradiates	11	17	801	4	reradi_ates
retaliates	10	4	910	4	retali_ates
revalidates	15	5	436	4	revalidates
sanitates	9	6	1173	4	__sanitates
veritates	12	3	1097	4	ve__ritates
vicariates	15	6	553	4	vicari_ates

Search took 10 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	148819	0.533	335255.2
2	DLD Change Limit	148819	133	9.110	16335.8
3	Display Results	133	133	0.076	1750.0
	(SQL Overall)	178691	133	9.719	18385.7