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

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

87 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
exercitations	22	5	456	(None)
exercitation	21	5	538	1	exercitation_
excitations	20	4	900	2	ex__citations
elicitations	14	4	680	3	e_licitations
energizations	23	5	618	3	energizations
eternizations	22	5	807	3	eternizations
excitation	19	4	1017	3	ex__citation_
excogitations	23	5	383	3	excogitations
excruciations	24	11	299	3	excruci_ations
execrations	20	4	892	3	exe_c_rations
expectations	23	6	584	3	expec_tations
exploitations	22	5	421	3	exploitations
exterminations	23	6	512	3	exterminations
extrications	21	4	905	3	extr_ications
recitations	13	3	1420	3	_re_citations
brecciations	18	4	428	4	brecci_ations
capacitations	19	5	362	4	capacitations
citations	11	3	1250	4	____citations
coarctations	16	11	449	4	coarc_tations
crepitations	16	4	747	4	cre_pitations
decimations	16	4	1016	4	_de_cimations
decrepitations	19	8	434	4	decrepitations
delectations	15	4	745	4	dele_c_tations
depreciations	18	4	657	4	depreci_ations
deracinations	16	4	783	4	_deracinations
derivations	15	6	1149	4	_der_ivations
determinations	17	6	689	4	determinations
elicitation	13	4	753	4	e_licitation_
elucidations	15	4	451	4	e_lucidations
emaciations	15	4	816	4	e_maci_ations
emancipations	19	5	374	4	emancipations
emarginations	16	7	415	4	emarginations
encrustations	15	12	308	4	encrustations
energization	22	5	649	4	energization_
enervations	14	7	857	4	ener__vations
enunciations	14	4	509	4	enunci_ations
equitations	20	4	744	4	__equitations
eructations	13	4	723	4	__eructations
eternization	21	5	867	4	eternization_
etherizations	25	5	723	4	ether_izations
exaltations	18	4	729	4	ex__altations
examinations	21	6	746	4	ex_aminations
excavations	23	4	508	4	ex__cavations
excogitation	22	5	419	4	excogitation_
excoriations	21	4	752	4	excori_ations
excruciation	23	12	331	4	excruci_ation_
execration	19	4	983	4	exe_c_ration_
executions	19	4	639	4	exe_c__utions
exenterations	20	5	448	4	exenterations
exertions	16	3	976	4	exer____tions
exfoliations	22	4	478	4	exfoli_ations
exhortations	22	4	445	4	ex_hortations
expatiations	21	4	613	4	expati_ations
expectation	22	6	648	4	expec_tation_
expiations	19	5	966	4	ex__pi_ations
expirations	20	6	958	4	ex__pirations
explantations	22	5	364	4	explantations
explications	23	4	753	4	ex_plications
exploitation	21	5	470	4	exploitation_
exportations	21	4	665	4	ex_portations
exsiccations	23	4	326	4	exsic_cations
extermination	22	7	574	4	extermination_
extrication	20	4	979	4	extr_ication_
exultations	18	4	652	4	ex__ultations
exuviations	21	9	569	4	ex_uvi_ations
felicitations	18	7	458	4	felicitations
germinations	15	13	794	4	_germinations
herniations	14	4	740	4	_herni_ations
hesitations	14	4	854	4	_he_sitations
incitations	13	3	1088	4	__incitations
irritations	11	4	783	4	__irritations
levitations	14	4	829	4	_le_vitations
meditations	14	4	933	4	_me_ditations
mercurations	16	4	656	4	_mercurations
miscitations	16	4	705	4	_miscitations
necessitations	16	12	279	4	necessitations
percolations	16	4	805	4	_percolations
permutations	16	4	650	4	_permutations
recitation	12	3	1594	4	_re_citation_
regurgitations	16	13	314	4	regurgitations
resuscitations	16	7	378	4	resuscitations
seriations	10	3	1668	4	_ser_i_ations
sexploitations	23	5	271	4	sexploitations
solicitations	15	4	489	4	solicitations
speciations	15	4	848	4	spe_ci_ations
sternutations	13	5	375	4	sternutations
terminations	14	14	976	4	_terminations

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	95024	0.783	228213.3
2	DLD Change Limit	95024	87	6.733	14113.2
3	Display Results	87	87	0.046	1891.3
	(SQL Overall)	178691	87	7.562	23630.1