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

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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
Check this box to automatically increase the Change Limit after seconds.

93 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
elmy	9	56	1679	(None)
elm	5	75	3174	1	elm_
elms	6	73	2270	1	elms
emmy	11	60	1324	1	emmy
alky	11	59	2034	2	alky
ally	7	69	3564	2	ally
alma	6	63	3302	2	alma
alme	6	58	3216	2	alme
alms	6	58	3492	2	alms
army	9	66	2418	2	army
balmy	12	52	1747	2	balmy
beamy	12	62	1857	2	beamy
belay	10	50	2152	2	belay
belly	10	46	2549	2	belly
blimy	12	52	1282	2	blimy
clay	9	59	2741	2	clay
cloy	9	66	2383	2	cloy
delay	9	48	2063	2	delay
delly	9	60	2387	2	delly
demy	10	54	2285	2	demy
easy	7	62	2449	2	easy
eddy	9	39	1209	2	eddy
edgy	9	47	1352	2	edgy
eely	7	77	2521	2	eely
eery	7	61	2962	2	eery
eggy	9	66	1185	2	eggy
el	2	67	4529	2	el__
elan	4	67	3424	2	elan
eld	4	67	3379	2	el_d
elds	5	63	2485	2	elds
elegy	9	3	930	2	elegy
elemi	7	3	1250	2	elemi
elf	6	61	3852	2	el_f
elhi	7	6	1240	2	elhi
elk	7	67	2612	2	el_k
elks	8	58	2003	2	elks
ell	3	67	3568	2	el_l
ells	4	64	3135	2	ells
els	3	76	4572	2	el_s
else	4	59	2308	2	else
em	4	94	4515	2	e_m_
eme	5	58	3718	2	e_me
emmys	12	44	602	2	emmys
ems	5	64	3549	2	e_ms
emu	5	59	2998	2	e_mu
emyd	10	4	707	2	e_myd
enemy	10	5	999	2	enemy
envy	10	4	1125	2	envy
espy	9	6	937	2	espy
eyry	10	63	1588	2	eyry
felly	11	49	2280	2	felly
filmy	13	61	1404	2	filmy
flamy	13	52	1747	2	flamy
flay	10	63	3280	2	flay
fley	10	66	2685	2	fley
fly	9	71	2495	2	fl_y
fumy	12	71	1858	2	fumy
gamy	10	54	2753	2	gamy
gemmy	13	52	1105	2	gemmy
germy	11	51	1366	2	germy
gley	8	57	2465	2	gley
helm	9	55	3002	2	helm_
helms	10	56	1946	2	helms
homy	12	66	2322	2	homy
illy	7	69	2533	2	illy
immy	11	46	1182	2	immy
jelly	15	42	1825	2	jelly
jemmy	19	49	855	2	jemmy
kelly	12	46	1702	2	kelly
kelpy	14	51	1068	2	kelpy
lay	6	88	6535	2	_lay
levy	10	64	1850	2	levy
ley	6	62	4681	2	_ley
limy	9	57	2771	2	limy
malmy	12	48	1634	2	malmy
melty	10	49	1836	2	melty
my	7	81	2565	2	__my
nelly	8	46	1881	2	nelly
oldy	8	53	1684	2	oldy
palmy	12	60	1673	2	palmy
play	9	59	2898	2	play
ploy	9	61	2360	2	ploy
plumy	12	42	1323	2	plumy
ply	8	63	2355	2	pl_y
relay	8	44	2467	2	relay
rely	7	54	2895	2	rel_y
rimy	9	66	2128	2	rimy
seamy	10	59	2127	2	seamy
slay	7	64	3638	2	slay
slimy	10	54	1742	2	slimy
sly	6	62	2856	2	sl_y
telly	8	49	2082	2	telly
welly	11	46	2001	2	welly

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	29872	0.140	1276364.3
2	DLD Change Limit	29872	93	1.563	19112.0
3	Display Results	93	93	0.030	3100.0
	(SQL Overall)	178691	93	1.733	103110.8