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

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

111 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
enol	4	58	2382	(None)
enols	5	47	1840	1	enols
enow	7	78	1987	1	enow
enrol	5	10	1428	1	enrol
anal	4	80	3752	2	anal
anil	4	64	3743	2	anil
anoa	4	56	3447	2	anoa
anole	5	53	3038	2	anole
anon	4	61	3485	2	anon
awol	7	56	2067	2	awol
benzol	17	5	699	2	benzol
col	5	93	6035	2	_col
cool	6	69	4049	2	cool
diol	5	73	2913	2	diol
dol	4	71	5065	2	_dol
earl	4	58	3814	2	earl
ebon	6	68	2110	2	ebon
eel	3	79	4684	2	e_el
egal	5	51	1943	2	egal
ego	4	67	2605	2	ego_
egos	5	58	2165	2	egos
el	2	67	4529	2	e__l
ell	3	67	3568	2	e_ll
en	2	80	5239	2	en__
end	4	68	3435	2	en_d
endow	9	45	1098	2	endow
ends	5	65	2852	2	ends
enfold	10	13	761	2	enfold
eng	4	67	2678	2	en_g
engs	5	61	2139	2	engs
enjoy	15	4	596	2	enjoy
enoki	9	26	887	2	enoki
enolic	8	4	1335	2	enolic
enorm	7	44	1564	2	enorm
enows	8	51	1549	2	enows
enroll	6	11	1007	2	enroll
enrols	6	12	1338	2	enrols
ens	3	72	4592	2	en_s
ensoul	6	3	825	2	ensoul
entoil	6	9	1249	2	entoil
enuf	7	3	2384	2	enuf
envoi	8	7	802	2	envoi
envoy	11	5	672	2	envoy
envy	10	4	1125	2	envy
eon	3	60	5208	2	e_on
eons	4	66	3871	2	eons
epos	6	67	2373	2	epos
eros	4	52	3845	2	eros
evil	7	53	1807	2	evil
exon	11	71	1680	2	exon
extol	12	4	789	2	extol
fool	7	53	3059	2	fool
gaol	5	69	2541	2	gaol
genoa	6	43	1582	2	genoa
genom	8	37	1684	2	genom
idol	5	68	1863	2	idol
indol	6	37	1487	2	indol
keno	8	79	2643	2	keno_
kenos	9	52	2062	2	kenos
ketol	9	54	1400	2	ketol
knob	10	74	1701	2	knob
knoll	9	38	960	2	knoll
knop	10	71	1659	2	knop
knot	8	56	3050	2	knot
know	11	61	1584	2	know
leno	4	73	3139	2	leno_
lenos	5	60	2486	2	lenos
meno	6	60	3136	2	meno_
metol	7	59	1781	2	metol
mol	5	66	5459	2	_mol
mool	6	75	3386	2	mool
neon	4	70	2642	2	neon
nerol	5	10	1781	2	nerol
nil	3	61	4419	2	_nil
no	2	93	5324	2	_no_
nob	5	89	5442	2	_nob
nod	4	75	4956	2	_nod
noel	4	52	2655	2	_noel
nog	4	68	4731	2	_nog
noh	6	66	4064	2	_noh
noil	4	61	3324	2	_noil
nolo	4	62	2931	2	_nolo
nom	5	104	5064	2	_nom
noo	3	71	5404	2	_noo
nor	3	80	4882	2	_nor
nos	3	88	5932	2	_nos
not	3	94	7466	2	_not
now	6	59	5019	2	_now
obol	6	52	2061	2	obol
ono	3	68	3803	2	ono_
onos	4	62	2900	2	onos
penal	7	52	2837	2	penal
phenol	11	4	925	2	phenol
pol	5	64	4938	2	_pol
pool	6	58	3595	2	pool
renal	5	59	2950	2	renal
senor	5	38	2280	2	senor
snob	6	58	2559	2	snob
snog	5	56	2363	2	snog
snool	5	51	1864	2	snool
snot	4	47	4545	2	snot
snow	7	63	2479	2	snow
sol	3	72	5662	2	_sol
tenon	5	33	2051	2	tenon
tenor	5	36	2025	2	tenor
tool	4	67	3568	2	tool
venal	8	55	2321	2	venal
venom	10	39	1486	2	venom
viol	7	65	2359	2	viol
wool	7	64	2737	2	wool
xenon	12	26	1245	2	xenon

Search took 2 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	29872	0.266	671770.7
2	DLD Change Limit	29872	111	0.780	38297.4
3	Display Results	111	111	0.016	6937.5
	(SQL Overall)	178691	111	1.062	168258.9