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

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

352 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
efs	6	68	2960	(None)
eds	4	66	3892	1	eds
ef	5	73	4536	1	ef_
eff	9	61	2862	1	eff
effs	10	51	1403	1	effs
eft	6	60	3882	1	eft
efts	7	65	1948	1	efts
els	3	76	4572	1	els
ems	5	64	3549	1	ems
ens	3	72	4592	1	ens
ers	3	60	4628	1	ers
es	2	90	4822	1	e_s
ess	3	60	3088	1	ess
fes	6	65	5167	1	fes
ifs	6	71	2424	1	ifs
kefs	11	59	2274	1	kefs
refs	7	57	3224	1	refs
aas	3	109	7539	2	aas
abs	5	93	5607	2	abs
ads	4	97	5573	2	ads
aff	9	55	3761	2	aff
aft	6	68	4901	2	aft
ags	4	75	5166	2	ags
ahs	6	86	4482	2	ahs
ais	3	90	8357	2	ais
alefs	8	73	1966	2	alefs
als	3	66	6302	2	als
arfs	7	60	2996	2	arfs
ars	3	76	7093	2	ars
as	2	110	8307	2	_as
ass	3	78	4406	2	ass
ays	6	70	5029	2	ays
bas	5	86	8175	2	bas
beds	7	59	3778	2	beds
beefs	10	56	1856	2	beefs
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	bes
bets	6	70	5144	2	bets
beys	9	138	2955	2	beys
bis	5	68	6065	2	bis
bos	5	79	6681	2	bos
bus	5	69	5097	2	bus
bys	8	52	2946	2	bys
cees	6	59	4159	2	cees
cels	6	55	3497	2	cels
ceps	8	61	2595	2	ceps
cess	6	53	2605	2	cess
chefs	13	62	1466	2	chefs
cis	5	77	4803	2	cis
clefs	10	66	1624	2	clefs
cos	5	102	7039	2	cos
debs	7	65	3024	2	debs
dees	5	63	5663	2	dees
def	7	65	4672	2	def_
defi	8	63	2149	2	defi
defis	9	67	1750	2	defis
deft	8	55	4022	2	deft
defy	11	49	2126	2	defy
delfs	9	49	1867	2	delfs
dels	5	67	4547	2	dels
dens	5	59	4507	2	dens
devs	8	64	2403	2	devs
dews	8	62	3060	2	dews
deys	8	50	2747	2	deys
difs	8	60	2732	2	difs
dis	4	64	5989	2	dis
dos	4	80	6231	2	dos
ear	3	68	6788	2	ear
ears	4	63	5659	2	ears
ease	4	50	4233	2	ease
east	4	66	5910	2	east
easy	7	62	2449	2	easy
eat	3	69	8905	2	eat
eats	4	70	5487	2	eats
eau	3	74	5094	2	eau
ebb	7	24	1862	2	ebb
ebbs	8	24	1198	2	ebbs
ecu	5	68	2823	2	ecu
ecus	6	54	2146	2	ecus
ed	3	86	4518	2	e_d
edh	7	69	2156	2	edh
edhs	8	62	1210	2	edhs
eek	7	79	3510	2	eek
eel	3	79	4684	2	eel
eels	4	65	3674	2	eels
egg	5	69	1867	2	egg
eggs	6	65	1615	2	eggs
egis	5	65	2065	2	egis
ego	4	67	2605	2	ego
egos	5	58	2165	2	egos
eh	5	83	3996	2	e_h
eke	7	56	3009	2	eke
ekes	8	67	2660	2	ekes
el	2	67	4529	2	e_l
eld	4	67	3379	2	eld
elds	5	63	2485	2	elds
elf	6	61	3852	2	elf
elk	7	67	2612	2	elk
elks	8	58	2003	2	elks
ell	3	67	3568	2	ell
ells	4	64	3135	2	ells
elm	5	75	3174	2	elm
elms	6	73	2270	2	elms
else	4	59	2308	2	else
em	4	94	4515	2	e_m
eme	5	58	3718	2	eme
emes	6	54	3466	2	emes
emu	5	59	2998	2	emu
emus	6	68	2168	2	emus
en	2	80	5239	2	e_n
end	4	68	3435	2	end
ends	5	65	2852	2	ends
eng	4	67	2678	2	eng
engs	5	61	2139	2	engs
eon	3	60	5208	2	eon
eons	4	66	3871	2	eons
epos	6	67	2373	2	epos
er	2	83	4514	2	e_r
era	3	57	4150	2	era
eras	4	54	4150	2	eras
ere	3	63	5277	2	ere
erg	4	55	3107	2	erg
ergs	5	55	2381	2	ergs
ern	3	57	3835	2	ern
erns	4	54	2822	2	erns
eros	4	52	3845	2	eros
err	3	56	2653	2	err
errs	4	56	2253	2	errs
erst	4	74	3643	2	erst
eses	4	53	3610	2	eses
et	2	69	6419	2	e_t
eta	3	58	3419	2	eta
etas	4	64	3227	2	etas
eth	6	66	3098	2	eth
eths	7	66	1952	2	eths
eve	6	63	3116	2	eve
eves	7	62	3046	2	eves
ewe	6	66	3098	2	ewe
ewes	7	63	2870	2	ewes
ex	9	88	3564	2	e_x
exes	11	65	3081	2	exes
eyas	7	64	2743	2	eyas
eye	6	55	3977	2	eye
eyes	7	58	3788	2	eyes
fa	5	101	4845	2	_fa
fas	6	82	6293	2	fas
fe	5	79	4474	2	_fe
fed	7	65	4835	2	fed
feds	8	52	3431	2	feds
fee	6	68	6201	2	fee
fees	7	64	5060	2	fees
feh	9	61	3609	2	feh
fehs	10	65	2238	2	fehs
fem	8	60	4073	2	fem
fems	9	64	2870	2	fems
fen	6	68	5135	2	fen
fens	7	61	3976	2	fens
fer	6	66	4612	2	fer
fess	7	65	2916	2	fess
fest	7	49	4944	2	fest
fet	6	64	7163	2	fet
fets	7	53	4594	2	fets
feu	6	78	4366	2	feu
feus	7	58	3075	2	feus
few	9	54	3696	2	few
fey	9	59	4088	2	fey
fez	15	62	3682	2	fez
fiefs	11	62	1370	2	fiefs
gas	4	88	7025	2	gas
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
gos	4	71	5513	2	gos
has	6	73	7265	2	has
heft	10	67	3629	2	heft
hefts	11	62	1815	2	hefts
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	hes
hets	7	55	4720	2	hets
hews	10	56	3157	2	hews
his	6	63	5950	2	his
hos	6	83	6419	2	hos
ids	4	75	3546	2	ids
if	5	72	3994	2	if_
iff	9	67	3038	2	iff
ins	3	59	4560	2	ins
is	2	70	4821	2	_is
its	3	55	3883	2	its
jees	11	59	3854	2	jees
jefe	14	65	1688	2	jefe
jefes	15	56	1367	2	jefes
jess	11	60	2203	2	jess
jets	11	58	3410	2	jets
jews	14	58	2208	2	jews
jus	10	69	3022	2	jus
kafs	11	64	2374	2	kafs
kas	7	70	5858	2	kas
keas	8	63	3709	2	keas
keefs	12	51	1628	2	keefs
kef	10	56	3966	2	kef_
kegs	9	58	2401	2	kegs
kens	8	54	3523	2	kens
keps	10	60	2730	2	keps
kerfs	12	54	1357	2	kerfs
keys	11	63	2216	2	keys
kiefs	12	61	1220	2	kiefs
kifs	11	60	2350	2	kifs
kis	7	80	5147	2	kis
kos	7	69	4482	2	kos
las	3	72	8147	2	las
leafs	8	57	2118	2	leafs
leas	4	59	5418	2	leas
lees	4	54	5588	2	lees
left	7	63	4048	2	left
lefts	8	65	1781	2	lefts
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	les
less	4	56	3510	2	less
lets	4	71	4794	2	lets
leys	7	64	3018	2	leys
lis	3	71	6227	2	lis
mas	5	81	7581	2	mas
meds	7	57	3536	2	meds
megs	7	55	3063	2	megs
mels	6	59	4153	2	mels
mems	8	59	3150	2	mems
mess	6	59	3243	2	mess
mews	9	66	2933	2	mews
mis	5	81	6261	2	mis
mos	5	70	6712	2	mos
mus	5	59	4675	2	mus
nebs	6	61	2498	2	nebs
negs	5	57	2736	2	negs
neifs	8	56	1304	2	neifs
ness	4	55	2656	2	ness
nets	4	59	4153	2	nets
news	7	61	2737	2	news
nos	3	88	5932	2	nos
nus	3	79	3939	2	nus
oafs	7	64	2526	2	oafs
ods	4	75	4621	2	ods
oes	3	58	6619	2	oes
of	5	82	4777	2	of_
off	9	63	3163	2	off
offs	10	71	1701	2	offs
oft	6	77	4406	2	oft
ohs	6	62	3231	2	ohs
oms	5	63	3751	2	oms
ons	3	61	4851	2	ons
ops	5	66	4125	2	ops
ors	3	57	5011	2	ors
os	2	113	5988	2	_os
pas	5	87	7574	2	pas
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
pelfs	10	50	1629	2	pelfs
pens	6	56	4964	2	pens
peps	8	51	3451	2	peps
pes	5	72	5978	2	pes
pets	6	62	4833	2	pets
pews	9	57	3153	2	pews
pis	5	63	6203	2	pis
pus	5	55	4784	2	pus
qis	12	69	3438	2	qis
ras	3	75	7539	2	ras
rebs	6	57	3356	2	rebs
recs	6	57	3418	2	recs
reds	5	60	4286	2	reds
reefs	8	51	2166	2	reefs
rees	4	53	6419	2	rees
ref	6	60	5329	2	ref_
reft	7	51	4127	2	reft
regs	5	54	3657	2	regs
reifs	8	48	1909	2	reifs
reis	4	53	4323	2	reis
rems	6	62	3772	2	rems
reps	6	59	3795	2	reps
res	3	55	6504	2	res
rets	4	53	5256	2	rets
revs	7	50	2705	2	revs
rifs	7	49	2900	2	rifs
seas	4	57	5527	2	seas
secs	6	50	3389	2	secs
sees	4	53	6105	2	sees
segs	5	49	3388	2	segs
seifs	8	50	1933	2	seifs
seis	4	55	4239	2	seis
selfs	8	52	2024	2	selfs
sels	4	63	4598	2	sels
serfs	8	49	2201	2	serfs
sers	4	57	4665	2	sers
sets	4	55	4950	2	sets
sews	7	58	3602	2	sews
sis	3	73	6054	2	sis
sos	3	77	6160	2	sos
tas	3	84	7710	2	tas
teas	4	58	5149	2	teas
teds	5	49	3257	2	teds
tees	4	53	5358	2	tees
teff	10	60	2376	2	teff
teffs	11	51	1173	2	teffs
tegs	5	60	3149	2	tegs
tels	4	68	4169	2	tels
tens	4	56	4741	2	tens
tets	4	58	4745	2	tets
tews	7	64	3164	2	tews
tis	3	70	5664	2	tis
uns	3	59	3675	2	uns
ups	5	56	2905	2	ups
us	2	69	3743	2	_us
uts	3	55	3437	2	uts
vas	6	77	5577	2	vas
vees	7	54	3943	2	vees
vets	7	68	3509	2	vets
vis	6	67	4761	2	vis
was	6	87	6756	2	was
webs	9	66	2212	2	webs
weds	8	66	2893	2	weds
wees	7	62	4912	2	wees
weft	10	54	3501	2	weft
wefts	11	67	1549	2	wefts
wens	7	63	3793	2	wens
wets	7	59	4029	2	wets
wis	6	65	5233	2	wis
wos	6	69	5353	2	wos
xis	10	69	3533	2	xis
yeas	7	86	3842	2	yeas
yens	7	58	3226	2	yens
yeps	9	59	2440	2	yeps
yes	6	62	5061	2	yes
yews	10	53	2396	2	yews
zas	12	69	4683	2	zas
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 1 second 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	14084	0.063	2836365.1
2	DLD Change Limit	14084	352	0.423	33295.5
3	Display Results	352	352	0.076	4631.6
	(SQL Overall)	178691	352	0.562	317955.5