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

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

300 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
morn	6	62	3756	(None)
born	6	73	3841	1	born
corn	6	99	4581	1	corn
horn	7	67	3561	1	horn
lorn	4	64	3525	1	lorn
moan	6	58	3201	1	moan
mon	5	75	6157	1	mo_n
moon	6	71	4081	1	moon
mor	5	68	5500	1	mor_
mora	6	66	4127	1	mora
more	6	71	5452	1	more
morns	7	55	2744	1	morns
moron	7	69	2542	1	moron
mors	6	59	5006	1	mors
mort	6	67	5883	1	mort
mourn	7	72	1501	1	mourn
mown	9	54	2444	1	mown
porn	6	56	3602	1	porn
sorn	4	66	4106	1	sorn
torn	4	60	4425	1	torn
worn	7	56	3175	1	worn
acorn	7	56	1662	2	acorn
adorn	6	49	1709	2	adorn
airn	4	64	3383	2	airn
amort	7	58	3220	2	amort
barn	6	64	4464	2	barn
boon	6	71	4217	2	boon
bora	6	61	4163	2	bora
bore	6	60	5133	2	bore
bork	10	69	3382	2	bork
borne	7	79	2679	2	borne
boron	7	67	2714	2	boron
bort	6	59	6096	2	bort
bourn	7	55	1848	2	bourn
burn	6	56	3642	2	burn
carn	6	62	4543	2	carn
coin	6	66	4535	2	coin
con	5	102	6802	2	co_n
conn	6	62	2913	2	conn
coon	6	72	4894	2	coon
cor	5	99	6094	2	cor_
cord	7	67	4092	2	cord
core	6	72	6311	2	core
corf	9	59	4148	2	corf
cork	10	66	3569	2	cork
corm	8	57	3537	2	corm
corns	7	60	3476	2	corns
cornu	7	59	2132	2	cornu
corny	10	60	2327	2	corny
cors	6	66	5644	2	cors
cory	9	69	4151	2	cory
curn	6	67	3188	2	curn
darn	5	64	3462	2	darn
don	4	67	5765	2	do_n
dor	4	72	5392	2	dor_
dore	5	63	5330	2	dore
dork	9	65	3146	2	dork
dorm	7	68	3462	2	dorm
dorp	7	60	2805	2	dorp
dorr	5	66	2772	2	dorr
dors	5	67	4760	2	dors
dory	8	58	3623	2	dory
down	8	64	2749	2	down
durn	5	61	2762	2	durn
earn	4	67	3755	2	earn
eon	3	60	5208	2	eo_n
ern	3	57	3835	2	_ern
fern	7	61	2932	2	fern
firn	7	69	2750	2	firn
fohn	10	61	1655	2	fohn
foin	7	72	3156	2	foin
fon	6	63	5227	2	fo_n
for	6	69	5207	2	for_
fora	7	59	3739	2	fora
forb	9	71	3133	2	forb
ford	8	68	3549	2	ford
fore	7	83	5147	2	fore
fork	11	59	3094	2	fork
form	9	58	3687	2	form
fort	7	64	5644	2	fort
girn	5	60	2686	2	girn
goon	5	72	3617	2	goon
gor	4	78	4826	2	gor_
gore	5	57	4496	2	gore
gorm	7	55	2939	2	gorm
gorp	7	56	2590	2	gorp
gory	8	61	2966	2	gory
gown	8	57	2407	2	gown
hern	7	61	3489	2	hern
hon	6	77	5938	2	ho_n
hora	7	61	3655	2	hora
horns	8	61	2533	2	horns
horny	11	56	1962	2	horny
ion	3	60	5102	2	io_n
iron	4	67	2846	2	iron
john	14	55	1290	2	john
join	11	67	2483	2	join
karn	8	61	2941	2	karn
kern	8	53	2621	2	kern
kirn	8	71	2343	2	kirn
koan	8	54	2503	2	koan
kor	7	65	3889	2	kor_
kora	8	64	3155	2	kora
kore	8	58	3416	2	kore
kors	8	59	3301	2	kors
korun	9	4	1192	2	korun
loan	4	74	3645	2	loan
loin	4	68	3872	2	loin
loon	4	73	4479	2	loon
loran	5	59	2509	2	loran
lord	5	50	3208	2	lord
lore	4	58	5035	2	lore
lory	7	59	3171	2	lory
lown	7	69	2929	2	lown
main	6	53	4551	2	main
man	5	74	6585	2	m_an
mar	5	79	6594	2	mar_
mara	6	74	4456	2	mara
marc	8	70	3462	2	marc
mare	6	47	5932	2	mare
mark	10	51	3805	2	mark
marl	6	63	4161	2	marl
mars	6	62	6186	2	mars
mart	6	68	6597	2	mart
maun	6	57	2720	2	maun
mawn	9	44	2413	2	mawn
mean	6	55	3808	2	mean
men	5	92	5284	2	m_en
merc	8	72	2562	2	merc
mere	6	72	4444	2	mere
merk	10	60	2794	2	merk
merl	6	58	3097	2	merl
mien	6	50	2836	2	mien
mir	5	70	4677	2	mir_
mire	6	67	4823	2	mire
miri	6	67	3037	2	miri
mirin	7	50	2315	2	mirin
mirk	10	67	2950	2	mirk
mirs	6	69	4057	2	mirs
miry	9	63	2675	2	miry
mo	4	91	5848	2	mo__
moa	5	72	4918	2	mo_a
moans	7	46	2436	2	moans
moas	6	55	4534	2	moas
moat	6	63	5203	2	moat
mob	7	86	5192	2	mo_b
mobs	8	57	3737	2	mobs
moc	7	78	4508	2	mo_c
mock	12	64	2944	2	mock
mocs	8	58	3490	2	mocs
mod	6	90	5440	2	mo_d
mode	7	58	4030	2	mode
modern	9	3	952	2	modern
modi	7	68	2631	2	modi
mods	7	79	4505	2	mods
mog	6	69	4967	2	mo_g
mogs	7	54	3933	2	mogs
moil	6	55	3409	2	moil
moira	7	10	1202	2	moira
moire	7	10	1732	2	moire
mojo	13	69	1722	2	mojo
moke	10	62	3422	2	moke
mol	5	66	5459	2	mo_l
mola	6	60	3563	2	mola
mold	7	60	3433	2	mold
mole	6	62	5183	2	mole
moll	6	67	3570	2	moll
mols	6	59	4857	2	mols
molt	6	63	5616	2	molt
moly	9	60	3191	2	moly
mom	7	88	5316	2	mo_m
mome	8	52	3935	2	mome
momi	8	75	2448	2	momi
moms	8	65	3948	2	moms
monk	10	59	2851	2	monk
mono	6	60	3671	2	mono
mons	6	81	5225	2	mons
mony	9	68	3000	2	mony
moo	5	84	6051	2	mo_o
mood	7	63	3206	2	mood
mool	6	75	3386	2	mool
moons	7	53	3100	2	moons
moony	10	48	1827	2	moony
moor	6	66	2855	2	moor
moors	7	49	2314	2	moors
moory	10	51	1579	2	moory
moos	6	60	5130	2	moos
moot	6	76	5362	2	moot
mop	7	69	5082	2	mo_p
mope	8	68	3804	2	mope
mops	8	59	4013	2	mops
mopy	11	57	2197	2	mopy
morae	7	58	3119	2	morae
moral	7	55	3343	2	moral
moras	7	64	3876	2	moras
moray	10	54	2379	2	moray
moreen	8	3	1334	2	moreen
morel	7	57	2909	2	morel
mores	7	62	4964	2	mores
morgan	9	3	1137	2	morgan
morgen	9	3	1220	2	morgen
morion	8	62	1773	2	morion
morons	8	49	1954	2	morons
morph	12	17	1251	2	morph
morro	7	32	1695	2	morro
morse	7	60	3270	2	morse
morts	7	55	3356	2	morts
mos	5	70	6712	2	mo_s
mosh	9	52	2760	2	mosh
mosk	10	56	2244	2	mosk
moss	6	76	4103	2	moss
most	6	65	5420	2	most
mot	5	72	7942	2	mo_t
mote	6	70	4808	2	mote
moth	9	67	3133	2	moth
mots	6	68	5316	2	mots
mott	6	66	4844	2	mott
moue	6	58	3557	2	moue
mound	8	39	1831	2	mound
mount	7	41	2806	2	mount
mourns	8	41	1101	2	mourns
move	9	66	3072	2	move
mow	8	66	5035	2	mo_w
mows	9	63	4083	2	mows
moxa	13	69	1774	2	moxa
mozo	15	77	1974	2	mozo
mun	5	61	4385	2	m_un
muon	6	57	2273	2	muon
mura	6	56	3329	2	mura
mure	6	59	4133	2	mure
murk	10	55	2725	2	murk
murr	6	52	2513	2	murr
noon	4	71	3462	2	noon
nor	3	80	4882	2	nor_
nori	4	71	3314	2	nori
norm	6	64	2981	2	norm
noun	4	57	2418	2	noun
omen	6	68	2818	2	omen
on	2	80	5718	2	_o_n
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
pirn	6	71	2837	2	pirn
poon	6	73	4126	2	poon
pore	6	64	5126	2	pore
pork	10	69	2968	2	pork
porno	7	51	2065	2	porno
porns	7	55	2734	2	porns
porny	10	60	2019	2	porny
port	6	60	5963	2	port
roan	4	72	3420	2	roan
scorn	7	58	1744	2	scorn
shorn	8	57	2217	2	shorn
son	3	77	6195	2	so_n
soon	4	62	4050	2	soon
sora	4	57	4691	2	sora
sorb	6	83	3304	2	sorb
sord	5	62	3720	2	sord
sore	4	70	5953	2	sore
sori	4	60	3983	2	sori
sorns	5	50	2841	2	sorns
sort	4	62	6481	2	sort
sown	7	51	2745	2	sown
sworn	8	61	1530	2	sworn
tarn	4	68	4272	2	tarn
tern	4	61	3480	2	tern
thorn	8	53	1870	2	thorn
ton	3	102	6510	2	to_n
toon	4	77	4063	2	toon
tor	3	92	6168	2	tor_
tora	4	75	4599	2	tora
torc	6	63	3335	2	torc
tore	4	73	5932	2	tore
tori	4	75	4215	2	tori
toro	4	80	4568	2	toro
torr	4	56	3090	2	torr
tors	4	61	5738	2	tors
tort	4	69	6746	2	tort
tory	7	58	4054	2	tory
town	7	69	2870	2	town
turn	4	63	3038	2	turn
urn	3	57	3146	2	_urn
warn	7	52	3932	2	warn
won	6	62	5206	2	wo_n
word	8	98	3200	2	word
wore	7	71	4467	2	wore
work	11	55	2884	2	work
worm	9	61	2948	2	worm
wort	7	66	5475	2	wort
yarn	7	52	3004	2	yarn
yon	6	73	4895	2	yo_n
yore	7	63	3594	2	yore
yourn	8	75	1277	2	yourn
zoon	13	73	2698	2	zoon
zori	13	77	2292	2	zori

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.076	2351197.4
2	DLD Change Limit	29872	300	0.986	30296.1
3	Display Results	300	300	0.063	4761.9
	(SQL Overall)	178691	300	1.125	158836.4