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

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

72 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
meze	15	44	2090	1	meze
beef	9	62	3367	2	beef
deaf	8	58	3840	2	deaf
def	7	65	4672	2	de_f
delf	8	54	3657	2	delf
ef	5	73	4536	2	_e_f
eff	9	61	2862	2	_eff
elf	6	61	3852	2	_elf
fez	15	62	3682	2	fez_
keef	11	58	2999	2	keef
kef	10	56	3966	2	ke_f
kerf	11	58	2746	2	kerf
leaf	7	64	4103	2	leaf
lez	12	55	4131	2	lez_
maze	15	54	3497	2	maze
mazy	18	64	1969	2	mazy
me	4	77	4833	2	me__
mead	7	55	3160	2	mead
meal	6	56	4317	2	meal
mean	6	55	3808	2	mean
meat	6	63	5960	2	meat
med	6	61	4674	2	me_d
meds	7	57	3536	2	meds
meed	7	49	3470	2	meed
meek	10	56	2483	2	meek
meet	6	53	5055	2	meet
meg	6	60	4095	2	me_g
mega	7	76	2087	2	mega
megs	7	55	3063	2	megs
mel	5	60	4748	2	me_l
meld	7	58	3047	2	meld
mell	6	49	3561	2	mell
mels	6	59	4153	2	mels
melt	6	57	5289	2	melt
mem	7	79	4347	2	me_m
meme	8	53	3055	2	meme
memo	8	59	2479	2	memo
mems	8	59	3150	2	mems
men	5	92	5284	2	me_n
mend	7	53	3402	2	mend
meno	6	60	3135	2	meno
menu	6	51	3022	2	menu
meou	6	53	2586	2	meou
meow	9	51	1788	2	meow
merc	8	72	2562	2	merc
mere	6	72	4444	2	mere
merk	10	60	2794	2	merk
merl	6	58	3097	2	merl
mesa	6	70	2548	2	mesa
mesh	9	68	2300	2	mesh
mess	6	59	3243	2	mess
met	5	60	7243	2	me_t
meta	6	59	3241	2	meta
mete	6	44	3813	2	mete
meth	9	58	2784	2	meth
mew	8	61	3773	2	me_w
mewl	9	56	1832	2	mewl
mews	9	66	2933	2	mews
mezes	16	77	1926	2	mezes
mezzo	15	3	743	2	mezzo
miff	12	56	2504	2	miff
mozo	15	77	1974	2	mozo
muff	12	47	2385	2	muff
neif	7	54	2948	2	neif
pelf	9	70	3145	2	pelf
reef	7	49	3821	2	reef
ref	6	60	5329	2	re_f
reif	7	69	3764	2	reif
seif	7	56	3872	2	seif
self	7	51	3829	2	self
serf	7	63	4011	2	serf
teff	10	60	2376	2	teff

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.080	2233637.5
2	DLD Change Limit	29872	72	0.936	31914.5
3	Display Results	72	72	0.016	4500.0
	(SQL Overall)	178691	72	1.032	173150.2