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

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

299 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
deans	6	61	3139	(None)
beans	7	57	3469	1	beans
dans	5	67	4815	1	d_ans
deads	7	57	2691	1	deads
deals	6	54	3534	1	deals
dean	5	60	3948	1	dean_
dears	6	57	3688	1	dears
dedans	8	59	1507	1	dedans
dens	5	59	4507	1	de_ns
dewans	10	52	1514	1	dewans
jeans	12	60	2211	1	jeans
leans	5	55	3625	1	leans
means	7	58	3123	1	means
peans	7	54	3764	1	peans
weans	8	53	2674	1	weans
yeans	8	66	2488	1	yeans
aeons	5	76	2465	2	aeons
alans	5	56	3617	2	alans
azans	14	65	1688	2	azans
bans	6	65	5514	2	_bans
beads	8	54	2950	2	beads
beaks	11	53	2662	2	beaks
beams	9	53	2817	2	beams
bean	6	64	4386	2	bean_
beano	7	54	2155	2	beano
beanos	8	55	1651	2	beanos
bears	7	57	3904	2	bears
beats	7	60	4224	2	beats
beaus	7	51	2711	2	beaus
bens	6	59	4570	2	be_ns
brans	7	54	3743	2	brans
cans	6	50	5085	2	_cans
clans	7	50	3101	2	clans
cleans	8	58	1705	2	cleans
cyans	10	57	1481	2	cyans
dabs	7	71	3940	2	d_abs
dads	6	74	4278	2	d_ads
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
damans	9	47	1598	2	damans
damns	8	49	1692	2	damns
dams	7	74	4437	2	d_ams
dan	4	68	5967	2	d_an_
dang	6	51	3155	2	d_ang
dangs	7	56	2321	2	d_angs
dank	9	58	2824	2	d_ank
daps	7	72	3916	2	d_aps
darns	6	69	2789	2	darns
dawns	9	59	1659	2	dawns
daws	8	66	3824	2	d_aws
days	8	76	3713	2	d_ays
deacons	10	3	1039	2	deacons
dead	6	54	3424	2	dea_d
deadens	9	34	1069	2	deadens
deaf	8	58	3840	2	dea_f
deafens	11	31	725	2	deafens
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
deaned	8	46	2045	2	deaned
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
decafs	12	40	1088	2	decafs
decals	9	37	1771	2	decals
decane	9	38	1887	2	decane
decanes	10	31	1891	2	decanes
decant	9	35	2422	2	decant
decants	10	35	1444	2	decants
decays	12	46	1291	2	decays
decks	12	48	2219	2	decks
decos	8	55	2212	2	decos
deeds	7	54	2376	2	deeds
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
deewans	11	30	690	2	deewans
defang	11	3	775	2	defang
defangs	12	3	536	2	defangs
defats	10	51	1455	2	defats
defis	9	67	1750	2	defis
degas	7	51	1916	2	degas
deigns	8	38	998	2	deigns
deils	6	57	2286	2	deils
dekes	10	52	2445	2	dekes
delays	10	40	1405	2	delays
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
demand	10	43	1425	2	demand
demands	11	43	1141	2	demands
demeans	10	3	972	2	demeans
demes	8	60	3269	2	demes
demons	9	49	1772	2	demons
demos	8	60	2299	2	demos
den	4	75	5434	2	de_n_
denar	6	52	2329	2	denar
denars	7	46	2143	2	denars
dene	5	66	4341	2	de_ne
denes	6	56	3972	2	denes
deni	5	69	2939	2	de_ni
dense	6	59	2350	2	de_nse
dent	5	71	5841	2	de_nt
dents	6	50	3180	2	dents
deny	8	60	2712	2	de_ny
derats	7	46	2506	2	derats
derays	10	55	1425	2	derays
derms	8	50	2289	2	derms
desand	8	48	1263	2	desand
desands	9	48	1016	2	desands
desks	10	59	1307	2	desks
desmans	10	3	900	2	desmans
detains	8	37	1609	2	detains
devas	9	62	1888	2	devas
devons	10	45	1225	2	devons
devs	8	64	2403	2	de_vs
dewan	9	57	1804	2	dewan_
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
dins	5	66	5205	2	d_ins
divans	10	46	1239	2	divans
diwans	10	51	1037	2	diwans
djins	13	6	845	2	djins
doats	6	52	2488	2	doats
donas	6	59	2647	2	donas
dons	5	60	4870	2	d_ons
downs	9	49	1857	2	downs
drabs	8	51	1967	2	drabs
drags	7	55	2111	2	drags
drains	7	37	1940	2	drains
drams	8	60	2583	2	drams
drank	10	48	1620	2	drank
drats	6	66	2837	2	drats
draws	9	51	1937	2	draws
drays	9	58	1977	2	drays
dreads	8	41	1502	2	dreads
dreams	9	45	1398	2	dreams
drears	7	46	1425	2	drears
duads	7	65	1534	2	duads
duals	6	56	2008	2	duals
duns	5	51	4043	2	d_uns
durns	6	48	1987	2	durns
dyads	10	54	997	2	dyads
earns	5	59	2756	2	_earns
ears	4	63	5659	2	_ears
eats	4	70	5487	2	_eats
elans	5	55	2775	2	elans
ens	3	72	4592	2	_e_ns
eons	4	66	3871	2	_eons
erns	4	54	2823	2	_erns
fans	7	62	4737	2	_fans
fears	8	48	2939	2	fears
feats	8	64	3275	2	feats
fens	7	61	3976	2	fe_ns
ferns	8	52	2008	2	ferns
flans	8	53	2797	2	flans
gears	6	46	2869	2	gears
gens	5	57	4007	2	ge_ns
glans	6	51	2583	2	glans
gleans	7	50	1474	2	gleans
grans	6	48	3254	2	grans
guans	6	44	1944	2	guans
heads	9	51	2711	2	heads
heals	8	57	3346	2	heals
heaps	10	52	2322	2	heaps
hears	8	67	3737	2	hears
heats	8	58	3840	2	heats
hens	7	56	4257	2	he_ns
herns	8	48	2558	2	herns
ideals	7	50	1250	2	ideals
ideas	6	59	1901	2	idea_s
jean	11	66	2928	2	jean_
keas	8	63	3710	2	kea_s
keens	9	57	2118	2	keens
kens	8	54	3524	2	ke_ns
kerns	9	47	1956	2	kerns
khans	12	46	1517	2	khans
koans	9	58	1862	2	koans
leads	6	60	2849	2	leads
leafs	8	57	2118	2	leafs
leaks	9	59	2391	2	leaks
lean	4	63	4524	2	lean_
leant	5	67	3778	2	leant
leaps	7	55	2293	2	leaps
learns	6	55	1374	2	learns
lears	5	59	3873	2	lears
leas	4	59	5418	2	lea_s
lemans	8	53	1639	2	lemans
lens	4	61	4649	2	le_ns
loans	5	60	2646	2	loans
mans	6	63	5455	2	_mans
meads	8	54	2532	2	meads
meals	7	59	3338	2	meals
mean	6	55	3809	2	mean_
meant	7	65	3721	2	meant
meany	10	46	2048	2	meany
meats	7	50	3405	2	meats
moans	7	46	2437	2	moans
naans	5	58	1525	2	naans
nans	4	61	3940	2	_nans
neaps	7	56	1832	2	neaps
nears	5	55	2942	2	nears
neats	5	59	3190	2	neats
neons	5	58	1868	2	neons
oceans	8	12	1100	2	oceans
odeons	7	3	902	2	odeons
paeans	8	51	1826	2	paeans
pans	6	58	5573	2	_pans
peags	8	61	2284	2	peags
peaks	11	48	2562	2	peaks
peals	7	52	3549	2	peals
pean	6	61	4717	2	pean_
pears	7	51	3861	2	pears
peas	6	57	5506	2	pea_s
peats	7	61	4019	2	peats
pecans	10	15	1583	2	pecans
peens	7	64	2819	2	peens
peins	7	61	2806	2	peins
pekans	12	17	1055	2	pekans
pens	6	56	4964	2	pe_ns
peons	7	53	2718	2	peons
pians	7	51	2696	2	pians
plans	7	57	3127	2	plans
queans	15	31	1075	2	queans
reads	6	48	3527	2	reads
reals	5	50	3865	2	reals
reams	7	57	2962	2	reams
reaps	7	56	2619	2	reaps
rears	5	47	3965	2	rears
redans	7	54	2102	2	redans
reins	5	62	3456	2	reins
remans	8	48	2300	2	remans
roans	5	49	2644	2	roans
sans	4	51	5336	2	_sans
scans	7	46	2510	2	scans
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
sedans	7	48	1609	2	sedans
sewans	9	52	1590	2	sewans
skeans	10	45	1291	2	skeans
spans	7	45	2873	2	spans
speans	8	54	1714	2	speans
swans	8	46	2501	2	swans
tans	4	61	5483	2	_tans
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
teens	5	62	2748	2	teens
tens	4	56	4741	2	te_ns
terns	5	52	2687	2	terns
trans	5	49	3304	2	trans
ulans	5	49	2130	2	ulans
vans	7	62	3674	2	_vans
veals	8	49	2619	2	veals
vegans	10	39	1085	2	vegans
veins	8	46	2049	2	veins
wans	7	64	5227	2	_wans
weals	8	54	2874	2	weals
wean	7	57	3435	2	wean_
wears	8	60	3030	2	wears
weens	8	52	2405	2	weens
wens	7	63	3793	2	we_ns
yeahs	11	52	1455	2	yeahs
yean	7	58	3458	2	yean_
yearns	9	50	954	2	yearns
years	8	45	2767	2	years
yeas	7	86	3842	2	yea_s
yens	7	58	3226	2	ye_ns
yuans	8	46	1332	2	yuans
zeals	14	53	2085	2	zeals
zeins	14	47	1539	2	zeins

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	53800	0.313	570897.8
2	DLD Change Limit	53800	299	1.406	38264.6
3	Display Results	299	299	0.076	3934.2
	(SQL Overall)	178691	299	1.795	99549.3