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

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

304 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
end	4	68	3436	(None)
and	4	72	4418	1	and
bend	7	64	3526	1	bend
ed	3	86	4519	1	e_d
eld	4	67	3380	1	eld
en	2	80	5239	1	en_
ends	5	65	2853	1	ends
eng	4	67	2678	1	eng
ens	3	72	4592	1	ens
fend	8	48	3297	1	fend
lend	5	62	3367	1	lend
mend	7	53	3403	1	mend
pend	7	59	3453	1	pend
rend	5	61	3657	1	rend
send	5	52	3729	1	send
tend	5	64	3377	1	tend
vend	8	66	2642	1	vend
wend	8	53	3045	1	wend
ad	3	119	7504	2	_ad
add	5	101	3237	2	add
aid	4	92	6909	2	aid
amend	8	57	1775	2	amend
an	2	118	7908	2	an_
ana	3	95	5983	2	ana
ands	5	78	3362	2	ands
ane	3	78	6695	2	ane
ani	3	77	5118	2	ani
ant	3	72	7079	2	ant
any	6	84	4049	2	any
bad	6	77	6316	2	bad
band	7	67	4092	2	band
bead	7	59	3792	2	bead
bed	6	79	5063	2	bed
ben	5	65	5492	2	ben_
bends	8	56	2897	2	bends
bendy	11	50	1725	2	bendy
bene	6	64	3949	2	bene
bens	6	59	4570	2	bens
bent	6	77	5991	2	bent
bid	6	77	5182	2	bid
bind	7	62	3452	2	bind
blend	8	53	1745	2	blend
bod	6	70	5555	2	bod
bond	7	53	3436	2	bond
bud	6	70	4128	2	bud
bund	7	55	3066	2	bund
cad	6	74	5637	2	cad
cent	6	74	5101	2	cent
cod	6	96	6013	2	cod
cud	6	79	3746	2	cud
dad	5	84	5617	2	dad
dead	6	54	3424	2	dead
deed	6	53	4090	2	deed
den	4	75	5434	2	den_
dene	5	66	4341	2	dene
deni	5	69	2939	2	deni
dens	5	59	4507	2	dens
dent	5	71	5841	2	dent
deny	8	60	2712	2	deny
did	5	68	5053	2	did
dud	5	67	3760	2	dud
ear	3	68	6788	2	ear
eat	3	69	8905	2	eat
eau	3	74	5094	2	eau
ebb	7	24	1863	2	ebb
ecu	5	68	2823	2	ecu
eddo	6	34	1181	2	eddo
eddy	9	39	1210	2	eddy
edh	7	69	2157	2	edh
eds	4	66	3893	2	eds
eek	7	79	3510	2	eek
eel	3	79	4684	2	eel
ef	5	73	4536	2	e_f
eff	9	61	2862	2	eff
efs	6	68	2960	2	efs
eft	6	60	3882	2	eft
egad	6	42	1541	2	egad
egg	5	69	1867	2	egg
ego	4	67	2605	2	ego
eh	5	83	3996	2	e_h
eide	5	58	3225	2	eide
eke	7	56	3009	2	eke
eked	9	67	1803	2	eked
el	2	67	4529	2	e_l
eland	6	58	2039	2	eland
elds	5	63	2486	2	elds
elf	6	61	3852	2	elf
elk	7	67	2612	2	elk
ell	3	67	3568	2	ell
elm	5	75	3174	2	elm
els	3	76	4572	2	els
em	4	94	4515	2	e_m
eme	5	58	3718	2	eme
emend	8	62	1489	2	emend
ems	5	64	3549	2	ems
emu	5	59	2998	2	emu
emyd	10	4	707	2	emyd
ended	7	44	2126	2	ended
ender	6	43	2586	2	ender
endow	9	45	1098	2	endow
endue	6	42	1535	2	endue
engs	5	61	2139	2	engs
enol	4	58	2382	2	enol
enow	7	78	1987	2	enow
enuf	7	3	2384	2	enuf
envy	10	4	1125	2	envy
eon	3	60	5208	2	eon
eons	4	66	3871	2	eons
er	2	83	4514	2	e_r
era	3	57	4150	2	era
ere	3	63	5277	2	ere
erg	4	55	3107	2	erg
ern	3	57	3836	2	ern
erne	4	67	2743	2	erne
erns	4	54	2823	2	erns
err	3	56	2653	2	err
ers	3	60	4628	2	ers
es	2	90	4822	2	e_s
esne	4	70	1879	2	esne
ess	3	60	3088	2	ess
et	2	69	6419	2	e_t
eta	3	58	3419	2	eta
eth	6	66	3098	2	eth
etna	4	64	1526	2	etna
eve	6	63	3116	2	eve
ewe	6	66	3098	2	ewe
ex	9	88	3564	2	e_x
exed	12	54	2059	2	exed
eye	6	55	3977	2	eye
eyed	8	66	2323	2	eyed
eyne	7	63	2246	2	eyne
fad	7	74	5242	2	fad
fed	7	65	4836	2	fed
feed	8	45	3890	2	feed
fen	6	68	5135	2	fen_
fends	9	63	2497	2	fends
fens	7	61	3976	2	fens
feod	8	155	2300	2	feod
feud	8	65	2302	2	feud
fid	7	68	4770	2	fid
fiend	9	53	1298	2	fiend
find	8	75	3261	2	find
fond	8	63	3095	2	fond
fud	7	63	3516	2	fud
fund	8	56	2498	2	fund
gad	5	75	5666	2	gad
ged	5	70	4454	2	ged
geed	6	54	3550	2	geed
geld	6	58	2843	2	geld
gen	4	59	5051	2	gen_
gene	5	62	3722	2	gene
gens	5	57	4007	2	gens
gent	5	69	5439	2	gent
genu	5	59	2907	2	genu
gid	5	70	4728	2	gid
gnu	4	55	2204	2	gnu
god	5	74	4980	2	god
had	7	76	5877	2	had
hand	8	68	3371	2	hand
head	8	71	3717	2	head
heed	8	64	3760	2	heed
held	8	53	3040	2	held
hen	6	75	5527	2	hen_
hens	7	56	4257	2	hens
hent	7	66	5638	2	hent
herd	8	49	3306	2	herd
hid	7	62	4839	2	hid
hind	8	55	2976	2	hind
hod	7	68	5247	2	hod
id	3	89	4185	2	_id
in	2	81	5087	2	in_
ink	7	64	3364	2	ink
inn	3	67	2744	2	inn
ins	3	59	4561	2	ins
jeed	12	54	2850	2	jeed
ken	7	63	4399	2	ken_
kendo	10	51	1323	2	kendo
keno	8	79	2644	2	keno
kens	8	54	3524	2	kens
kent	8	68	4697	2	kent
kid	8	65	4063	2	kid
kind	9	61	2857	2	kind
lad	4	81	6571	2	lad
land	5	63	3731	2	land
lead	5	60	3885	2	lead
led	4	62	5456	2	led
lends	6	53	2625	2	lends
leno	4	73	3139	2	leno
lens	4	61	4649	2	lens
lent	4	63	6053	2	lent
leud	5	72	2342	2	leud
lewd	8	57	1659	2	lewd
lid	4	74	5353	2	lid
mad	6	89	5872	2	mad
mead	7	55	3160	2	mead
med	6	61	4675	2	med
meed	7	49	3470	2	meed
meld	7	58	3047	2	meld
men	5	92	5285	2	men_
menad	8	59	1898	2	menad
mends	8	49	2769	2	mends
meno	6	60	3136	2	meno
menu	6	51	3023	2	menu
mid	6	73	5448	2	mid
mind	7	54	3439	2	mind
mod	6	90	5441	2	mod
mud	6	73	3687	2	mud
na	2	86	5248	2	_na
ne	2	70	4510	2	_ne
neb	5	72	3862	2	neb
nee	3	66	5778	2	nee
need	5	49	3415	2	need
neg	4	72	3734	2	neg
nene	4	59	3206	2	nene
nerd	5	66	2494	2	nerd
net	3	66	7029	2	net
new	6	62	3709	2	new
no	2	93	5324	2	_no
nod	4	75	4957	2	nod
nu	2	63	3195	2	_nu
od	3	92	5525	2	_od
odd	5	77	2546	2	odd
old	4	70	3347	2	old
on	2	80	5718	2	on_
one	3	70	5091	2	one
ono	3	68	3803	2	ono
ons	3	61	4851	2	ons
oud	4	74	3908	2	oud
pad	6	80	5733	2	pad
ped	6	67	5153	2	ped
peed	7	62	3918	2	peed
pen	5	65	5884	2	pen_
pends	8	55	2719	2	pends
pens	6	56	4964	2	pens
pent	6	65	5907	2	pent
pod	6	63	5149	2	pod
pond	7	55	3049	2	pond
pud	6	58	3666	2	pud
rad	4	76	6201	2	rad
rand	5	58	3957	2	rand
read	5	59	4253	2	read
red	4	67	5581	2	red
redd	6	63	2318	2	redd
reed	5	55	4962	2	reed
rends	6	51	2995	2	rends
rent	4	66	6124	2	rent
rid	4	67	5464	2	rid
rind	5	65	3561	2	rind
rod	4	79	5390	2	rod
rynd	8	64	1410	2	rynd
sad	4	74	5921	2	sad
sand	5	53	3847	2	sand
scend	8	55	1629	2	scend
seed	5	55	4948	2	seed
sen	3	60	5852	2	sen_
sends	6	55	2824	2	sends
sene	4	68	4805	2	sene
sent	4	69	6301	2	sent
shend	9	47	1997	2	shend
sned	5	60	2605	2	sned
sod	4	60	5371	2	sod
spend	8	56	1933	2	spend
tad	4	79	5983	2	tad
ted	4	64	4657	2	ted
teed	5	54	3926	2	teed
teind	6	2	1361	2	teind
ten	3	58	5611	2	ten_
tends	6	54	2558	2	tends
tendu	6	72	1600	2	tendu
tens	4	56	4741	2	tens
tent	4	61	5986	2	tent
tod	4	94	5708	2	tod
trend	6	48	1745	2	trend
un	2	83	4114	2	un_
unde	5	58	2549	2	unde
undo	5	56	2016	2	undo
undy	8	50	1517	2	undy
uns	3	59	3676	2	uns
upend	8	50	1104	2	upend
urd	4	64	2706	2	urd
veld	8	53	2320	2	veld
vena	7	61	2629	2	vena
vends	9	55	2089	2	vends
vent	7	60	4905	2	vent
vid	7	72	4182	2	vid
wad	7	70	5390	2	wad
wand	8	58	3388	2	wand
wed	7	58	4363	2	wed
weed	8	56	3751	2	weed
weld	8	47	2773	2	weld
wen	6	62	4960	2	wen_
wends	9	58	2281	2	wends
wens	7	63	3793	2	wens
went	7	60	5187	2	went
wind	8	55	3386	2	wind
wud	7	62	2716	2	wud
wynd	11	61	1446	2	wynd
yeld	8	114	2387	2	yeld
yen	6	68	4738	2	yen_
yens	7	58	3226	2	yens
yid	7	66	4084	2	yid
yod	7	75	4551	2	yod
yond	8	61	2231	2	yond
zed	13	54	3118	2	zed

Search took 1 second 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	14084	0.266	671770.7
2	DLD Change Limit	14084	304	0.390	36112.8
3	Display Results	304	304	0.063	4825.4
	(SQL Overall)	178691	304	0.719	248527.1