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

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

313 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
dead	6	54	3424	(None)
bead	7	59	3792	1	bead
dad	5	84	5616	1	d_ad
deads	7	57	2691	1	deads
deaf	8	58	3840	1	deaf
deal	5	63	4741	1	deal
dean	5	60	3948	1	dean
dear	5	53	4360	1	dear
deed	6	53	4090	1	deed
dread	7	44	1902	1	dread
duad	6	65	2141	1	duad
dyad	9	64	1545	1	dyad
head	8	71	3717	1	head
lead	5	60	3885	1	lead
mead	7	55	3160	1	mead
read	5	59	4253	1	read
ad	3	119	7503	2	__ad
ahead	9	68	1705	2	ahead
bad	6	77	6315	2	_bad
beads	8	54	2950	2	beads
beady	11	47	1992	2	beady
beak	10	65	3438	2	beak
beam	8	69	3923	2	beam
bean	6	64	4386	2	bean
bear	6	68	4464	2	bear
beard	8	60	2496	2	beard
beat	6	61	6830	2	beat
beau	6	61	3727	2	beau
bed	6	79	5062	2	be_d
bend	7	64	3526	2	bend
brad	7	52	3434	2	brad
bread	8	55	2311	2	bread
cad	6	74	5636	2	_cad
chad	10	55	2550	2	chad
clad	7	62	2582	2	clad
dab	6	74	5556	2	d_ab
dada	6	64	2244	2	d_ada
dado	6	71	2633	2	d_ado
dads	6	74	4277	2	d_ads
dag	5	77	5301	2	d_ag
dah	7	81	4898	2	d_ah
dak	8	63	4069	2	d_ak
dal	4	75	5495	2	d_al
dam	6	74	5704	2	d_am
dan	4	68	5967	2	d_an
dap	6	66	5245	2	d_ap
daw	7	71	4836	2	d_aw
day	7	62	5411	2	d_ay
de	3	70	4954	2	de__
deaden	8	37	1432	2	deaden
deader	8	42	2047	2	deader
deadly	11	38	1147	2	deadly
deair	6	58	1719	2	deair
deals	6	54	3534	2	deals
dealt	6	52	3428	2	dealt
deaned	8	46	2045	2	deaned
deans	6	61	3139	2	deans
dears	6	57	3688	2	dears
deary	9	58	2684	2	deary
deash	9	56	1724	2	deash
death	9	48	2252	2	death
deave	9	50	2233	2	deave
deaved	11	49	1655	2	deaved
deb	6	63	4269	2	de_b
debag	9	42	1230	2	debag
debar	8	55	1786	2	debar
debs	7	65	3024	2	debs
debt	7	71	3902	2	debt
decade	10	42	1616	2	decade
decaf	11	49	1944	2	decaf
decal	8	55	2323	2	decal
decay	11	47	1848	2	decay
deck	11	58	2775	2	deck
deco	7	61	2597	2	deco
dedal	7	57	1902	2	dedal
dee	4	76	6582	2	de_e
deeds	7	54	2376	2	deeds
deedy	10	43	1589	2	deedy
deem	7	54	3289	2	deem
deep	7	60	3188	2	deep
deer	5	67	3902	2	deer
dees	5	63	5663	2	dees
deet	5	73	5658	2	deet
def	7	65	4672	2	de_f
defat	9	54	2669	2	defat
defi	8	63	2149	2	defi
deft	8	55	4022	2	deft
defy	11	49	2126	2	defy
degas	7	51	1916	2	degas
deil	5	62	3162	2	deil
deke	9	52	2876	2	deke
deked	11	57	1853	2	deked
del	4	67	5275	2	de_l
delay	9	48	2063	2	delay
dele	5	68	4308	2	dele
delead	8	41	1234	2	delead
deled	7	53	2654	2	deled
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
demand	10	43	1425	2	demand
deme	7	65	3628	2	deme
demo	7	74	2755	2	demo
demy	10	54	2285	2	demy
den	4	75	5434	2	de_n
denar	6	52	2329	2	denar
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
derat	6	50	4408	2	derat
deray	9	50	2418	2	deray
dere	5	68	4590	2	dere
derm	7	60	3189	2	derm
desand	8	48	1263	2	desand
desk	9	56	1890	2	desk
dev	7	60	3377	2	de_v
deva	8	57	2098	2	deva
devas	9	62	1888	2	devas
devs	8	64	2403	2	devs
dew	7	71	3992	2	de_w
dewan	9	57	1804	2	dewan
dewar	9	58	1773	2	dewar
dewax	16	55	1085	2	dewax
dewed	10	50	2030	2	dewed
dews	8	62	3060	2	dews
dewy	11	54	1902	2	dewy
dex	11	69	3688	2	de_x
dexy	15	61	1855	2	dexy
dey	7	72	4337	2	de_y
deys	8	50	2747	2	deys
dhak	12	55	1203	2	dhak
dhal	8	67	1928	2	dhal
dial	5	59	3506	2	dial
did	5	68	5052	2	d_id
died	6	61	3785	2	died
doat	5	69	4767	2	doat
drab	7	62	2645	2	drab
drag	6	48	2505	2	drag
dram	7	58	3200	2	dram
drat	5	62	4783	2	drat
draw	8	56	2301	2	draw
dray	8	54	2809	2	dray
dreads	8	41	1502	2	dreads
dream	8	51	2039	2	dream
drear	6	50	1690	2	drear
dreed	7	52	2284	2	dreed
dryad	10	47	758	2	dryad
duads	7	65	1534	2	duads
dual	5	59	2817	2	dual
dud	5	67	3759	2	d_ud
dyads	10	54	997	2	dyads
dyed	9	67	2076	2	dyed
ear	3	68	6788	2	_ear
eat	3	69	8905	2	_eat
eau	3	74	5094	2	_eau
ed	3	86	4518	2	_e_d
egad	6	42	1541	2	egad
eld	4	67	3379	2	_eld
end	4	68	3435	2	_end
fad	7	74	5241	2	_fad
feal	7	139	4042	2	feal
fear	7	53	3779	2	fear
feat	7	64	5822	2	feat
fed	7	65	4835	2	fe_d
feed	8	45	3890	2	feed
fend	8	48	3297	2	fend
feod	8	155	2300	2	feod
feud	8	65	2302	2	feud
gad	5	75	5665	2	_gad
gaed	6	60	3151	2	gaed
gear	5	59	3497	2	gear
ged	5	70	4453	2	ge_d
geed	6	54	3550	2	geed
geld	6	58	2843	2	geld
glad	6	56	2401	2	glad
goad	6	68	3098	2	goad
grad	6	68	2986	2	grad
had	7	76	5876	2	_had
haed	8	63	3858	2	haed
heads	9	51	2711	2	heads
heady	12	51	1726	2	heady
heal	7	56	4569	2	heal
heap	9	64	3289	2	heap
hear	7	61	4388	2	hear
heard	9	52	2275	2	heard
heat	7	70	6142	2	heat
heed	8	64	3760	2	heed
held	8	53	3040	2	held
herd	8	49	3306	2	herd
hexad	16	49	1062	2	hexad
idea	5	91	2277	2	idea_
ideal	6	57	1639	2	ideal
ideas	6	59	1901	2	ideas
jean	11	66	2928	2	jean
jeed	12	54	2850	2	jeed
jehad	16	3	768	2	jehad
kea	7	65	4091	2	kea_
keas	8	63	3709	2	keas
knead	10	42	966	2	knead
lad	4	81	6570	2	_lad
lea	3	76	6018	2	lea_
leads	6	60	2849	2	leads
leady	9	56	1860	2	leady
leaf	7	64	4103	2	leaf
leak	8	62	3371	2	leak
leal	4	60	4327	2	leal
lean	4	63	4524	2	lean
leap	6	60	3268	2	leap
lear	4	70	4595	2	lear
leas	4	59	5418	2	leas
led	4	62	5455	2	le_d
lend	5	62	3367	2	lend
leud	5	72	2342	2	leud
lewd	8	57	1659	2	lewd
load	5	67	3060	2	load
mad	6	89	5871	2	_mad
meads	8	54	2532	2	meads
meal	6	56	4317	2	meal
mean	6	55	3809	2	mean
meat	6	63	5960	2	meat
med	6	61	4674	2	me_d
meed	7	49	3470	2	meed
meld	7	58	3047	2	meld
menad	8	59	1898	2	menad
mend	7	53	3403	2	mend
neap	6	69	2701	2	neap
near	4	52	3650	2	near
neat	4	63	5678	2	neat
need	5	49	3415	2	need
nerd	5	66	2494	2	nerd
odea	5	62	2457	2	odea_
orad	5	60	3169	2	orad
oread	6	46	1960	2	oread
pad	6	80	5732	2	_pad
pea	5	66	5724	2	pea_
peag	7	54	3134	2	peag
peak	10	65	3520	2	peak
peal	6	86	4810	2	peal
pean	6	61	4717	2	pean
pear	6	97	4523	2	pear
peas	6	57	5506	2	peas
peat	6	59	6793	2	peat
ped	6	67	5152	2	pe_d
peed	7	62	3918	2	peed
pend	7	59	3453	2	pend
plead	8	58	1846	2	plead
quad	14	46	1870	2	quad
rad	4	76	6200	2	_rad
readd	7	46	1713	2	readd
reads	6	48	3527	2	reads
ready	9	48	2150	2	ready
real	4	57	5029	2	real
ream	6	58	4161	2	ream
reap	6	59	3474	2	reap
rear	4	56	4455	2	rear
red	4	67	5580	2	re_d
redd	6	63	2317	2	redd
reed	5	55	4962	2	reed
rend	5	61	3657	2	rend
road	5	63	3211	2	road
sad	4	74	5920	2	_sad
scad	7	57	2577	2	scad
sea	3	61	6129	2	sea_
seal	4	56	5437	2	seal
seam	6	66	4597	2	seam
sear	4	73	5384	2	sear
seas	4	57	5527	2	seas
seat	4	75	7556	2	seat
seed	5	55	4948	2	seed
send	5	52	3729	2	send
shad	8	62	3091	2	shad
stead	6	55	2027	2	stead
tad	4	79	5982	2	_tad
tea	3	73	5332	2	tea_
teak	8	59	3084	2	teak
teal	4	55	4650	2	teal
team	6	62	3865	2	team
tear	4	52	4288	2	tear
teas	4	58	5149	2	teas
teat	4	59	6363	2	teat
ted	4	64	4656	2	te_d
teed	5	54	3926	2	teed
tend	5	64	3377	2	tend
toad	5	58	3018	2	toad
trad	5	56	3091	2	trad
tread	6	48	2170	2	tread
undead	8	27	1190	2	undead
veal	7	69	3681	2	veal
veld	8	53	2320	2	veld
vend	8	66	2642	2	vend
wad	7	70	5389	2	_wad
weak	11	71	2630	2	weak
weal	7	58	3868	2	weal
weald	9	56	1502	2	weald
wean	7	57	3435	2	wean
wear	7	58	3672	2	wear
wed	7	58	4362	2	we_d
weed	8	56	3751	2	weed
weld	8	47	2773	2	weld
wend	8	53	3045	2	wend
woad	8	55	2394	2	woad
yea	6	64	4575	2	yea_
yeah	10	67	2541	2	yeah
yean	7	58	3458	2	yean
year	7	65	3425	2	year
yeas	7	86	3842	2	yeas
yeld	8	114	2387	2	yeld
zeal	13	55	3033	2	zeal
zed	13	54	3117	2	ze_d

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.406	440125.6
2	DLD Change Limit	29872	313	1.080	27659.3
3	Display Results	313	313	0.060	5216.7
	(SQL Overall)	178691	313	1.546	115582.8