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

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

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

106 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
diene	6	57	2013	(None)
dene	5	66	4341	1	d_ene
dienes	7	57	1990	1	dienes
dine	5	55	5534	1	di_ne
agene	6	56	2158	2	agene
akene	9	58	1866	2	akene
arene	5	53	2941	2	arene
bene	6	64	3949	2	_bene
bine	6	66	5087	2	bi_ne
cine	6	62	4295	2	ci_ne
dee	4	76	6582	2	d_e_e
deice	8	43	2003	2	deice
deke	9	52	2876	2	d_eke
dele	5	68	4308	2	d_ele
deme	7	65	3628	2	d_eme
den	4	75	5434	2	d_en_
denes	6	56	3972	2	d_enes
deni	5	69	2939	2	d_eni
dens	5	59	4507	2	d_ens
dense	6	59	2350	2	d_ense
dent	5	71	5841	2	d_ent
deny	8	60	2712	2	d_eny
dere	5	68	4590	2	d_ere
dice	7	58	4190	2	di_ce
didie	7	41	2057	2	didie
die	4	67	5966	2	di__e
died	6	61	3786	2	die_d
dieing	8	40	1865	2	dieing
diel	5	90	3461	2	die_l
dies	5	56	5353	2	die_s
diesel	7	44	1040	2	diesel
dieses	7	52	1869	2	dieses
diet	5	73	5754	2	die_t
dieted	8	31	1549	2	dieted
dieter	7	35	1677	2	dieter
diets	6	60	2664	2	diets
dike	9	59	3577	2	di_ke
dime	7	62	3765	2	di_me
din	4	64	5947	2	di_n_
dined	7	64	3199	2	dined
diner	6	56	3290	2	diner
dines	6	64	4915	2	dines
ding	6	69	4096	2	di_ng
dinge	7	56	2730	2	dinge
dink	9	71	3781	2	di_nk
dinned	8	43	1761	2	dinned
dinner	7	42	1716	2	dinner
dino	5	60	3676	2	di_no
dins	5	66	5205	2	di_ns
dint	5	67	5906	2	di_nt
diode	7	47	1612	2	diode
dipnet	9	13	1747	2	dipnet
dire	5	66	4415	2	di_re
dirge	7	51	1707	2	dirge
disme	8	57	1624	2	disme
dite	5	55	4756	2	di_te
dive	8	56	3478	2	di_ve
divine	10	35	1446	2	divine
dizen	15	52	1493	2	dizen_
dizened	18	26	733	2	dizened
dizens	16	49	1139	2	dizens
done	5	57	4791	2	d_one
donee	6	69	3101	2	donee
donne	6	55	2046	2	donne
dree	5	66	3832	2	dre_e
drone	6	53	2498	2	drone
duende	8	3	692	2	duende
dune	5	61	3758	2	d_une
dwine	9	56	1614	2	dwine
dyne	8	53	2093	2	d_yne
fiend	9	53	1298	2	fiend
fine	7	51	4796	2	fi_ne
gene	5	62	3722	2	_gene
gien	5	63	3003	2	gien_
kine	8	56	4344	2	ki_ne
liane	5	47	2066	2	liane
liege	6	53	1443	2	liege
lien	4	53	3981	2	lien_
liens	5	65	2550	2	liens
lierne	6	3	802	2	lierne
lieve	8	63	1547	2	lieve
line	4	69	6558	2	li_ne
mien	6	50	2837	2	mien_
miens	7	61	1830	2	miens
mine	6	72	5618	2	mi_ne
nene	4	59	3206	2	_nene
niece	7	48	1450	2	niece
nieve	8	56	1318	2	nieve
nine	4	58	4218	2	ni_ne
piece	9	67	1799	2	piece
pine	6	77	5572	2	pi_ne
pinene	8	29	1565	2	pinene
scene	7	72	2057	2	scene
seine	5	57	3287	2	seine
sene	4	68	4805	2	_sene
siege	6	67	1844	2	siege
sieve	8	49	1884	2	sieve
sine	4	65	6063	2	si_ne
skene	9	61	1812	2	skene
tine	4	58	5514	2	ti_ne
triene	6	43	1639	2	triene
vine	7	56	4369	2	vi_ne
wiener	9	45	1354	2	wiener
wienie	9	22	997	2	wienie
wine	7	49	5343	2	wi_ne
zine	13	70	3616	2	zi_ne

Search took 3 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	53800	0.296	603685.8
2	DLD Change Limit	53800	106	1.703	31591.3
3	Display Results	106	106	0.030	3533.3
	(SQL Overall)	178691	106	2.029	88068.5