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

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

301 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
erns	4	54	2823	(None)
earns	5	59	2756	1	earns
ens	3	72	4592	1	e_ns
eons	4	66	3871	1	eons
eras	4	54	4150	1	eras
ergs	5	55	2381	1	ergs
ern	3	57	3836	1	ern_
erne	4	67	2743	1	erne
ernes	5	52	2481	1	ernes
eros	4	52	3845	1	eros
errs	4	56	2253	1	errs
ers	3	60	4628	1	er_s
ferns	8	52	2008	1	ferns
herns	8	48	2558	1	herns
kerns	9	47	1956	1	kerns
terns	5	52	2687	1	terns
urns	4	63	2390	1	urns
aeons	5	76	2465	2	aeons
ains	4	61	5888	2	ains
airns	5	55	2103	2	airns
arbs	6	68	3473	2	arbs
arcs	6	78	3478	2	arcs
ares	4	58	7102	2	ares
arfs	7	60	2996	2	arfs
arks	8	59	3687	2	arks
arms	6	61	3749	2	arms
ars	3	76	7093	2	ar_s
arts	4	96	5026	2	arts
awns	7	53	2443	2	awns
bans	6	65	5514	2	bans
barns	7	63	3514	2	barns
beans	7	57	3469	2	beans
bens	6	59	4570	2	bens
bergs	8	47	1804	2	bergs
berks	11	54	2312	2	berks
berms	9	53	2366	2	berms
bins	6	65	4825	2	bins
brans	7	54	3743	2	brans
bras	6	57	4645	2	bras
brens	7	58	2336	2	brens
brins	7	55	3397	2	brins
bris	6	55	3961	2	bris
bros	6	56	3566	2	bros
buns	6	62	4372	2	buns
burns	7	49	2678	2	burns
cans	6	50	5085	2	cans
carns	7	59	3756	2	carns
ceres	7	55	4001	2	ceres
ceros	7	47	2607	2	ceros
cons	6	60	5769	2	cons
corns	7	60	3476	2	corns
cris	6	62	3343	2	cris
crus	6	58	2848	2	crus
curns	7	49	2428	2	curns
dans	5	67	4815	2	dans
darns	6	69	2789	2	darns
deans	6	61	3139	2	deans
dens	5	59	4507	2	dens
derms	8	50	2289	2	derms
dins	5	66	5204	2	dins
dons	5	60	4870	2	dons
drys	8	63	1480	2	drys
duns	5	51	4043	2	duns
durns	6	48	1987	2	durns
earls	5	61	2751	2	earls
earn	4	67	3755	2	earn_
ears	4	63	5659	2	ears
eats	4	70	5487	2	eats
ebbs	8	24	1199	2	ebbs
ebons	7	43	1609	2	ebons
ecrus	7	51	1386	2	ecrus
ecus	6	54	2146	2	ecus
edhs	8	62	1210	2	edhs
eds	4	66	3892	2	e_ds
eels	4	65	3674	2	eels
effs	10	51	1403	2	effs
efs	6	68	2960	2	e_fs
efts	7	65	1948	2	efts
eggs	6	65	1615	2	eggs
egis	5	65	2065	2	egis
egos	5	58	2165	2	egos
ekes	8	67	2660	2	ekes
elans	5	55	2775	2	elans
elds	5	63	2485	2	elds
elks	8	58	2003	2	elks
ells	4	64	3135	2	ells
elms	6	73	2270	2	elms
els	3	76	4572	2	e_ls
emes	6	54	3466	2	emes
ems	5	64	3549	2	e_ms
emus	6	68	2168	2	emus
en	2	80	5239	2	e_n_
end	4	68	3435	2	e_nd
ends	5	65	2852	2	ends
eng	4	67	2678	2	e_ng
engs	5	61	2139	2	engs
eon	3	60	5208	2	eon_
epos	6	67	2373	2	epos
er	2	83	4514	2	er__
era	3	57	4150	2	er_a
erase	5	49	2549	2	erase
ere	3	63	5277	2	er_e
erg	4	55	3107	2	er_g
ergo	5	64	2015	2	ergo
erose	5	57	2728	2	erose
err	3	56	2653	2	er_r
erses	5	58	2680	2	erses
erst	4	74	3643	2	erst
es	2	90	4822	2	e__s
eses	4	53	3610	2	eses
esne	4	70	1879	2	esne
esnes	5	48	1736	2	esnes
ess	3	60	3088	2	e_ss
etas	4	64	3227	2	etas
eths	7	66	1952	2	eths
etna	4	64	1526	2	etna
etnas	5	47	1393	2	etnas
euros	5	49	2024	2	euros
evens	8	48	1710	2	evens
eves	7	62	3046	2	eves
ewes	7	63	2870	2	ewes
exes	11	65	3081	2	exes
exons	12	58	1334	2	exons
eyas	7	64	2743	2	eyas
eyes	7	58	3788	2	eyes
eyne	7	63	2246	2	eyne
eyras	8	47	1592	2	eyras
eyres	8	49	2177	2	eyres
fans	7	62	4737	2	fans
fens	7	61	3976	2	fens
feres	8	60	3818	2	feres
fern	7	61	2932	2	fern_
ferny	11	58	1618	2	ferny
fins	7	58	4909	2	fins
firns	8	60	1854	2	firns
fons	7	69	4389	2	fons
frons	8	61	2404	2	frons
funs	7	52	3573	2	funs
gens	5	57	4007	2	gens
germs	8	51	1887	2	germs
gins	5	55	4395	2	gins
girns	6	45	1680	2	girns
grans	6	48	3254	2	grans
grins	6	54	2722	2	grins
guns	5	55	3348	2	guns
hens	7	56	4257	2	hens
herbs	10	55	2050	2	herbs
herds	9	64	2468	2	herds
heres	8	62	4590	2	heres
herls	8	52	2643	2	herls
herms	10	56	2643	2	herms
hern	7	61	3489	2	hern_
herons	9	48	2054	2	herons
heros	8	49	3086	2	heros
hers	7	58	4487	2	her_s
hins	7	64	4799	2	hins
hons	7	73	5078	2	hons
horns	8	61	2533	2	horns
huns	7	61	3693	2	huns
inns	4	69	2093	2	inns
ins	3	59	4560	2	_ins
ions	4	67	3785	2	ions
ires	4	56	3928	2	ires
iris	4	57	3255	2	iris
irks	8	62	2013	2	irks
irons	5	53	2413	2	irons
jeans	12	60	2211	2	jeans
jerks	16	65	1489	2	jerks
jins	11	56	3501	2	jins
karns	9	66	2414	2	karns
keens	9	57	2118	2	keens
kens	8	54	3523	2	kens
kerbs	11	50	1367	2	kerbs
kerfs	12	54	1357	2	kerfs
kern	8	53	2621	2	kern_
kerne	9	47	1822	2	kerne
kernes	10	47	1753	2	kernes
kins	8	57	4791	2	kins
kirns	9	53	1545	2	kirns
kris	8	64	2360	2	kris
leans	5	55	3625	2	leans
learns	6	55	1374	2	learns
lens	4	61	4649	2	lens
lins	4	70	5905	2	lins
mans	6	63	5455	2	mans
means	7	58	3123	2	means
mercs	9	60	2045	2	mercs
meres	7	51	4357	2	meres
merks	11	47	2240	2	merks
merls	7	74	2390	2	merls
mons	6	81	5226	2	mons
morns	7	55	2744	2	morns
muns	6	55	3592	2	muns
nans	4	61	3940	2	nans
neons	5	58	1868	2	neons
nerds	6	57	1925	2	nerds
nerts	5	59	2498	2	nerts
nuns	4	52	2823	2	nuns
ons	3	61	4851	2	_ons
orbs	6	66	2625	2	orbs
orcs	6	70	2543	2	orcs
ores	4	60	5668	2	ores
ornis	5	46	1677	2	ornis
ors	3	57	5011	2	or_s
orts	4	65	3833	2	orts
owns	7	68	1958	2	owns
pans	6	58	5573	2	pans
peans	7	54	3764	2	peans
peens	7	64	2819	2	peens
peins	7	61	2806	2	peins
pens	6	56	4964	2	pens
peons	7	53	2718	2	peons
peres	7	62	4664	2	peres
peris	7	55	3707	2	peris
perks	11	53	2580	2	perks
perms	9	55	2451	2	perms
perps	9	55	2148	2	perps
pervs	10	51	1737	2	pervs
pins	6	55	5845	2	pins
pirns	7	60	2009	2	pirns
pons	6	58	5060	2	pons
porns	7	55	2734	2	porns
pros	6	57	4278	2	pros
puns	6	66	4148	2	puns
querns	15	30	794	2	querns
ras	3	75	7539	2	_ras
rebs	6	57	3356	2	rebs
recs	6	57	3418	2	recs
reds	5	60	4286	2	reds
rees	4	53	6419	2	rees
refs	7	57	3224	2	refs
regs	5	54	3657	2	regs
reins	5	62	3456	2	reins
reis	4	53	4323	2	reis
rems	6	62	3772	2	rems
rend	5	61	3657	2	rend
rends	6	51	2995	2	rends
rent	4	66	6124	2	rent
rents	5	59	3518	2	rents
reps	6	59	3795	2	reps
reruns	6	64	1374	2	reruns
res	3	55	6504	2	_res
rets	4	53	5256	2	rets
revs	7	50	2705	2	revs
rins	4	61	5319	2	rins
runs	4	64	3808	2	runs
sans	4	51	5336	2	sans
seres	5	54	4889	2	seres
serfs	8	49	2201	2	serfs
serins	6	40	2967	2	serins
sers	4	57	4665	2	ser_s
sins	4	67	5527	2	sins
sons	4	60	4955	2	sons
sorns	5	50	2842	2	sorns
sris	4	54	3415	2	sris
sterns	6	46	1676	2	sterns
suns	4	58	4190	2	suns
tans	4	61	5483	2	tans
tarns	5	64	3395	2	tarns
teens	5	62	2748	2	teens
tens	4	56	4741	2	tens
terms	7	55	2347	2	terms
tern	4	61	3480	2	tern_
terne	5	64	2615	2	terne
ternes	6	54	2290	2	ternes
tins	4	52	5130	2	tins
tons	4	65	5305	2	tons
trans	5	49	3304	2	trans
tres	4	65	4290	2	tres
tuns	4	51	3866	2	tuns
turns	5	56	2324	2	turns
uns	3	59	3676	2	_uns
urbs	6	59	2206	2	urbs
urds	5	59	2243	2	urds
urn	3	57	3147	2	urn_
urps	6	69	2048	2	urps
urus	4	64	2614	2	urus
vans	7	62	3673	2	vans
veins	8	46	2049	2	veins
verbs	10	46	1439	2	verbs
verts	8	57	2473	2	verts
wans	7	64	5227	2	wans
warns	8	72	3100	2	warns
weans	8	53	2674	2	weans
weens	8	52	2405	2	weens
wens	7	63	3793	2	wens
wins	7	59	4917	2	wins
wons	7	49	4204	2	wons
wrens	8	50	1624	2	wrens
wyns	10	57	1703	2	wyns
xerus	12	3	1333	2	xerus
yarns	8	56	2179	2	yarns
yeans	8	66	2488	2	yeans
yearns	9	50	954	2	yearns
yens	7	58	3226	2	yens
yerks	12	54	1656	2	yerks
yins	7	53	3512	2	yins
zeins	14	47	1539	2	zeins
zerks	18	51	1382	2	zerks
zeros	14	49	1811	2	zeros
zins	13	57	3500	2	zins

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.296	603685.8
2	DLD Change Limit	29872	301	1.046	28558.3
3	Display Results	301	301	0.063	4777.8
	(SQL Overall)	178691	301	1.405	127182.2