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

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

83 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
decennaries	14	5	426	(None)
decenaries	13	4	812	1	dece_naries
decencies	14	4	894	3	dece_n_cies
decennary	15	4	346	3	decennar__y
decentres	12	23	852	3	dece_ntr_es
legendaries	13	5	309	3	legendaries
mercenaries	15	5	544	3	merce_naries
necessaries	13	5	309	3	necessaries
secondaries	14	5	404	3	secondaries
accessaries	15	17	355	4	accessaries
bewearies	14	4	701	4	bewe__aries
bicentenaries	17	6	202	4	bicentenaries
canaries	10	3	1894	4	__c_anaries
canneries	11	3	1308	4	__canneries
catenaries	12	4	866	4	cate_naries
centares	10	29	1389	4	__centar_es
centauries	12	4	553	4	__centauries
centenaries	13	4	648	4	centenaries
centuries	11	3	1133	4	__centuries
deaconries	13	4	516	4	deacon_ries
deaneries	10	3	1083	4	d__eaneries
dearies	8	35	2627	4	d__e__aries
debentures	13	4	353	4	debentur_es
decares	10	28	1853	4	dec___ar_es
deceases	11	4	1015	4	dece__a_ses
decelerates	14	4	679	4	decelerates
decenary	14	4	627	4	dece_nar__y
decennia	11	4	422	4	decenn__i_a
decennial	12	4	482	4	decenn__ial
decennials	13	5	334	4	decenn_ials
decennium	14	4	378	4	decenn__ium
decenniums	15	5	258	4	decenn_iums
decentered	14	4	532	4	decenter_ed
decentering	15	4	648	4	decentering
decenters	12	24	1037	4	decenter__s
decentralizes	25	7	514	4	decentralizes
decentre	11	24	855	4	dece_ntr_e_
decentred	13	23	623	4	dece_ntr_ed
decentring	14	4	675	4	dece_ntring
decertifies	17	4	457	4	decertifies
deciares	11	5	1063	4	dec__iar_es
declares	11	6	1131	4	dec__lar_es
decries	10	33	1980	4	dec____ries
decuries	11	3	1222	4	dec___uries
degeneracies	16	5	355	4	degeneracies
degenerates	13	4	645	4	degenerates
delegacies	14	4	403	4	dele_gacies
denarius	9	4	881	4	d__e_narius
dependances	17	5	485	4	dependances
dicentrics	15	4	467	4	dice_ntrics
dictionaries	15	5	478	4	dictionaries
dietaries	10	4	1066	4	d_ie_taries
dispensaries	15	5	376	4	dispensaries
documentaries	18	6	326	4	documentaries
drearies	9	23	1341	4	d_re__aries
dysenteries	15	5	427	4	dysenteries
henneries	12	4	864	4	__henneries
incendiaries	15	5	269	4	incendiaries
lectionaries	14	5	477	4	lectionaries
legendries	12	4	382	4	lege_ndries
legionaries	12	7	456	4	legionaries
mesenteries	13	4	589	4	mesenteries
nectaries	11	4	981	4	nec__taries
octonaries	12	4	600	4	_octonaries
parcenaries	15	5	584	4	parce_naries
peccaries	15	4	853	4	pec__caries
perennates	12	5	676	4	perenna_tes
plenaries	11	4	1038	4	_ple_naries
prebendaries	17	5	281	4	prebendaries
recencies	13	3	1225	4	rece_n_cies
reenlarges	11	4	312	4	re_enlarges
reentries	9	3	1176	4	re_e_ntries
scenarios	11	4	481	4	_sce_narios
sceneries	11	4	939	4	_sce_neries
secretaries	13	4	542	4	secretaries
sectaries	11	3	1224	4	sec__taries
seminaries	12	4	1000	4	se_minaries
septenaries	13	7	535	4	septenaries
stannaries	10	4	577	4	_stannaries
tercentenaries	16	8	152	4	tercentenaries
ternaries	9	3	1164	4	__ternaries
veterinaries	15	5	319	4	veterinaries
zemindaries	23	5	302	4	zemindaries

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.436	409841.7
2	DLD Change Limit	148819	83	8.826	16861.4
3	Display Results	83	83	0.050	1660.0
	(SQL Overall)	178691	83	9.312	19189.3