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

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

267 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
deads	7	57	2691	(None)
beads	8	54	2950	1	beads
dads	6	74	4278	1	d_ads
dead	6	54	3424	1	dead_
deals	6	54	3534	1	deals
deans	6	61	3139	1	deans
dears	6	57	3688	1	dears
deeds	7	54	2376	1	deeds
dreads	8	41	1502	1	dreads
duads	7	65	1534	1	duads
dyads	10	54	997	1	dyads
heads	9	51	2711	1	heads
leads	6	60	2849	1	leads
meads	8	54	2532	1	meads
reads	6	48	3527	1	reads
ads	4	97	5574	2	__ads
bads	7	70	4887	2	_bads
bead	7	59	3792	2	bead_
beady	11	47	1992	2	beady
beaks	11	53	2662	2	beaks
beams	9	53	2817	2	beams
beans	7	57	3469	2	beans
beards	9	41	1667	2	beards
bears	7	57	3904	2	bears
beats	7	60	4224	2	beats
beaus	7	51	2711	2	beaus
beds	7	59	3779	2	be_ds
bends	8	56	2897	2	bends
brads	8	55	2829	2	brads
breads	9	54	1920	2	breads
cads	7	61	4453	2	_cads
chads	11	61	2223	2	chads
clads	8	57	2273	2	clads
dabs	7	71	3940	2	d_abs
dad	5	84	5617	2	d_ad_
dada	6	64	2245	2	d_ada
dadas	7	58	1986	2	d_adas
dado	6	71	2634	2	d_ado
dados	7	55	2243	2	d_ados
dags	6	66	4260	2	d_ags
dahs	8	82	3181	2	d_ahs
dais	5	70	4070	2	d_ais
daks	9	71	3060	2	d_aks
dals	5	71	4512	2	d_als
dams	7	74	4437	2	d_ams
dans	5	67	4815	2	d_ans
daps	7	72	3916	2	d_aps
daws	8	66	3824	2	d_aws
days	8	76	3713	2	d_ays
deaden	8	37	1432	2	deaden
deadens	9	34	1069	2	deadens
deader	8	42	2047	2	deader
deadest	9	30	1488	2	deadest
deadly	11	38	1147	2	deadly
deaf	8	58	3840	2	dea_f
deair	6	58	1719	2	deair
deairs	7	40	1378	2	deairs
deal	5	63	4741	2	dea_l
dealt	6	52	3428	2	dealt
dean	5	60	3948	2	dea_n
dear	5	53	4360	2	dea_r
deary	9	58	2684	2	deary
deash	9	56	1724	2	deash
death	9	48	2252	2	death
deaths	10	59	1444	2	deaths
deave	9	50	2233	2	deave
deaves	10	53	1953	2	deaves
debags	10	42	1106	2	debags
debars	9	42	1804	2	debars
debs	7	65	3024	2	de_bs
debts	8	64	1837	2	debts
decade	10	42	1616	2	decade
decades	11	36	1551	2	decades
decafs	12	40	1088	2	decafs
decals	9	37	1771	2	decals
decays	12	46	1291	2	decays
decks	12	48	2219	2	decks
decos	8	55	2212	2	decos
dedal	7	57	1902	2	dedal
dedans	8	59	1507	2	dedans
deed	6	53	4090	2	deed_
deedy	10	43	1589	2	deedy
deems	8	54	2177	2	deems
deeps	8	49	2177	2	deeps
deers	6	49	3052	2	deers
dees	5	63	5663	2	de_es
deets	6	53	3024	2	deets
defats	10	51	1455	2	defats
defis	9	67	1750	2	defis
degas	7	51	1916	2	degas
deils	6	57	2286	2	deils
dekes	10	52	2445	2	dekes
delays	10	40	1405	2	delays
deleads	9	37	970	2	deleads
deles	6	51	3925	2	deles
delfs	9	49	1867	2	delfs
delis	6	49	2854	2	delis
dells	6	66	3094	2	dells
dels	5	67	4547	2	de_ls
delts	6	57	3179	2	delts
demands	11	43	1141	2	demands
demes	8	60	3269	2	demes
demos	8	60	2299	2	demos
denars	7	46	2143	2	denars
denes	6	56	3972	2	denes
dens	5	59	4507	2	de_ns
dents	6	50	3180	2	dents
derats	7	46	2506	2	derats
derays	10	55	1425	2	derays
derms	8	50	2289	2	derms
desands	9	48	1016	2	desands
desks	10	59	1307	2	desks
devas	9	62	1888	2	devas
devs	8	64	2403	2	de_vs
dewans	10	52	1514	2	dewans
dewars	10	51	1707	2	dewars
dews	8	62	3060	2	de_ws
dexes	13	52	2451	2	dexes
deys	8	50	2747	2	de_ys
dhaks	13	47	970	2	dhaks
dhals	9	54	1544	2	dhals
dials	6	49	2534	2	dials
doats	6	52	2488	2	doats
drabs	8	51	1967	2	drabs
drags	7	55	2111	2	drags
drams	8	60	2583	2	drams
drats	6	66	2837	2	drats
draws	9	51	1937	2	draws
drays	9	58	1977	2	drays
dread	7	44	1902	2	dread_
dreams	9	45	1398	2	dreams
drears	7	46	1425	2	drears
dryads	11	43	662	2	dryads
duad	6	65	2141	2	duad_
duals	6	56	2008	2	duals
duds	6	55	3015	2	d_uds
dyad	9	64	1545	2	dyad_
ears	4	63	5659	2	_ears
eats	4	70	5487	2	_eats
eds	4	66	3893	2	_e_ds
egads	7	46	1092	2	egads
elds	5	63	2486	2	_elds
ends	5	65	2853	2	_ends
fads	8	69	3988	2	_fads
fears	8	48	2939	2	fears
feats	8	64	3275	2	feats
feds	8	52	3432	2	fe_ds
feeds	9	49	2114	2	feeds
fends	9	63	2497	2	fends
feods	9	95	1685	2	feods
feuds	9	59	1488	2	feuds
gads	6	78	4339	2	_gads
gears	6	46	2869	2	gears
geds	6	67	3082	2	ge_ds
gelds	7	51	1834	2	gelds
glads	7	56	2061	2	glads
goads	7	70	2285	2	goads
grads	7	56	2575	2	grads
head	8	71	3717	2	head_
heady	12	51	1726	2	heady
heals	8	57	3346	2	heals
heaps	10	52	2322	2	heaps
hears	8	67	3737	2	hears
heats	8	58	3840	2	heats
heeds	9	54	2042	2	heeds
herds	9	64	2468	2	herds
hexads	17	46	820	2	hexads
ideals	7	50	1250	2	ideals
ideas	6	59	1901	2	idea_s
jeans	12	60	2211	2	jeans
jehads	17	3	583	2	jehads
keas	8	63	3710	2	kea_s
kneads	11	35	709	2	kneads
lads	5	65	4914	2	_lads
lead	5	60	3885	2	lead_
leady	9	56	1860	2	leady
leafs	8	57	2118	2	leafs
leaks	9	59	2391	2	leaks
leans	5	55	3625	2	leans
leaps	7	55	2293	2	leaps
lears	5	59	3873	2	lears
leas	4	59	5418	2	lea_s
lends	6	53	2625	2	lends
leuds	6	62	1481	2	leuds
loads	6	53	2337	2	loads
mads	7	68	4538	2	_mads
mead	7	55	3160	2	mead_
meals	7	59	3338	2	meals
means	7	58	3123	2	means
meats	7	50	3405	2	meats
meds	7	57	3537	2	me_ds
meeds	8	49	2027	2	meeds
melds	8	48	2238	2	melds
menads	9	55	1438	2	menads
mends	8	49	2769	2	mends
neaps	7	56	1832	2	neaps
nears	5	55	2942	2	nears
neats	5	59	3190	2	neats
needs	6	57	1963	2	needs
nerds	6	57	1925	2	nerds
oreads	7	39	1577	2	oreads
pads	7	67	4296	2	_pads
peags	8	61	2284	2	peags
peaks	11	48	2562	2	peaks
peals	7	52	3549	2	peals
peans	7	54	3764	2	peans
pears	7	51	3861	2	pears
peas	6	57	5506	2	pea_s
peats	7	61	4019	2	peats
peds	7	58	3525	2	pe_ds
pends	8	55	2719	2	pends
pleads	9	46	1395	2	pleads
quads	15	45	1584	2	quads
rads	5	60	4661	2	_rads
read	5	59	4253	2	read_
readd	7	46	1713	2	readd
readds	8	41	1164	2	readds
ready	9	48	2150	2	ready
reals	5	50	3865	2	reals
reams	7	57	2962	2	reams
reaps	7	56	2619	2	reaps
rears	5	47	3965	2	rears
redds	7	46	1783	2	redds
reds	5	60	4287	2	re_ds
reeds	6	54	3090	2	reeds
rends	6	51	2995	2	rends
roads	6	65	2362	2	roads
scads	8	54	1996	2	scads
seals	5	48	3970	2	seals
seams	7	57	3166	2	seams
sears	5	47	4491	2	sears
seas	4	57	5527	2	sea_s
seats	5	48	4434	2	seats
seeds	6	43	3006	2	seeds
sends	6	55	2824	2	sends
shads	9	51	2448	2	shads
steads	7	41	1622	2	steads
tads	5	71	4395	2	_tads
teaks	9	42	2290	2	teaks
teals	5	62	3413	2	teals
teams	7	57	2651	2	teams
tears	5	54	3646	2	tears
teas	4	58	5149	2	tea_s
teats	5	56	3681	2	teats
teds	5	49	3258	2	te_ds
tends	6	54	2558	2	tends
toads	6	56	2107	2	toads
treads	7	48	1792	2	treads
veals	8	49	2619	2	veals
velds	9	56	1558	2	velds
vends	9	55	2089	2	vends
wads	8	73	4315	2	_wads
wealds	10	45	910	2	wealds
weals	8	54	2874	2	weals
weans	8	53	2674	2	weans
wears	8	60	3030	2	wears
weds	8	66	2894	2	we_ds
weeds	9	52	2221	2	weeds
welds	9	47	1916	2	welds
wends	9	58	2281	2	wends
woads	9	48	1844	2	woads
yeahs	11	52	1455	2	yeahs
yeans	8	66	2488	2	yeans
years	8	45	2767	2	years
yeas	7	86	3842	2	yea_s
zeals	14	53	2085	2	zeals
zeds	14	58	2181	2	ze_ds

Search took 9 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.890	200776.4
2	DLD Change Limit	53800	267	6.780	7935.1
3	Display Results	267	267	0.156	1711.5
	(SQL Overall)	178691	267	7.826	22833.0