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

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

347 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
refs	7	57	3224	(None)
efs	6	68	2960	1	_efs
kefs	11	59	2274	1	kefs
rebs	6	57	3356	1	rebs
recs	6	57	3418	1	recs
reds	5	60	4286	1	reds
reefs	8	51	2166	1	reefs
rees	4	53	6419	1	rees
ref	6	60	5329	1	ref_
reft	7	51	4127	1	reft
regs	5	54	3657	1	regs
reifs	8	48	1909	1	reifs
reis	4	53	4323	1	reis
rems	6	62	3772	1	rems
reps	6	59	3795	1	reps
res	3	55	6504	1	re_s
rets	4	53	5256	1	rets
revs	7	50	2705	1	revs
rifs	7	49	2900	1	rifs
alefs	8	73	1966	2	alefs
areas	5	59	3577	2	areas
ares	4	58	7102	2	are_s
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
brees	7	56	3255	2	brees
brens	7	58	2336	2	brens
brews	10	56	1707	2	brews
briefs	11	55	1007	2	briefs
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
creds	8	54	1877	2	creds
cress	7	50	2283	2	cress
crews	10	59	1749	2	crews
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
drees	6	56	2852	2	drees
dregs	7	61	1486	2	dregs
dreks	10	57	1474	2	dreks
dress	6	53	1983	2	dress
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
els	3	76	4572	2	_els
ems	5	64	3549	2	_ems
ens	3	72	4592	2	_ens
eras	4	54	4150	2	eras
ergs	5	55	2381	2	ergs
erns	4	54	2822	2	erns
eros	4	52	3845	2	eros
errs	4	56	2253	2	errs
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
frees	8	61	3139	2	frees
frets	8	55	2340	2	frets
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
grees	6	51	3247	2	grees
greys	9	66	1485	2	greys
griefs	10	41	872	2	griefs
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
ires	4	56	3928	2	ire_s
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
kafs	11	64	2374	2	kafs
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
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
ores	4	60	5668	2	ore_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
prees	7	59	3717	2	prees
preps	9	62	2069	2	preps
press	7	54	2595	2	press
preys	10	57	1778	2	preys
profs	10	51	2089	2	profs
rads	5	60	4660	2	rads
raff	10	49	3304	2	raff
raffs	11	50	1752	2	raffs
raft	7	62	4591	2	raft
rafts	8	78	2063	2	rafts
rags	5	54	4837	2	rags
rais	4	52	5262	2	rais
rams	6	59	5077	2	rams
raps	6	62	4773	2	raps
ras	3	75	7539	2	r_as
rats	4	62	6037	2	rats
raws	7	52	3821	2	raws
rays	7	76	4235	2	rays
re	2	61	5374	2	re__
read	5	59	4253	2	read
reads	6	48	3527	2	reads
real	4	57	5029	2	real
reals	5	50	3865	2	reals
ream	6	58	4161	2	ream
reams	7	57	2962	2	reams
reap	6	59	3474	2	reap
reaps	7	56	2619	2	reaps
rear	4	56	4455	2	rear
rears	5	47	3965	2	rears
reb	5	58	4496	2	re_b
rebus	7	57	2111	2	rebus
rec	5	56	4546	2	re_c
reck	10	61	3056	2	reck
recks	11	56	2513	2	recks
red	4	67	5580	2	re_d
redd	6	63	2317	2	redd
redds	7	46	1783	2	redds
rede	5	50	3766	2	rede
redes	6	51	3912	2	redes
redo	5	60	2936	2	redo
redos	6	51	2676	2	redos
ree	3	79	7407	2	re_e
reed	5	55	4962	2	reed
reeds	6	54	3090	2	reeds
reef	7	49	3821	2	reef
reefy	11	42	1770	2	reefy
reek	8	52	3252	2	reek
reeks	9	41	2403	2	reeks
reel	4	52	4053	2	reel
reels	5	53	3326	2	reels
reest	5	49	3809	2	reest
refed	9	39	2192	2	refed
refel	8	49	2081	2	refel
refels	9	46	1805	2	refels
refer	8	48	2214	2	refer
refers	9	39	2108	2	refers
refit	8	42	3006	2	refit
refits	9	40	1765	2	refits
refix	15	52	1248	2	refix
refly	11	39	1456	2	refly
refry	11	44	1246	2	refry
refuse	9	48	1751	2	refuse
reg	4	61	4649	2	re_g
reges	6	56	2878	2	reges
rei	3	56	4725	2	re_i
reif	7	69	3764	2	reif
reify	11	48	1497	2	reify
rein	4	60	4089	2	rein
reins	5	62	3456	2	reins
rely	7	54	2895	2	rely
rem	5	61	5004	2	re_m
rend	5	61	3657	2	rend
rends	6	51	2995	2	rends
rent	4	66	6124	2	rent
rents	5	59	3518	2	rents
rep	5	58	4780	2	re_p
repo	6	60	2754	2	repo
repos	7	47	2579	2	repos
repp	8	54	1874	2	repp
repps	9	51	1434	2	repps
resh	7	65	2345	2	resh
rest	4	64	5984	2	rest
rests	5	49	3587	2	rests
ret	3	59	8283	2	re_t
rete	4	49	4413	2	rete
reuse	5	60	2536	2	reuse
rev	6	53	3662	2	re_v
rex	10	57	4099	2	re_x
rexes	12	45	2695	2	rexes
rheas	8	48	1695	2	rheas
rhos	7	63	1906	2	rhos
rhus	7	51	1405	2	rhus
rias	4	55	4059	2	rias
ribs	6	58	3301	2	ribs
rids	5	65	3954	2	rids
riels	5	51	2133	2	riels
rif	6	59	5155	2	rif_
rife	7	46	3232	2	rife
riff	10	44	3009	2	riff
riffs	11	51	1461	2	riffs
rift	7	56	4233	2	rift
rifts	8	57	1864	2	rifts
rigs	5	51	3759	2	rigs
rims	6	59	3630	2	rims
rins	4	61	5319	2	rins
rips	6	62	3743	2	rips
robs	6	58	3787	2	robs
rocs	6	55	3366	2	rocs
rods	5	64	4206	2	rods
roes	4	59	5413	2	roes
rolfs	8	48	1712	2	rolfs
roms	6	70	3896	2	roms
roofs	8	53	2115	2	roofs
rots	4	64	5409	2	rots
rows	7	59	4175	2	rows
rubs	6	61	3349	2	rubs
ruers	5	150	1941	2	ruers
rues	4	60	4448	2	rues
ruff	10	51	2765	2	ruff
ruffs	11	45	1674	2	ruffs
rugs	5	60	3368	2	rugs
rums	6	48	3347	2	rums
runs	4	64	3807	2	runs
ruts	4	45	4149	2	ruts
ryas	7	72	2461	2	ryas
ryes	7	55	2935	2	ryes
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
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
trees	5	58	3576	2	trees
tref	7	70	3099	2	tref_
treks	9	60	1685	2	treks
tres	4	65	4290	2	tre_s
tress	5	54	2316	2	tress
trets	5	59	2802	2	trets
trews	8	61	1889	2	trews
treys	8	50	1821	2	treys
ureas	5	58	2601	2	ureas
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
wrens	8	50	1624	2	wrens
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 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	29872	0.080	2233637.5
2	DLD Change Limit	29872	347	0.796	37527.6
3	Display Results	347	347	0.076	4565.8
	(SQL Overall)	178691	347	0.952	187700.6