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

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

367 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
deed	6	53	4090	(None)
dead	6	54	3424	1	dead
dee	4	76	6582	1	dee_
deeds	7	54	2376	1	deeds
deedy	10	43	1589	1	deedy
deem	7	54	3289	1	deem
deep	7	60	3188	1	deep
deer	5	67	3902	1	deer
dees	5	63	5663	1	dees
deet	5	73	5658	1	deet
deked	11	57	1853	1	deked
deled	7	53	2654	1	deled
dewed	10	50	2030	1	dewed
died	6	61	3785	1	died
dreed	7	52	2284	1	dreed
dyed	9	67	2076	1	dyed
feed	8	45	3890	1	feed
geed	6	54	3550	1	geed
heed	8	64	3760	1	heed
jeed	12	54	2850	1	jeed
meed	7	49	3470	1	meed
need	5	49	3415	1	need
peed	7	62	3918	1	peed
reed	5	55	4962	1	reed
seed	5	55	4948	1	seed
teed	5	54	3926	1	teed
weed	8	56	3751	1	weed
abed	7	97	3413	2	abed
aced	7	95	4088	2	aced
added	8	49	1843	2	added
adeem	8	3	1180	2	adeem
adzed	16	60	1254	2	adzed
aged	6	73	3425	2	aged
ahed	8	95	3625	2	ahed
aped	7	85	3815	2	aped
awed	8	84	3603	2	awed
axed	12	88	2961	2	axed
bead	7	59	3792	2	bead
bed	6	79	5062	2	_bed
bee	5	62	6240	2	bee_
beedi	8	7	1166	2	beedi
beef	9	62	3368	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
bend	7	64	3526	2	bend
bled	7	57	2931	2	bled
bleed	8	50	1980	2	bleed
bred	7	51	3097	2	bred
breed	8	55	2669	2	breed
cede	7	49	2876	2	cede
ceded	9	61	1855	2	ceded
cee	5	59	5270	2	cee_
cees	6	59	4159	2	cees
cered	8	52	2744	2	cered
coed	7	71	4054	2	coed
cred	7	65	3088	2	cred
creed	8	57	2739	2	creed
cued	7	63	2956	2	cued
dad	5	84	5616	2	d_ad
dared	7	59	3501	2	dared
dated	7	55	3099	2	dated
dawed	10	62	2281	2	dawed
dazed	16	59	1936	2	dazed
de	3	70	4954	2	d_e_
deads	7	57	2691	2	deads
deaf	8	58	3840	2	deaf
deal	5	63	4741	2	deal
dean	5	60	3948	2	dean
deaned	8	46	2045	2	deaned
dear	5	53	4360	2	dear
deaved	11	49	1655	2	deaved
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
decked	14	52	1762	2	decked
deco	7	61	2597	2	deco
deeded	9	46	1554	2	deeded
deemed	10	47	1306	2	deemed
deems	8	54	2177	2	deems
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
defend	11	39	1049	2	defend
defer	9	46	1975	2	defer
defi	8	63	2149	2	defi
defied	11	50	1638	2	defied
deft	8	55	4022	2	deft
defy	11	49	2126	2	defy
deiced	10	42	1448	2	deiced
deil	5	62	3162	2	deil
deke	9	52	2876	2	deke
dekes	10	52	2445	2	dekes
del	4	67	5275	2	d_el
dele	5	68	4308	2	dele
delead	8	41	1234	2	delead
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
delved	11	41	1275	2	delved
deme	7	65	3628	2	deme
demes	8	60	3269	2	demes
demo	7	74	2755	2	demo
demoed	10	37	1344	2	demoed
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
denied	8	43	1863	2	denied
denned	8	42	1563	2	denned
dens	5	59	4507	2	dens
dent	5	71	5841	2	dent
dented	8	41	2051	2	dented
deny	8	60	2712	2	deny
depend	10	35	1092	2	depend
dere	5	68	4590	2	dere
derm	7	60	3189	2	derm
desex	13	3	1198	2	desex
desk	9	56	1890	2	desk
deter	6	50	2804	2	deter
deuced	10	41	1212	2	deuced
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
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
diced	9	58	2468	2	diced
did	5	68	5051	2	d_id
die	4	67	5965	2	die_
diel	5	90	3460	2	diel
dies	5	56	5352	2	dies
diet	5	73	5753	2	diet
dieted	8	31	1549	2	dieted
diked	11	50	2468	2	diked
dined	7	64	3199	2	dined
dived	10	63	2137	2	dived
doe	4	73	6195	2	doe_
doer	5	77	3470	2	doer
does	5	65	5447	2	does
doled	7	54	3091	2	doled
domed	9	54	2326	2	domed
doped	9	53	2671	2	doped
dosed	7	66	2691	2	dosed
doted	7	52	2707	2	doted
dowed	10	46	3261	2	dowed
dozed	16	56	1935	2	dozed
dread	7	44	1902	2	dread
dree	5	66	3832	2	dree
drees	6	56	2852	2	drees
dreg	6	68	2165	2	dreg
drek	9	63	2109	2	drek
drew	8	62	2167	2	drew
dried	7	53	2138	2	dried
duad	6	65	2141	2	duad
dud	5	67	3759	2	d_ud
dude	6	56	2966	2	dude
duded	8	44	1713	2	duded
due	4	52	4986	2	due_
duel	5	67	2970	2	duel
dueled	8	48	1366	2	dueled
dues	5	60	4550	2	dues
duet	5	64	4626	2	duet
dueted	8	41	1359	2	dueted
duked	11	52	1846	2	duked
duped	9	51	1832	2	duped
dured	7	50	2540	2	dured
dweeb	11	3	774	2	dweeb
dyad	9	64	1545	2	dyad
dye	7	53	3484	2	dye_
dyer	8	55	2211	2	dyer
dyes	8	53	3189	2	dyes
dyked	14	53	1095	2	dyked
ed	3	86	4518	2	__ed
edged	8	55	1451	2	edged
eek	7	79	3510	2	_eek
eel	3	79	4684	2	_eel
eked	9	67	1802	2	eked
eld	4	67	3379	2	_eld
end	4	68	3435	2	_end
exed	12	54	2059	2	exed
eyed	8	66	2323	2	eyed
fed	7	65	4835	2	_fed
fee	6	68	6201	2	fee_
feeb	9	69	2454	2	feeb
feeds	9	49	2114	2	feeds
feel	7	52	3384	2	feel
fees	7	64	5060	2	fees
feet	7	53	5221	2	feet
fend	8	48	3297	2	fend
feod	8	155	2300	2	feod
feted	9	44	2093	2	feted
feud	8	65	2302	2	feud
feued	9	47	1566	2	feued
fled	8	54	2977	2	fled
freed	9	52	2354	2	freed
gaed	6	60	3151	2	gaed
ged	5	70	4453	2	_ged
gee	4	53	5920	2	gee_
geek	9	53	2702	2	geek
gees	5	56	4788	2	gees
geez	14	64	2486	2	geez
geld	6	58	2843	2	geld
gied	6	46	3198	2	gied
gled	6	56	3114	2	gled
gleed	7	53	2057	2	gleed
greed	7	51	2569	2	greed
haed	8	63	3858	2	haed
head	8	71	3717	2	head
heeds	9	54	2042	2	heeds
heel	7	50	3422	2	heel
held	8	53	3040	2	held
herd	8	49	3306	2	herd
hewed	12	56	1943	2	hewed
hexed	16	56	1576	2	hexed
hied	8	54	3404	2	hied
hoed	8	78	3798	2	hoed
hued	8	69	2585	2	hued
iced	7	87	2189	2	iced
idled	7	49	1521	2	idled
indeed	8	39	1356	2	indeed
ired	5	51	3187	2	ired
jee	10	66	4864	2	jee_
jeep	13	56	2484	2	jeep
jeer	11	54	2646	2	jeer
jees	11	59	3854	2	jees
jeez	20	56	2203	2	jeez
jewed	16	51	1483	2	jewed
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
keyed	13	6	938	2	keyed
kneed	10	46	1205	2	kneed
lead	5	60	3885	2	lead
led	4	62	5455	2	_led
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
lend	5	62	3367	2	lend
leud	5	72	2342	2	leud
lewd	8	57	1659	2	lewd
lied	5	58	3809	2	lied
mead	7	55	3160	2	mead
med	6	61	4674	2	_med
meeds	8	49	2027	2	meeds
meek	10	56	2483	2	meek
meet	6	53	5055	2	meet
meld	7	58	3047	2	meld
mend	7	53	3403	2	mend
meted	8	54	2443	2	meted
mewed	11	52	1801	2	mewed
nee	3	66	5778	2	nee_
needs	6	57	1963	2	needs
needy	9	46	1469	2	needy
neem	6	73	2808	2	neem
neep	6	57	2831	2	neep
nerd	5	66	2494	2	nerd
ohed	8	78	2518	2	ohed
oped	7	62	3015	2	oped
owed	8	68	3387	2	owed
ped	6	67	5152	2	_ped
pee	5	60	6651	2	pee_
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
pend	7	59	3453	2	pend
pied	7	50	3536	2	pied
pled	7	52	3143	2	pled
preed	8	51	2812	2	preed
read	5	59	4253	2	read
red	4	67	5580	2	_red
redd	6	63	2317	2	redd
rede	5	50	3766	2	rede
reded	7	48	2911	2	reded
ree	3	79	7407	2	ree_
reeds	6	54	3090	2	reeds
reedy	9	100	2029	2	reedy
reef	7	49	3821	2	reef
reek	8	52	3252	2	reek
reel	4	52	4053	2	reel
rees	4	53	6419	2	rees
refed	9	39	2192	2	refed
rend	5	61	3657	2	rend
rewed	9	54	2545	2	rewed
rued	5	57	2979	2	rued
see	3	57	7226	2	see_
seeds	6	43	3006	2	seeds
seedy	9	48	2153	2	seedy
seek	8	59	3548	2	seek
seel	4	50	4298	2	seel
seem	6	54	3856	2	seem
seen	4	69	4312	2	seen
seep	6	65	4034	2	seep
seer	4	55	4704	2	seer
sees	4	53	6105	2	sees
send	5	52	3729	2	send
sered	6	57	3729	2	sered
sewed	9	53	2516	2	sewed
sexed	13	66	1854	2	sexed
shed	8	65	3615	2	shed
skeed	10	50	1898	2	skeed
sled	5	53	3437	2	sled
sned	5	60	2605	2	sned
sped	7	60	3149	2	sped
speed	8	55	2662	2	speed
steed	6	60	2494	2	steed
sued	5	65	3793	2	sued
ted	4	64	4656	2	_ted
tee	3	83	6687	2	tee_
teel	4	63	3580	2	teel
teem	6	61	3260	2	teem
teen	4	59	3820	2	teen
tees	4	53	5358	2	tees
tend	5	64	3377	2	tend
tewed	9	47	1853	2	tewed
tied	5	55	3521	2	tied
toed	5	61	3704	2	toed
treed	6	56	2673	2	treed
tweed	9	49	1509	2	tweed
used	5	57	2282	2	used
vee	6	57	5018	2	vee_
veep	9	53	2509	2	veep
veer	7	62	2957	2	veer
vees	7	54	3943	2	vees
veld	8	53	2320	2	veld
vend	8	66	2642	2	vend
vexed	16	57	1311	2	vexed
vied	8	63	2863	2	vied
wed	7	58	4362	2	_wed
wee	6	67	6081	2	wee_
weeds	9	52	2221	2	weeds
weedy	12	51	1500	2	weedy
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
weld	8	47	2773	2	weld
wend	8	53	3045	2	wend
yeld	8	114	2387	2	yeld
zed	13	54	3117	2	_zed
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.063	2836365.1
2	DLD Change Limit	29872	367	0.983	30388.6
3	Display Results	367	367	0.093	3946.2
	(SQL Overall)	178691	367	1.139	156884.1