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

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

248 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
deem	7	54	3289	(None)
adeem	8	3	1180	1	adeem
dee	4	76	6582	1	dee_
deed	6	53	4090	1	deed
deems	8	54	2177	1	deems
deep	7	60	3188	1	deep
deer	5	67	3902	1	deer
dees	5	63	5663	1	dees
deet	5	73	5658	1	deet
deme	7	65	3628	1	deme
derm	7	60	3189	1	derm
neem	6	73	2808	1	neem
seem	6	54	3856	1	seem
teem	6	61	3260	1	teem
adeems	9	4	633	2	adeems
ahem	9	72	2536	2	ahem
beam	8	69	3923	2	beam
bee	5	62	6240	2	bee_
beef	9	62	3367	2	beef
been	6	53	3578	2	been
beep	8	59	3121	2	beep
beer	6	56	3599	2	beer
bees	6	54	5338	2	bees
beet	6	64	5754	2	beet
berm	8	67	3275	2	berm
cee	5	59	5270	2	cee_
cees	6	59	4159	2	cees
dam	6	74	5704	2	d_am
dame	7	71	4031	2	dame
de	3	70	4954	2	d_e_
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deal	5	63	4741	2	deal
dean	5	60	3948	2	dean
dear	5	53	4360	2	dear
deb	6	63	4269	2	d_eb
debs	7	65	3024	2	debs
debt	7	71	3902	2	debt
deck	11	58	2775	2	deck
deco	7	61	2597	2	deco
deeds	7	54	2376	2	deeds
deedy	10	43	1589	2	deedy
deemed	10	47	1306	2	deemed
deeps	8	49	2177	2	deeps
deers	6	49	3052	2	deers
deets	6	53	3024	2	deets
def	7	65	4672	2	d_ef
defer	9	46	1975	2	defer
defi	8	63	2149	2	defi
deft	8	55	4022	2	deft
defy	11	49	2126	2	defy
degerm	10	3	789	2	degerm
degum	9	47	1190	2	degum
deil	5	62	3162	2	deil
deism	8	41	1603	2	deism
deke	9	52	2876	2	deke
deked	11	57	1853	2	deked
dekes	10	52	2445	2	dekes
del	4	67	5275	2	d_el
dele	5	68	4308	2	dele
deled	7	53	2654	2	deled
deles	6	51	3925	2	deles
delf	8	54	3657	2	delf
deli	5	56	3129	2	deli
dell	5	69	3820	2	dell
dels	5	67	4547	2	dels
delt	5	78	5527	2	delt
demes	8	60	3269	2	demes
demo	7	74	2755	2	demo
demy	10	54	2285	2	demy
den	4	75	5434	2	d_en
dene	5	66	4341	2	dene
denes	6	56	3972	2	denes
deni	5	69	2939	2	deni
denim	8	55	1884	2	denim
dens	5	59	4507	2	dens
dent	5	71	5841	2	dent
deny	8	60	2712	2	deny
deperm	11	3	936	2	deperm
dere	5	68	4590	2	dere
derma	8	49	1851	2	derma
derms	8	50	2289	2	derms
desex	13	3	1198	2	desex
desk	9	56	1890	2	desk
deter	6	50	2804	2	deter
dev	7	60	3377	2	d_ev
deva	8	57	2098	2	deva
devel	9	42	1712	2	devel
devs	8	64	2403	2	devs
dew	7	71	3992	2	d_ew
dewed	10	50	2030	2	dewed
dews	8	62	3060	2	dews
dewy	11	54	1902	2	dewy
dex	11	69	3688	2	d_ex
dexes	13	52	2451	2	dexes
dexy	15	61	1855	2	dexy
dey	7	72	4337	2	d_ey
deys	8	50	2747	2	deys
die	4	67	5965	2	die_
died	6	61	3785	2	died
diel	5	90	3460	2	diel
dies	5	56	5352	2	dies
diet	5	73	5753	2	diet
dim	6	81	4649	2	d_im
dime	7	62	3764	2	dime
doe	4	73	6195	2	doe_
doer	5	77	3470	2	doer
does	5	65	5447	2	does
dom	6	97	5244	2	d_om
dome	7	72	4073	2	dome
doom	7	64	3007	2	doom
dorm	7	68	3462	2	dorm
doum	7	62	2667	2	doum
dram	7	58	3200	2	dram
dream	8	51	2039	2	dream
dree	5	66	3832	2	dree
dreed	7	52	2284	2	dreed
drees	6	56	2852	2	drees
dreg	6	68	2165	2	dreg
drek	9	63	2108	2	drek
drew	8	62	2167	2	drew
drum	7	65	2159	2	drum
due	4	52	4986	2	due_
duel	5	67	2970	2	duel
dues	5	60	4550	2	dues
duet	5	64	4626	2	duet
dweeb	11	3	774	2	dweeb
dye	7	53	3484	2	dye_
dyed	9	67	2076	2	dyed
dyer	8	55	2211	2	dyer
dyes	8	53	3189	2	dyes
edema	8	6	1055	2	edema
eek	7	79	3510	2	_eek
eel	3	79	4684	2	_eel
elm	5	75	3174	2	_elm
em	4	94	4515	2	__em
eme	5	58	3718	2	_eme
fee	6	68	6201	2	fee_
feeb	9	69	2454	2	feeb
feed	8	45	3890	2	feed
feel	7	52	3384	2	feel
fees	7	64	5060	2	fees
feet	7	53	5221	2	feet
fem	8	60	4073	2	_fem
feme	9	61	3054	2	feme
gee	4	53	5920	2	gee_
geed	6	54	3550	2	geed
geek	9	53	2702	2	geek
gees	5	56	4788	2	gees
geez	14	64	2486	2	geez
gem	6	68	4022	2	_gem
germ	7	54	2896	2	germ
geum	7	54	2455	2	geum
haem	9	57	3098	2	haem
heed	8	64	3760	2	heed
heel	7	50	3422	2	heel
helm	9	55	3002	2	helm
hem	8	61	4873	2	_hem
heme	9	50	3441	2	heme
herm	9	56	3615	2	herm
idem	7	61	2106	2	idem
item	6	56	2038	2	item
jee	10	66	4864	2	jee_
jeed	12	54	2850	2	jeed
jeep	13	56	2484	2	jeep
jeer	11	54	2646	2	jeer
jees	11	59	3854	2	jees
jeez	20	56	2203	2	jeez
keef	11	58	2999	2	keef
keek	7	56	2496	2	keek
keel	8	57	2946	2	keel
keen	8	48	3040	2	keen
keep	10	63	2981	2	keep
keet	8	53	4733	2	keet
lee	3	60	6814	2	lee_
leek	8	53	3173	2	leek
leer	4	62	3935	2	leer
lees	4	54	5588	2	lees
leet	4	59	5790	2	leet
meed	7	49	3470	2	meed
meek	10	56	2483	2	meek
meet	6	53	5055	2	meet
mem	7	79	4347	2	_mem
meme	8	53	3055	2	meme
nee	3	66	5778	2	nee_
need	5	49	3415	2	need
neems	7	73	1629	2	neems
neep	6	57	2831	2	neep
neum	6	67	2308	2	neum
odeum	8	46	1054	2	odeum
pee	5	60	6651	2	pee_
peed	7	62	3918	2	peed
peek	10	60	3143	2	peek
peel	6	55	3561	2	peel
peen	6	59	3808	2	peen
peep	8	58	3369	2	peep
peer	6	62	3835	2	peer
pees	6	52	5737	2	pees
perm	8	58	3463	2	perm
poem	8	62	2577	2	poem
ream	6	58	4161	2	ream
redeem	9	3	1152	2	redeem
ree	3	79	7407	2	ree_
reed	5	55	4962	2	reed
reef	7	49	3821	2	reef
reek	8	52	3252	2	reek
reel	4	52	4053	2	reel
rees	4	53	6419	2	rees
rehem	10	38	1535	2	rehem
rem	5	61	5004	2	_rem
retem	7	42	2195	2	retem
seam	6	66	4597	2	seam
see	3	57	7226	2	see_
seed	5	55	4948	2	seed
seek	8	59	3548	2	seek
seel	4	50	4298	2	seel
seems	7	55	2502	2	seems
seen	4	69	4312	2	seen
seep	6	65	4034	2	seep
seer	4	55	4704	2	seer
sees	4	53	6105	2	sees
seme	6	58	3665	2	seme
stem	6	106	2824	2	stem
team	6	62	3865	2	team
tee	3	83	6687	2	tee_
teed	5	54	3926	2	teed
teel	4	63	3580	2	teel
teems	7	60	1978	2	teems
teen	4	59	3820	2	teen
tees	4	53	5358	2	tees
term	6	62	3315	2	term
them	9	74	2704	2	them
vee	6	57	5018	2	vee_
veep	9	53	2509	2	veep
veer	7	62	2957	2	veer
vees	7	54	3943	2	vees
wee	6	67	6081	2	wee_
weed	8	56	3751	2	weed
week	11	64	2815	2	week
weel	7	58	3408	2	weel
ween	7	58	3546	2	ween
weep	9	51	3165	2	weep
weer	7	55	3509	2	weer
wees	7	62	4912	2	wees
weet	7	52	5415	2	weet
ylem	9	2	1789	2	ylem
zee	12	61	4323	2	zee_
zees	13	63	3189	2	zees

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	248	0.890	33564.0
3	Display Results	248	248	0.063	3936.5
	(SQL Overall)	178691	248	1.033	172982.6