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

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

274 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
kefs	11	59	2274	(None)
efs	6	68	2960	1	_efs
kafs	11	64	2374	1	kafs
keas	8	63	3709	1	keas
keefs	12	51	1628	1	keefs
kef	10	56	3966	1	kef_
kegs	9	58	2402	1	kegs
kens	8	54	3523	1	kens
keps	10	60	2730	1	keps
kerfs	12	54	1357	1	kerfs
keys	11	63	2216	1	keys
kiefs	12	61	1220	1	kiefs
kifs	11	60	2351	1	kifs
refs	7	57	3224	1	refs
akees	9	61	1924	2	akees
alefs	8	73	1966	2	alefs
arfs	7	60	2996	2	arfs
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	be_s
bets	6	70	5144	2	bets
beys	9	138	2955	2	beys
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
clefs	10	66	1624	2	clefs
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
eds	4	66	3892	2	_eds
eels	4	65	3674	2	eels
ef	5	73	4536	2	_ef_
eff	9	61	2862	2	_eff
effs	10	51	1403	2	effs
eft	6	60	3882	2	_eft
efts	7	65	1948	2	_efts
ekes	8	67	2660	2	ekes
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
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
fiefs	11	62	1370	2	fiefs
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
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	he_s
hets	7	55	4720	2	hets
hews	10	56	3157	2	hews
ifs	6	71	2424	2	_ifs
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
kaas	8	65	3184	2	kaas
kabs	10	71	3084	2	kabs
kaes	8	57	3406	2	kaes
kaf	10	68	4551	2	kaf_
kaifs	12	57	1564	2	kaifs
kas	7	70	5858	2	k_as
kats	8	59	4433	2	kats
kays	11	60	3219	2	kays
kea	7	65	4091	2	ke_a
keck	9	49	2071	2	keck
kecks	10	54	1657	2	kecks
keef	11	58	3000	2	keef
keek	7	56	2497	2	keek
keeks	8	47	1725	2	keeks
keel	8	57	2947	2	keel
keels	9	46	2241	2	keels
keen	8	48	3041	2	keen
keens	9	57	2118	2	keens
keep	10	63	2982	2	keep
keeps	11	60	2028	2	keeps
keet	8	53	4734	2	keet
keets	9	51	2348	2	keets
kefir	12	45	791	2	kefir
kefirs	13	39	665	2	kefirs
keg	8	64	3254	2	ke_g
keir	8	62	1787	2	keir
keirs	9	53	1367	2	keirs
kelp	10	53	2280	2	kelp
kelps	11	51	1642	2	kelps
kelt	8	53	4319	2	kelt
kelts	9	52	2263	2	kelts
kemp	12	64	1876	2	kemp
kemps	13	50	1252	2	kemps
ken	7	63	4398	2	ke_n
kenafs	13	3	711	2	kenafs
keno	8	79	2643	2	keno
kenos	9	52	2062	2	kenos
kent	8	68	4696	2	kent
kep	9	64	3720	2	ke_p
kepi	10	53	1563	2	kepi
kepis	11	53	1336	2	kepis
kept	10	62	3294	2	kept
kerb	10	43	2271	2	kerb
kerbs	11	50	1367	2	kerbs
kerf	11	58	2746	2	kerf
kern	8	53	2621	2	kern
kerns	9	47	1956	2	kerns
keto	8	62	2345	2	keto
kex	14	60	2958	2	ke_x
kexes	16	62	1682	2	kexes
key	10	58	3333	2	ke_y
khafs	15	64	884	2	khafs
khets	12	49	1343	2	khets
khis	11	70	1798	2	khis
kids	9	60	2964	2	kids
kief	11	71	2841	2	kief_
kiers	9	53	2009	2	kiers
kif	10	59	4119	2	kif_
kins	8	57	4791	2	kins
kips	10	64	3052	2	kips
kirs	8	58	3174	2	kirs
kis	7	80	5148	2	k_is
kiss	8	52	2740	2	kiss
kits	8	64	4177	2	kits
knees	9	51	1487	2	knees
koas	8	56	3509	2	koas
kobs	10	58	3108	2	kobs
koels	9	46	1390	2	koels
kois	8	51	2940	2	kois
kops	10	70	3129	2	kops
kors	8	59	3301	2	kors
kos	7	69	4482	2	k_os
koss	8	52	2481	2	koss
kris	8	64	2360	2	kris
kues	8	64	2677	2	kues
kufi	11	9	1065	2	kufi
kufis	12	4	925	2	kufis
kvas	11	70	1594	2	kvas
kyes	11	51	2493	2	kyes
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	le_s
less	4	56	3510	2	less
lets	4	71	4794	2	lets
leys	7	64	3018	2	leys
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
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
oafs	7	64	2526	2	oafs
oes	3	58	6619	2	oe_s
offs	10	71	1701	2	offs
okehs	12	47	746	2	okehs
okes	8	49	3634	2	oke_s
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	pe_s
pets	6	62	4833	2	pets
pews	9	57	3153	2	pews
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	re_s
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
skees	9	50	2312	2	skees
skegs	10	50	1123	2	skegs
skeps	11	56	1425	2	skeps
skews	12	54	1380	2	skews
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	4746	2	tets
tews	7	64	3164	2	tews
ukes	8	61	2281	2	uke_s
vees	7	54	3943	2	vees
vets	7	68	3509	2	vets
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
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
yews	10	53	2396	2	yews
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.266	671770.7
2	DLD Change Limit	29872	274	0.733	40753.1
3	Display Results	274	274	0.063	4349.2
	(SQL Overall)	178691	274	1.062	168258.9