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

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

327 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
ern	3	57	3836	(None)
earn	4	67	3755	1	earn
en	2	80	5239	1	e_n
eon	3	60	5208	1	eon
er	2	83	4514	1	er_
era	3	57	4150	1	era
ere	3	63	5277	1	ere
erg	4	55	3107	1	erg
erne	4	67	2743	1	erne
erns	4	54	2823	1	erns
err	3	56	2653	1	err
ers	3	60	4628	1	ers
fern	7	61	2932	1	fern
hern	7	61	3489	1	hern
kern	8	53	2621	1	kern
tern	4	61	3480	1	tern
urn	3	57	3147	1	urn
aeon	4	56	3461	2	aeon
aero	4	54	3534	2	aero
aery	7	72	3168	2	aery
ain	3	75	7909	2	ain
airn	4	64	3383	2	airn
an	2	118	7908	2	_an
ar	2	113	7938	2	ar_
arb	5	104	4842	2	arb
arc	5	102	5090	2	arc
are	3	78	7457	2	are
arf	6	74	5337	2	arf
ark	7	70	4496	2	ark
arm	5	84	4962	2	arm
ars	3	76	7093	2	ars
art	3	86	7914	2	art
awn	6	80	3591	2	awn
ban	5	83	6684	2	ban
barn	6	64	4464	2	barn
bean	6	64	4386	2	bean
been	6	53	3578	2	been
ben	5	65	5492	2	ben
berg	7	54	2554	2	berg
berk	10	59	2984	2	berk
berm	8	67	3275	2	berm
bin	5	66	5864	2	bin
born	6	73	3841	2	born
bra	5	63	3946	2	bra
bran	6	57	4038	2	bran
bren	6	56	2956	2	bren
brin	6	70	3819	2	brin
bro	5	62	3660	2	bro
brr	5	69	2192	2	brr
bun	5	63	4814	2	bun
burn	6	56	3643	2	burn
can	5	77	6014	2	can
carn	6	62	4543	2	carn
cere	6	67	4147	2	cere
cero	6	63	2945	2	cero
con	5	102	6802	2	con
corn	6	99	4581	2	corn
cru	5	71	2956	2	cru
cry	8	97	2624	2	cry
curn	6	67	3189	2	curn
dan	4	68	5967	2	dan
darn	5	64	3462	2	darn
dean	5	60	3948	2	dean
den	4	75	5434	2	den
dere	5	68	4590	2	dere
derm	7	60	3189	2	derm
din	4	64	5946	2	din
don	4	67	5765	2	don
dry	7	65	2603	2	dry
dun	4	65	4558	2	dun
durn	5	61	2763	2	durn
ear	3	68	6788	2	ear
earl	4	58	3814	2	earl
earns	5	59	2756	2	earns
ears	4	63	5659	2	ears
eat	3	69	8905	2	eat
eau	3	74	5094	2	eau
ebb	7	24	1863	2	ebb
ebon	6	68	2110	2	ebon
ecru	6	58	1953	2	ecru
ecu	5	68	2823	2	ecu
ed	3	86	4518	2	e_d
edh	7	69	2156	2	edh
eds	4	66	3892	2	eds
eek	7	79	3510	2	eek
eel	3	79	4684	2	eel
eery	7	61	2962	2	eery
ef	5	73	4536	2	e_f
eff	9	61	2862	2	eff
efs	6	68	2960	2	efs
eft	6	60	3882	2	eft
egg	5	69	1867	2	egg
ego	4	67	2605	2	ego
eh	5	83	3996	2	e_h
eke	7	56	3009	2	eke
el	2	67	4529	2	e_l
elan	4	67	3424	2	elan
eld	4	67	3379	2	eld
elf	6	61	3852	2	elf
elk	7	67	2612	2	elk
ell	3	67	3568	2	ell
elm	5	75	3174	2	elm
els	3	76	4572	2	els
em	4	94	4515	2	e_m
eme	5	58	3718	2	eme
ems	5	64	3549	2	ems
emu	5	59	2998	2	emu
end	4	68	3435	2	end
eng	4	67	2678	2	eng
ens	3	72	4592	2	ens
eons	4	66	3871	2	eons
eras	4	54	4150	2	eras
ergo	5	64	2015	2	ergo
ergs	5	55	2381	2	ergs
ernes	5	52	2481	2	ernes
eros	4	52	3845	2	eros
errs	4	56	2253	2	errs
erst	4	74	3643	2	erst
es	2	90	4822	2	e_s
esne	4	70	1879	2	esne
ess	3	60	3088	2	ess
et	2	69	6419	2	e_t
eta	3	58	3419	2	eta
eth	6	66	3098	2	eth
etna	4	64	1526	2	etna
euro	4	53	2527	2	euro
eve	6	63	3116	2	eve
even	7	52	2227	2	even
ewe	6	66	3098	2	ewe
ex	9	88	3564	2	e_x
exon	11	71	1680	2	exon
eye	6	55	3977	2	eye
eyen	7	62	2366	2	eyen
eyne	7	63	2246	2	eyne
eyra	7	62	1755	2	eyra
eyre	7	55	2525	2	eyre
eyry	10	63	1588	2	eyry
fan	6	71	5886	2	fan
fen	6	68	5135	2	fen
fer	6	66	4612	2	fer_
fere	7	63	4223	2	fere
ferns	8	52	2008	2	ferns
ferny	11	58	1618	2	ferny
fin	6	64	5803	2	fin
firn	7	69	2750	2	firn
fon	6	63	5227	2	fon
fro	6	55	3064	2	fro
fry	9	62	2650	2	fry
fun	6	68	4114	2	fun
gan	4	80	6013	2	gan
gen	4	59	5051	2	gen
germ	7	54	2896	2	germ
gin	4	60	5575	2	gin
girn	5	60	2686	2	girn
gran	5	63	3501	2	gran
grin	5	57	3372	2	grin
gun	4	72	4080	2	gun
hen	6	75	5527	2	hen
her	6	65	4781	2	her_
herb	9	47	3096	2	herb
herd	8	49	3306	2	herd
here	7	64	4710	2	here
herl	7	58	3455	2	herl
herm	9	56	3615	2	herm
herns	8	48	2558	2	herns
hero	7	46	3578	2	hero
heron	8	50	2550	2	heron
hers	7	58	4487	2	hers
hewn	10	67	1985	2	hewn
hin	6	75	5956	2	hin
hon	6	77	5938	2	hon
horn	7	67	3561	2	horn
hun	6	58	4471	2	hun
in	2	81	5086	2	_in
inn	3	67	2743	2	inn
ion	3	60	5102	2	ion
ire	3	69	4317	2	ire
irk	7	64	2636	2	irk
iron	4	67	2846	2	iron
jean	11	66	2928	2	jean
jeon	11	68	2144	2	jeon
jerk	15	49	2013	2	jerk
jin	10	64	4393	2	jin
jun	10	59	3206	2	jun
karn	8	61	2941	2	karn
keen	8	48	3041	2	keen
ken	7	63	4398	2	ken
kerb	10	43	2271	2	kerb
kerf	11	58	2746	2	kerf
kerne	9	47	1822	2	kerne
kerns	9	47	1956	2	kerns
kin	7	63	5397	2	kin
kirn	8	71	2344	2	kirn
lean	4	63	4524	2	lean
learn	5	53	2266	2	learn
lin	3	79	6737	2	lin
lorn	4	64	3525	2	lorn
man	5	74	6587	2	man
mean	6	55	3809	2	mean
men	5	92	5285	2	men
merc	8	72	2562	2	merc
mere	6	72	4444	2	mere
merk	10	60	2794	2	merk
merl	6	58	3097	2	merl
mon	5	75	6158	2	mon
morn	6	62	3756	2	morn
mun	5	61	4386	2	mun
nan	3	78	5488	2	nan
neon	4	70	2642	2	neon
nerd	5	66	2494	2	nerd
nun	3	55	3774	2	nun
on	2	80	5718	2	_on
or	2	73	5473	2	or_
ora	3	72	5083	2	ora
orb	5	57	3686	2	orb
orc	5	70	3492	2	orc
ore	3	66	6183	2	ore
ors	3	57	5011	2	ors
ort	3	94	6523	2	ort
own	6	64	2970	2	own
pan	5	84	6645	2	pan
pean	6	61	4717	2	pean
peen	6	59	3808	2	peen
pein	6	58	3494	2	pein
pen	5	65	5884	2	pen
peon	6	56	3524	2	peon
per	5	63	5309	2	per_
pere	6	64	5026	2	pere
peri	6	56	3697	2	peri
perk	10	62	3284	2	perk
perm	8	58	3463	2	perm
perp	8	90	2989	2	perp
pert	6	67	5932	2	pert
perv	9	72	2481	2	perv
pin	5	70	6672	2	pin
pirn	6	71	2837	2	pirn
porn	6	56	3602	2	porn
pro	5	58	3726	2	pro
pry	8	57	2805	2	pry
pun	5	88	4651	2	pun
quern	14	36	1040	2	quern
ran	3	82	6662	2	ran
re	2	61	5374	2	_re
reb	5	58	4496	2	reb
rec	5	56	4546	2	rec
red	4	67	5580	2	red
ree	3	79	7407	2	ree
ref	6	60	5329	2	ref
reg	4	61	4649	2	reg
rei	3	56	4725	2	rei
rein	4	60	4089	2	rein
rem	5	61	5004	2	rem
rend	5	61	3657	2	rend
rent	4	66	6124	2	rent
rep	5	58	4780	2	rep
reran	5	73	2910	2	reran
rerun	5	87	2215	2	rerun
res	3	55	6504	2	res
ret	3	59	8283	2	ret
rev	6	53	3662	2	rev
rex	10	57	4099	2	rex
rin	3	66	6318	2	rin
run	3	62	4499	2	run
seen	4	69	4312	2	seen
sen	3	60	5852	2	sen
ser	3	67	5240	2	ser_
sera	4	61	4139	2	sera
sere	4	61	5347	2	sere
serf	7	63	4011	2	serf
serin	5	54	3444	2	serin
sers	4	57	4665	2	sers
sewn	7	61	2433	2	sewn
sin	3	62	6589	2	sin
son	3	77	6195	2	son
sorn	4	66	4106	2	sorn
sri	3	56	3400	2	sri
stern	5	53	1912	2	stern
sun	3	71	4903	2	sun
syn	6	70	2412	2	syn
tan	3	71	6758	2	tan
tarn	4	68	4272	2	tarn
teen	4	59	3820	2	teen
ten	3	58	5611	2	ten
term	6	62	3315	2	term
terne	5	64	2615	2	terne
terns	5	52	2687	2	terns
tin	3	63	6217	2	tin
ton	3	102	6510	2	ton
torn	4	60	4425	2	torn
try	6	65	2967	2	try
tun	3	58	4519	2	tun
turn	4	63	3039	2	turn
un	2	83	4114	2	_un
urb	5	57	3111	2	urb
urd	4	64	2705	2	urd
urns	4	63	2390	2	urns
urp	5	64	2640	2	urp
van	6	62	4633	2	van
vein	7	56	2575	2	vein
vera	7	68	2884	2	vera
verb	9	62	2487	2	verb
vert	7	72	4937	2	vert
very	10	80	2564	2	very
wan	6	67	6194	2	wan
warn	7	52	3932	2	warn
wean	7	57	3435	2	wean
ween	7	58	3546	2	ween
wen	6	62	4960	2	wen
were	7	62	3833	2	were
wert	7	97	4982	2	wert
win	6	64	5629	2	win
won	6	62	5206	2	won
worn	7	56	3175	2	worn
wren	7	82	2168	2	wren
wry	9	65	2470	2	wry
wyn	9	59	2144	2	wyn
yarn	7	52	3004	2	yarn
yean	7	58	3458	2	yean
yearn	8	63	1643	2	yearn
yen	6	68	4738	2	yen
yerk	11	62	2208	2	yerk
yin	6	76	4873	2	yin
yon	6	73	4895	2	yon
zein	13	56	2060	2	zein
zerk	17	53	1925	2	zerk
zero	13	48	2247	2	zero
zin	12	56	4377	2	zin

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	14084	0.283	631417.0
2	DLD Change Limit	14084	327	0.436	32302.8
3	Display Results	327	327	0.080	4087.5
	(SQL Overall)	178691	327	0.799	223643.3