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

Here are the results of your fuzzy-string dictionary search for “secs” 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
secs	6	50	3389	(None)
pecs	8	46	3410	1	pecs
recs	6	57	3418	1	recs
sacs	6	57	3907	1	sacs
seas	4	57	5527	1	seas
sec	5	59	4532	1	sec_
sect	6	74	4362	1	sect
sects	7	56	2289	1	sects
sees	4	53	6105	1	sees
segs	5	49	3388	1	segs
seis	4	55	4239	1	seis
sels	4	63	4598	1	sels
sers	4	57	4665	1	sers
sets	4	55	4950	1	sets
sews	7	58	3602	1	sews
sics	6	52	3409	1	sics
specs	9	69	1667	1	specs
aces	6	76	4509	2	aces
alecs	7	66	2073	2	alecs
arcs	6	78	3478	2	arcs
beck	12	62	2657	2	beck
becks	13	55	2201	2	becks
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
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
cosecs	10	50	1521	2	cosecs
cusecs	10	50	915	2	cusecs
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
ecu	5	68	2823	2	_ecu
ecus	6	54	2146	2	_ecus
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
eses	4	53	3610	2	eses
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	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
geck	11	57	2199	2	geck
gecks	12	51	1709	2	gecks
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
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
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	3709	2	keas
keck	9	49	2071	2	keck
kecks	10	54	1657	2	kecks
kefs	11	59	2274	2	kefs
kegs	9	58	2402	2	kegs
kens	8	54	3523	2	kens
keps	10	60	2730	2	keps
keys	11	63	2216	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	3536	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	3515	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
oses	4	66	4151	2	ose_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	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
pews	9	57	3153	2	pews
pics	8	56	3391	2	pics
rebs	6	57	3356	2	rebs
rec	5	56	4546	2	rec_
reck	10	61	3056	2	reck
recks	11	56	2513	2	recks
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
rocs	6	55	3366	2	rocs
sabs	6	66	4374	2	sabs
sac	5	74	5286	2	sac_
sack	10	53	3731	2	sack
sacks	11	42	2887	2	sacks
sags	5	59	4840	2	sags
sals	4	68	5167	2	sals
sans	4	51	5336	2	sans
saps	6	53	4637	2	saps
sass	4	50	3562	2	sass
saws	7	58	3948	2	saws
says	7	59	4210	2	says
sea	3	61	6129	2	se_a
seal	4	56	5437	2	seal
seals	5	48	3969	2	seals
seam	6	66	4597	2	seam
seams	7	57	3166	2	seams
sear	4	73	5384	2	sear
sears	5	47	4491	2	sears
seat	4	75	7556	2	seat
seats	5	48	4434	2	seats
secco	9	3	1242	2	secco
seccos	10	3	992	2	seccos
see	3	57	7226	2	se_e
seed	5	55	4948	2	seed
seeds	6	43	3006	2	seeds
seek	8	59	3548	2	seek
seeks	9	47	2464	2	seeks
seel	4	50	4298	2	seel
seels	5	56	3282	2	seels
seem	6	54	3856	2	seem
seems	7	55	2502	2	seems
seen	4	69	4312	2	seen
seep	6	65	4034	2	seep
seeps	7	48	2875	2	seeps
seer	4	55	4704	2	seer
seers	5	51	3638	2	seers
seg	4	55	4488	2	se_g
sego	5	65	2518	2	sego
segos	6	49	1948	2	segos
sei	3	60	4893	2	se_i
seif	7	56	3873	2	seif
seifs	8	50	1933	2	seifs
seise	5	47	2785	2	seise
seism	7	50	1902	2	seism
sel	3	82	5332	2	se_l
self	7	51	3829	2	self
selfs	8	52	2024	2	selfs
sell	4	58	4061	2	sell
sells	5	51	3443	2	sells
seme	6	58	3665	2	seme
semes	7	57	3158	2	semes
semi	6	51	2722	2	semi
semis	7	46	2353	2	semis
sen	3	60	5852	2	se_n
send	5	52	3729	2	send
sends	6	55	2824	2	sends
sene	4	68	4805	2	sene
sensa	5	41	1747	2	sensa
sense	5	55	2682	2	sense
sent	4	69	6301	2	sent
sept	6	58	4436	2	sept
septs	7	54	2060	2	septs
ser	3	67	5240	2	se_r
sera	4	61	4139	2	sera
seracs	8	44	1857	2	seracs
sere	4	61	5347	2	sere
seres	5	54	4889	2	seres
serf	7	63	4011	2	serf
serfs	8	49	2201	2	serfs
set	3	66	8125	2	se_t
seta	4	56	3731	2	seta
sett	4	59	4905	2	sett
setts	5	51	2432	2	setts
sew	6	62	4726	2	se_w
sewn	7	61	2433	2	sewn
sex	10	70	4322	2	se_x
sexes	12	61	2622	2	sexes
sext	11	73	3809	2	sext
sexts	12	51	1838	2	sexts
sexy	14	64	1802	2	sexy
sheas	8	63	3179	2	sheas
sheds	9	61	2270	2	sheds
shes	7	57	3435	2	shes
shews	11	59	2471	2	shews
sibs	6	59	3354	2	sibs
sic	5	58	4787	2	sic_
sice	6	55	4559	2	sice
sices	7	56	3727	2	sices
sick	10	64	3557	2	sick
sicks	11	51	2762	2	sicks
sims	6	57	3717	2	sims
sins	4	67	5527	2	sins
sips	6	57	4010	2	sips
sirs	4	43	3833	2	sirs
sis	3	73	6054	2	s_is
sits	4	50	5020	2	sits
skas	8	53	2571	2	skas
skees	9	50	2312	2	skees
skegs	10	50	1123	2	skegs
skeps	11	56	1425	2	skeps
skews	12	54	1380	2	skews
skis	8	48	2529	2	skis
sleds	6	44	1885	2	sleds
slews	8	62	2035	2	slews
smews	10	46	1229	2	smews
sneck	11	47	1366	2	sneck
snecks	12	44	1003	2	snecks
sneds	6	57	1535	2	sneds
sobs	6	49	4175	2	sobs
soca	6	63	3005	2	soca
socas	7	40	2618	2	socas
sock	10	52	3321	2	sock
socks	11	49	2608	2	socks
sods	5	49	4021	2	sods
sols	4	54	4816	2	sols
soms	6	62	3937	2	soms
sons	4	60	4955	2	sons
sops	6	52	4456	2	sops
sos	3	77	6160	2	s_os
sots	4	55	5245	2	sots
sous	4	69	4721	2	sous
sows	7	53	4249	2	sows
soys	7	52	3393	2	soys
spas	6	70	3672	2	spas
spec	8	58	2197	2	spec_
speck	13	51	1565	2	speck
specks	14	43	1270	2	specks
spews	10	50	1592	2	spews
spics	9	41	2324	2	spics
sris	4	54	3415	2	sris
stems	7	52	1995	2	stems
steps	7	66	1988	2	steps
stets	5	54	2391	2	stets
stews	8	55	1914	2	stews
subs	6	60	3712	2	subs
such	9	64	2481	2	such
suck	10	61	3173	2	suck
sucks	11	45	2307	2	sucks
suds	5	61	3529	2	suds
suers	5	51	2848	2	suers
sues	4	62	4765	2	sues
suets	5	51	2610	2	suets
suks	8	59	2712	2	suks
sums	6	58	3758	2	sums
suns	4	58	4190	2	suns
sups	6	48	3443	2	sups
suqs	13	43	1965	2	suqs
suss	4	52	2930	2	suss
syce	9	58	2028	2	syce
syces	10	64	1646	2	syces
syncs	10	46	1017	2	syncs
teas	4	58	5149	2	teas
tech	9	59	2544	2	tech
techs	10	69	1583	2	techs
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	4746	2	tets
tews	7	64	3164	2	tews
tics	6	57	2963	2	tics
users	5	58	1757	2	users
uses	4	49	3111	2	use_s
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	2893	2	weds
wees	7	62	4912	2	wees
wens	7	63	3793	2	wens
wets	7	59	4029	2	wets
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	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.280	638182.1
2	DLD Change Limit	29872	352	0.860	34734.9
3	Display Results	352	352	0.080	4400.0
	(SQL Overall)	178691	352	1.220	146468.0