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

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

358 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
dews	8	62	3060	(None)
daws	8	66	3824	1	daws
debs	7	65	3024	1	debs
dees	5	63	5663	1	dees
dels	5	67	4547	1	dels
dens	5	59	4507	1	dens
devs	8	64	2403	1	devs
dew	7	71	3992	1	dew_
dewy	11	54	1902	1	dewy
deys	8	50	2747	1	deys
dows	8	59	4105	1	dows
hews	10	56	3157	1	hews
jews	14	58	2208	1	jews
mews	9	66	2933	1	mews
news	7	61	2737	1	news
pews	9	57	3153	1	pews
sews	7	58	3602	1	sews
tews	7	64	3164	1	tews
yews	10	53	2396	1	yews
awes	7	60	3755	2	awes
bedews	12	39	894	2	bedews
beds	7	59	3778	2	beds
bees	6	54	5338	2	bees
begs	7	57	3383	2	begs
bels	6	61	4249	2	bels
bens	6	59	4570	2	bens
bes	5	65	5743	2	be_s
bets	6	70	5144	2	bets
beys	9	138	2955	2	beys
bows	9	62	4286	2	bows
brews	10	56	1707	2	brews
caws	9	60	3610	2	caws
cees	6	59	4159	2	cees
cels	6	55	3497	2	cels
ceps	8	61	2595	2	ceps
cess	6	53	2605	2	cess
chews	13	54	1851	2	chews
clews	10	55	1633	2	clews
cows	9	70	4664	2	cows
crews	10	59	1749	2	crews
dabs	7	71	3940	2	dabs
dads	6	74	4277	2	dads
dags	6	66	4259	2	dags
dahs	8	82	3181	2	dahs
dais	5	70	4070	2	dais
daks	9	71	3060	2	daks
dals	5	71	4512	2	dals
dams	7	74	4437	2	dams
dans	5	67	4814	2	dans
daps	7	72	3916	2	daps
daw	7	71	4836	2	daw_
dawk	12	61	1728	2	dawk
dawks	13	52	1349	2	dawks
dawn	8	56	2420	2	dawn
dawns	9	59	1659	2	dawns
dawt	8	54	3594	2	dawt
dawts	9	72	1612	2	dawts
days	8	76	3713	2	days
de	3	70	4954	2	de__
dead	6	54	3424	2	dead
deads	7	57	2691	2	deads
deaf	8	58	3840	2	deaf
deal	5	63	4741	2	deal
deals	6	54	3534	2	deals
dean	5	60	3948	2	dean
deans	6	61	3139	2	deans
dear	5	53	4360	2	dear
dears	6	57	3688	2	dears
deash	9	56	1724	2	deash
deb	6	63	4269	2	de_b
debt	7	71	3902	2	debt
debts	8	64	1837	2	debts
deck	11	58	2775	2	deck
decks	12	48	2219	2	decks
deco	7	61	2597	2	deco
decos	8	55	2212	2	decos
dee	4	76	6582	2	de_e
deed	6	53	4090	2	deed
deeds	7	54	2376	2	deeds
deem	7	54	3289	2	deem
deems	8	54	2177	2	deems
deep	7	60	3188	2	deep
deeps	8	49	2177	2	deeps
deer	5	67	3902	2	deer
deers	6	49	3052	2	deers
deet	5	73	5658	2	deet
deets	6	53	3024	2	deets
def	7	65	4672	2	de_f
defi	8	63	2149	2	defi
defis	9	67	1750	2	defis
deft	8	55	4022	2	deft
defy	11	49	2126	2	defy
degas	7	51	1916	2	degas
deil	5	62	3162	2	deil
deils	6	57	2286	2	deils
deism	8	41	1603	2	deism
deist	6	46	3359	2	deist
deke	9	52	2876	2	deke
dekes	10	52	2445	2	dekes
del	4	67	5275	2	de_l
dele	5	68	4308	2	dele
deles	6	51	3925	2	deles
delf	8	54	3657	2	delf
delfs	9	49	1867	2	delfs
deli	5	56	3129	2	deli
delis	6	49	2854	2	delis
dell	5	69	3820	2	dell
dells	6	66	3094	2	dells
delt	5	78	5527	2	delt
delts	6	57	3179	2	delts
deme	7	65	3628	2	deme
demes	8	60	3269	2	demes
demo	7	74	2755	2	demo
demos	8	60	2299	2	demos
demy	10	54	2285	2	demy
den	4	75	5434	2	de_n
dene	5	66	4341	2	dene
denes	6	56	3972	2	denes
deni	5	69	2939	2	deni
dense	6	59	2350	2	dense
dent	5	71	5841	2	dent
dents	6	50	3180	2	dents
deny	8	60	2712	2	deny
dere	5	68	4590	2	dere
derm	7	60	3189	2	derm
derms	8	50	2289	2	derms
desk	9	56	1890	2	desk
desks	10	59	1307	2	desks
dev	7	60	3377	2	de_v
deva	8	57	2098	2	deva
devas	9	62	1888	2	devas
dewan	9	57	1804	2	dewan
dewans	10	52	1514	2	dewans
dewar	9	58	1773	2	dewar
dewars	10	51	1707	2	dewars
dewax	16	55	1085	2	dewax
dewed	10	50	2030	2	dewed
dex	11	69	3688	2	de_x
dexes	13	52	2451	2	dexes
dexy	15	61	1855	2	dexy
dey	7	72	4337	2	de_y
dhows	12	59	1122	2	dhows
dibs	7	62	3367	2	dibs
dies	5	56	5352	2	dies
diets	6	60	2664	2	diets
difs	8	60	2732	2	difs
digs	6	60	3605	2	digs
dims	7	54	3502	2	dims
dins	5	66	5204	2	dins
dips	7	55	3691	2	dips
dis	4	64	5989	2	d_is
diss	5	64	3448	2	diss
dits	5	64	5052	2	dits
docs	7	56	3115	2	docs
doers	6	52	2571	2	doers
does	5	65	5447	2	does
dogs	6	64	4015	2	dogs
dols	5	69	4305	2	dols
doms	7	62	3957	2	doms
dons	5	60	4870	2	dons
dors	5	67	4760	2	dors
dos	4	80	6231	2	d_os
doss	5	62	3504	2	doss
dots	5	56	4766	2	dots
dow	7	67	4997	2	dow_
down	8	64	2749	2	down
downs	9	49	1857	2	downs
dowse	9	60	2081	2	dowse
draws	9	51	1937	2	draws
drees	6	56	2852	2	drees
dregs	7	61	1486	2	dregs
dreks	10	57	1474	2	dreks
dress	6	53	1983	2	dress
drew	8	62	2167	2	drew_
drys	8	63	1480	2	drys
dubs	7	84	3219	2	dubs
duds	6	55	3014	2	duds
duels	6	56	1923	2	duels
dues	5	60	4550	2	dues
duets	6	53	2388	2	duets
dugs	6	148	3228	2	dugs
duns	5	51	4043	2	duns
duos	5	67	2813	2	duos
dups	7	59	2951	2	dups
dyers	9	66	1713	2	dyers
dyes	8	53	3189	2	dyes
edhs	8	62	1210	2	edhs
eds	4	66	3892	2	_eds
eels	4	65	3674	2	eels
efs	6	68	2960	2	_efs
els	3	76	4572	2	_els
ems	5	64	3549	2	_ems
ens	3	72	4592	2	_ens
ers	3	60	4628	2	_ers
es	2	90	4822	2	_e_s
ess	3	60	3088	2	_ess
ewe	6	66	3098	2	_ewe
ewes	7	63	2870	2	_ewes
feds	8	52	3431	2	feds
fees	7	64	5060	2	fees
fehs	10	65	2238	2	fehs
fems	9	64	2870	2	fems
fens	7	61	3976	2	fens
fes	6	65	5167	2	fe_s
fess	7	65	2916	2	fess
fets	7	53	4594	2	fets
feus	7	58	3075	2	feus
few	9	54	3696	2	few_
flews	11	53	1644	2	flews
geds	6	67	3081	2	geds
gees	5	56	4788	2	gees
gels	5	68	3610	2	gels
gems	7	53	2911	2	gems
gens	5	57	4007	2	gens
gets	5	54	4248	2	gets
haws	10	64	3944	2	haws
hehs	10	67	2396	2	hehs
hems	9	55	3494	2	hems
hens	7	56	4257	2	hens
hers	7	58	4487	2	hers
hes	6	66	5420	2	he_s
hets	7	55	4720	2	hets
hew	9	76	4272	2	hew_
hewn	10	67	1985	2	hewn
hows	10	63	4560	2	hows
ideas	6	59	1901	2	ideas
ides	5	77	3423	2	ide_s
jaws	14	50	2729	2	jaws
jees	11	59	3854	2	jees
jess	11	60	2203	2	jess
jets	11	58	3410	2	jets
jew	13	51	2908	2	jew_
jows	14	66	3209	2	jows
keas	8	63	3709	2	keas
kefs	11	59	2274	2	kefs
kegs	9	58	2401	2	kegs
kens	8	54	3523	2	kens
keps	10	60	2730	2	keps
keys	11	63	2216	2	keys
laws	7	64	4168	2	laws
leas	4	59	5418	2	leas
lees	4	54	5588	2	lees
legs	5	61	3369	2	legs
leis	4	57	3960	2	leis
leks	8	54	2760	2	leks
lens	4	61	4649	2	lens
les	3	56	6307	2	le_s
less	4	56	3510	2	less
lets	4	71	4794	2	lets
lewd	8	57	1659	2	lewd
lewis	8	53	1584	2	lewis
leys	7	64	3018	2	leys
lows	7	58	4301	2	lows
maws	9	64	3713	2	maws
meds	7	57	3536	2	meds
megs	7	55	3063	2	megs
mels	6	59	4153	2	mels
mems	8	59	3150	2	mems
meows	10	46	1268	2	meows
mess	6	59	3243	2	mess
mew	8	61	3773	2	mew_
mewl	9	56	1832	2	mewl
mewls	10	58	1323	2	mewls
mows	9	63	4083	2	mows
nebs	6	61	2498	2	nebs
negs	5	57	2736	2	negs
ness	4	55	2656	2	ness
nets	4	59	4153	2	nets
new	6	62	3709	2	new_
newsy	11	48	939	2	newsy
newt	7	69	3374	2	newt
newts	8	60	1528	2	newts
nows	7	57	3823	2	nows
odes	5	72	4324	2	ode_s
oes	3	58	6619	2	oe_s
owes	7	51	3710	2	owes
paws	9	60	3818	2	paws
peas	6	57	5506	2	peas
pecs	8	46	3410	2	pecs
peds	7	58	3524	2	peds
pees	6	52	5737	2	pees
pegs	7	55	3176	2	pegs
pehs	9	56	2576	2	pehs
pens	6	56	4964	2	pens
peps	8	51	3451	2	peps
pes	5	72	5978	2	pe_s
pets	6	62	4833	2	pets
pew	8	64	4230	2	pew_
plews	10	54	1535	2	plews
pows	9	55	3766	2	pows
raws	7	52	3821	2	raws
rebs	6	57	3356	2	rebs
recs	6	57	3418	2	recs
reds	5	60	4286	2	reds
rees	4	53	6419	2	rees
refs	7	57	3224	2	refs
regs	5	54	3657	2	regs
reis	4	53	4323	2	reis
rems	6	62	3772	2	rems
reps	6	59	3795	2	reps
res	3	55	6504	2	re_s
rets	4	53	5256	2	rets
revs	7	50	2705	2	revs
rows	7	59	4175	2	rows
saws	7	58	3948	2	saws
seas	4	57	5527	2	seas
secs	6	50	3389	2	secs
sees	4	53	6105	2	sees
segs	5	49	3388	2	segs
seis	4	55	4239	2	seis
sels	4	63	4598	2	sels
sers	4	57	4665	2	sers
sets	4	55	4950	2	sets
sew	6	62	4726	2	sew_
sewn	7	61	2433	2	sewn
shews	11	59	2471	2	shews
skews	12	54	1380	2	skews
slews	8	62	2035	2	slews
smews	10	46	1229	2	smews
sows	7	53	4249	2	sows
spews	10	50	1592	2	spews
stews	8	55	1914	2	stews
taws	7	56	4159	2	taws
teas	4	58	5149	2	teas
teds	5	49	3257	2	teds
tees	4	53	5358	2	tees
tegs	5	60	3149	2	tegs
tels	4	68	4169	2	tels
tens	4	56	4741	2	tens
tets	4	58	4745	2	tets
tew	6	66	4015	2	tew_
thews	11	74	1619	2	thews
tows	7	85	4555	2	tows
trews	8	61	1889	2	trews
vaws	10	55	2732	2	vaws
vees	7	54	3943	2	vees
vets	7	68	3509	2	vets
views	11	48	964	2	views
vows	10	66	2694	2	vows
waws	10	68	3490	2	waws
webs	9	66	2212	2	webs
weds	8	66	2893	2	weds
wees	7	62	4912	2	wees
wens	7	63	3793	2	wens
wets	7	59	4029	2	wets
whews	14	51	1449	2	whews
wows	10	46	3349	2	wows
yaws	10	55	3121	2	yaws
yeas	7	86	3842	2	yeas
yens	7	58	3226	2	yens
yeps	9	59	2440	2	yeps
yes	6	62	5061	2	ye_s
yew	9	64	3629	2	yew_
yows	10	64	3312	2	yows
zeds	14	58	2180	2	zeds
zees	13	63	3189	2	zees
zeks	17	58	1506	2	zeks
zeps	15	60	1934	2	zeps

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.140	1276364.3
2	DLD Change Limit	29872	358	1.093	27330.3
3	Display Results	358	358	0.096	3729.2
	(SQL Overall)	178691	358	1.329	134455.2