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

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

377 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
recs	6	57	3418	(None)
pecs	8	46	3410	1	pecs
rebs	6	57	3356	1	rebs
rec	5	56	4546	1	rec_
reck	10	61	3056	1	reck
recks	11	56	2513	1	recks
reds	5	60	4287	1	reds
rees	4	53	6419	1	rees
refs	7	57	3224	1	refs
regs	5	54	3657	1	regs
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
rocs	6	55	3366	1	rocs
secs	6	50	3389	1	secs
aces	6	76	4509	2	aces
alecs	7	66	2073	2	alecs
arcs	6	78	3478	2	arcs
areas	5	59	3579	2	areas
areca	7	56	1863	2	areca
arecas	8	48	1745	2	arecas
ares	4	58	7102	2	are_s
beck	12	62	2657	2	beck
becks	13	55	2201	2	becks
beds	7	59	3779	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
brees	7	56	3255	2	brees
brens	7	58	2336	2	brens
brews	10	56	1707	2	brews
ceca	8	48	2078	2	ceca
cees	6	59	4159	2	cees
cels	6	55	3497	2	cels
ceps	8	61	2595	2	ceps
cess	6	53	2605	2	cess
creds	8	54	1877	2	creds
cress	7	50	2283	2	cress
crews	10	59	1750	2	crews
crocs	9	57	2243	2	crocs
debs	7	65	3024	2	debs
deck	11	58	2775	2	deck
decks	12	48	2219	2	decks
deco	7	61	2597	2	deco
decos	8	55	2212	2	decos
dees	5	63	5663	2	dees
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
docs	7	56	3115	2	docs
dreck	12	48	1280	2	dreck
drecks	13	45	920	2	drecks
drees	6	56	2852	2	drees
dregs	7	61	1486	2	dregs
dreks	10	57	1475	2	dreks
dress	6	53	1983	2	dress
ecu	5	68	2823	2	_ecu
ecus	6	54	2146	2	_ecus
eds	4	66	3893	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
eras	4	54	4150	2	eras
erect	7	41	2933	2	erect
erects	8	41	1618	2	erects
ergs	5	55	2381	2	ergs
erns	4	54	2823	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
execs	14	53	972	2	execs
feces	10	56	2536	2	feces
feck	13	49	2343	2	feck
fecks	14	54	1785	2	fecks
feds	8	52	3432	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
frees	8	61	3139	2	frees
frets	8	55	2340	2	frets
geck	11	57	2199	2	geck
gecks	12	51	1709	2	gecks
geds	6	67	3082	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
heck	13	58	2649	2	heck
hecks	14	52	2065	2	hecks
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
ices	6	61	2964	2	ices
ires	4	56	3928	2	ire_s
jees	11	59	3854	2	jees
jess	11	60	2203	2	jess
jets	11	58	3410	2	jets
jews	14	58	2208	2	jews
keas	8	63	3710	2	keas
keck	9	49	2072	2	keck
kecks	10	54	1657	2	kecks
kefs	11	59	2275	2	kefs
kegs	9	58	2403	2	kegs
kens	8	54	3525	2	kens
keps	10	60	2731	2	keps
keys	11	63	2217	2	keys
lacs	6	69	4248	2	lacs
leas	4	59	5418	2	leas
lech	9	68	2544	2	lech
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
leys	7	64	3018	2	leys
macs	8	67	4251	2	macs
meds	7	57	3537	2	meds
megs	7	55	3063	2	megs
mels	6	59	4153	2	mels
mems	8	59	3150	2	mems
mercs	9	60	2045	2	mercs
mess	6	59	3243	2	mess
mews	9	66	2933	2	mews
mics	8	74	3516	2	mics
mocs	8	58	3490	2	mocs
mycs	11	53	1429	2	mycs
nebs	6	61	2498	2	nebs
neck	10	54	2366	2	neck
necks	11	51	1933	2	necks
negs	5	57	2736	2	negs
ness	4	55	2656	2	ness
nets	4	59	4153	2	nets
news	7	61	2737	2	news
oes	3	58	6619	2	oe_s
orcs	6	70	2543	2	orcs
ores	4	60	5668	2	ore_s
pacs	8	58	4218	2	pacs
peas	6	57	5506	2	peas
pec	7	67	4441	2	pec_
pech	11	61	2545	2	pech
pechs	12	55	1620	2	pechs
peck	12	57	3068	2	peck
pecks	13	57	2443	2	pecks
peds	7	58	3525	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
pews	9	57	3153	2	pews
pics	8	56	3392	2	pics
precis	10	34	1670	2	precis
prees	7	59	3717	2	prees
preps	9	62	2069	2	preps
press	7	54	2595	2	press
preys	10	57	1778	2	preys
race	6	67	4626	2	race
races	7	49	4324	2	races
rack	10	62	3488	2	rack
racks	11	50	2885	2	racks
racy	9	58	2568	2	racy
rads	5	60	4661	2	rads
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__
reach	10	51	2388	2	reach
react	7	46	3433	2	react
reacts	8	36	1660	2	reacts
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
rebecs	10	39	1367	2	rebecs
rebus	7	57	2111	2	rebus
recap	9	57	1802	2	recap
recaps	10	36	1573	2	recaps
recast	8	34	2277	2	recast
recce	9	5	1456	2	recce
recces	10	6	1491	2	recces
recess	8	3	1426	2	recess
recit	7	52	3510	2	recit
recits	8	36	2136	2	recits
recon	7	56	2424	2	recon
recons	8	49	2299	2	recons
recta	7	42	2026	2	recta
recti	7	36	1962	2	recti
recto	7	45	2080	2	recto
rectos	8	57	1879	2	rectos
rectus	8	33	1463	2	rectus
recur	7	41	1684	2	recur
recurs	8	33	1580	2	recurs
recuse	8	55	1916	2	recuse
recut	7	47	2924	2	recut
recuts	8	38	1737	2	recuts
red	4	67	5581	2	re_d
redd	6	63	2318	2	redd
redds	7	46	1783	2	redds
rede	5	50	3768	2	rede
redes	6	51	3913	2	redes
redo	5	60	2937	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
reefs	8	51	2166	2	reefs
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
ref	6	60	5329	2	re_f
reft	7	51	4127	2	reft
reg	4	61	4649	2	re_g
reges	6	56	2879	2	reges
rei	3	56	4725	2	re_i
reif	7	69	3765	2	reif
reifs	8	48	1909	2	reifs
rein	4	60	4089	2	rein
reins	5	62	3456	2	reins
relics	8	45	1790	2	relics
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
retch	10	48	1830	2	retch
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	4060	2	rias
ribs	6	58	3303	2	ribs
rice	6	49	4292	2	rice
rices	7	55	3615	2	rices
rich	9	70	2555	2	rich
rick	10	73	3466	2	rick
ricks	11	51	2613	2	ricks
rids	5	65	3956	2	rids
riels	5	51	2133	2	riels
rifs	7	49	2901	2	rifs
rigs	5	51	3760	2	rigs
rims	6	59	3631	2	rims
rins	4	61	5320	2	rins
rips	6	62	3744	2	rips
robs	6	58	3787	2	robs
roc	5	202	4325	2	roc_
rock	10	57	3518	2	rock
rocks	11	46	2641	2	rocks
rods	5	64	4207	2	rods
roes	4	59	5414	2	roes
roms	6	70	3896	2	roms
rots	4	64	5409	2	rots
rows	7	59	4175	2	rows
rubs	6	61	3349	2	rubs
ruck	10	47	2833	2	ruck
rucks	11	44	2205	2	rucks
ruers	5	150	1941	2	ruers
rues	4	60	4448	2	rues
rugs	5	60	3368	2	rugs
rums	6	48	3347	2	rums
runs	4	64	3808	2	runs
ruts	4	45	4149	2	ruts
ryas	7	72	2461	2	ryas
ryes	7	55	2935	2	ryes
sacs	6	57	3907	2	sacs
seas	4	57	5527	2	seas
sec	5	59	4532	2	sec_
sect	6	74	4362	2	sect
sects	7	56	2289	2	sects
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
sews	7	58	3602	2	sews
sics	6	52	3410	2	sics
specs	9	69	1667	2	specs
teas	4	58	5149	2	teas
tech	9	59	2544	2	tech
techs	10	69	1583	2	techs
teds	5	49	3258	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	4746	2	tets
tews	7	64	3164	2	tews
tics	6	57	2964	2	tics
trees	5	58	3576	2	trees
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
vacs	9	62	2620	2	vacs
vees	7	54	3943	2	vees
vets	7	68	3509	2	vets
webs	9	66	2212	2	webs
weds	8	66	2894	2	weds
wees	7	62	4912	2	wees
wens	7	63	3793	2	wens
wets	7	59	4029	2	wets
wreck	14	46	1104	2	wreck
wrecks	15	41	888	2	wrecks
wrens	8	50	1624	2	wrens
yeas	7	86	3842	2	yeas
yech	12	72	2053	2	yech
yechs	13	61	1258	2	yechs
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	2181	2	zeds
zees	13	63	3189	2	zees
zeks	17	58	1506	2	zeks
zeps	15	60	1934	2	zeps

Search took 4 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.310	576422.6
2	DLD Change Limit	29872	377	2.673	11175.5
3	Display Results	377	377	0.110	3427.3
	(SQL Overall)	178691	377	3.093	57772.7