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

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

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.

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
menad	8	59	1898	(None)
maenad	9	3	941	1	maenad
mead	7	55	3160	1	me_ad
menads	9	55	1438	1	menads
mend	7	53	3402	1	men_d
monad	8	55	1947	1	monad
amend	8	57	1775	2	amen_d
bead	7	59	3792	2	be_ad
bend	7	64	3526	2	ben_d
dead	6	54	3424	2	de_ad
denar	6	52	2329	2	denar
egad	6	42	1541	2	_egad
emend	8	62	1489	2	emen_d
end	4	68	3435	2	_en_d
fend	8	48	3297	2	fen_d
gonad	7	52	1605	2	gonad
head	8	71	3717	2	he_ad
hexad	16	49	1062	2	hexad
jehad	16	3	768	2	jehad
kenaf	12	3	1603	2	kenaf
knead	10	42	966	2	knead
lead	5	60	3885	2	le_ad
lend	5	62	3367	2	len_d
mad	6	89	5870	2	m__ad
maenads	10	3	737	2	maenads
mana	6	53	4194	2	mana_
manas	7	62	4042	2	manas
manat	7	60	3998	2	manat
maned	8	66	3409	2	maned
meads	8	54	2532	2	me_ads
meal	6	56	4317	2	me_al
mean	6	55	3808	2	me_an
means	7	58	3122	2	means
meant	7	65	3720	2	meant
meany	10	46	2047	2	meany
meat	6	63	5960	2	me_at
med	6	61	4674	2	me__d
medal	8	62	2132	2	medal
mediad	10	43	1371	2	mediad
meed	7	49	3470	2	me_ed
mega	7	76	2087	2	mega_
meld	7	58	3047	2	me_ld
men	5	92	5284	2	men__
menace	10	32	1694	2	menace
menaced	12	27	1009	2	menaced
menage	9	32	1654	2	menage
mended	10	44	1868	2	mended
mends	8	49	2769	2	mends
menial	8	42	2303	2	menial
meno	6	60	3135	2	men_o
mensa	7	53	1866	2	mensa
mensae	8	41	1404	2	mensae
mensal	8	46	1565	2	mensal
mensas	8	51	1585	2	mensas
mense	7	50	2563	2	mense
mensed	9	39	1654	2	mensed
mensh	10	54	1355	2	mensh
menta	7	44	2442	2	menta
mental	8	45	2160	2	mental
menu	6	51	3022	2	men_u
menudo	9	4	579	2	menudo
menus	7	58	2284	2	menus
mesa	6	70	2548	2	mesa_
mesas	7	68	2320	2	mesas
meta	6	59	3241	2	meta_
metal	7	54	2738	2	metal
meted	8	54	2443	2	meted
mewed	11	52	1801	2	mewed
mina	6	51	3691	2	mina_
minae	7	56	2772	2	minae
minas	7	54	3411	2	minas
mind	7	54	3437	2	min_d
mined	8	53	3335	2	mined
monads	9	45	1530	2	monads
monas	7	47	3215	2	monas
myna	9	58	1529	2	myna_
mynah	13	56	956	2	mynah
mynas	10	58	1523	2	mynas
omened	9	37	1100	2	omened
penal	7	52	2837	2	penal
pend	7	59	3453	2	pen_d
pentad	9	3	1376	2	pentad
read	5	59	4253	2	re_ad
renal	5	59	2950	2	renal
rend	5	61	3657	2	ren_d
send	5	52	3729	2	sen_d
tend	5	64	3377	2	ten_d
ulnad	6	56	1145	2	ulnad
vena	7	61	2629	2	vena_
venae	8	59	2098	2	venae
venal	8	55	2321	2	venal
vend	8	66	2642	2	ven_d
wend	8	53	3045	2	wen_d

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.096	1861364.6
2	DLD Change Limit	53800	93	1.920	28020.8
3	Display Results	93	93	0.030	3100.0
	(SQL Overall)	178691	93	2.046	87336.8