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

Here are the results of your fuzzy-string dictionary search for “micron” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

323 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
micron	10	37	1428	(None)
bicron	10	37	1077	1	bicron
macron	10	36	1567	1	macron
micro	9	47	1599	1	micro_
microns	11	38	1478	1	microns
micros	10	41	1536	1	micros
mikron	12	31	850	1	mikron
omicron	11	6	506	1	omicron
bicorn	10	36	1010	2	bicorn
bicrons	11	34	1047	2	bicrons
citron	8	31	1298	2	citron
dacron	9	43	1069	2	dacron
diuron	7	3	857	2	diuron
giron	6	61	1899	2	gi_ron
icon	6	69	2204	2	_ic_on
iron	4	67	2846	2	_i_ron
macon	9	45	1995	2	mac_on
macro	9	47	1817	2	macro_
macrons	11	35	1489	2	macrons
macros	10	40	1701	2	macros
marron	8	37	1754	2	marron
matron	8	39	1831	2	matron
micra	9	62	1497	2	micr_a
microbe	13	3	866	2	microbe
microhm	16	4	612	2	microhm
midiron	10	4	600	2	midiron
mignon	9	3	795	2	mignon
mikrons	13	42	841	2	mikrons
minion	8	34	1624	2	minion
mirin	7	50	2315	2	mi_rin
mirror	8	4	800	2	mirror
moron	7	69	2542	2	m_oron
mucro	9	45	1372	2	mucro_
omicrons	12	7	519	2	omicrons
omikron	13	5	317	2	omikron
zircon	17	5	495	2	zircon
acorn	7	56	1662	3	_acorn
aileron	7	3	983	3	aileron
airn	4	64	3384	3	ai_r_n
ancon	7	57	1823	3	anc_on
apron	7	3	1883	3	_apron
archon	11	3	1175	3	archon
bacon	9	56	2059	3	bac_on
baron	7	81	3124	3	_baron
beckon	14	30	938	3	beckon
bicorne	11	29	755	3	bicorne
bicorns	11	33	876	3	bicorns
billon	8	37	1383	3	billon
biotron	9	3	729	3	biotron
biro	6	61	3122	3	bi_ro_
biros	7	53	2513	3	bi_ros
bison	7	57	1698	3	bi_son
boron	7	67	2714	3	_boron
chon	9	66	2779	3	__chon
cicero	10	4	850	3	cicero_
cicerone	12	4	752	3	cicerone
ciceroni	12	4	485	3	ciceroni
ciceros	11	5	859	3	ciceros
cion	6	133	3092	3	__cion
cistron	9	29	988	3	cistron
citrin	8	26	1541	3	citrin
citrons	9	29	1322	3	citrons
clon	6	62	3248	3	__clon
cocoon	10	3	1226	3	cocoon
con	5	102	6802	3	__c_on
coon	6	72	4894	3	__coon
corn	6	99	4581	3	__corn
croc	8	57	2373	3	__croc
crone	7	52	3133	3	__crone
crony	10	59	1867	3	__crony
croon	7	55	2278	3	__croon
crop	8	76	2863	3	__crop
crow	9	64	2813	3	__crow
crown	10	56	2008	3	__crown
dacrons	10	32	1103	3	dacrons
decrown	13	20	605	3	decrown
diatron	8	3	928	3	diatron
dicot	8	54	2909	3	dic_ot
diction	10	23	1305	3	diction
discrown	14	4	528	3	discrown
diurons	8	3	882	3	diurons
eikon	9	3	946	3	ei_kon
escrow	11	3	591	3	escrow
fibrin	11	3	853	3	fibrin
fibroin	12	4	647	3	fibroin
ficin	10	35	1672	3	fic_in
fico	9	58	2460	3	fic_o_
fiction	12	20	1073	3	fiction
firn	7	69	2751	3	fi_r_n
garcon	9	29	1248	3	garcon
garron	7	31	1349	3	garron
gibbon	11	3	532	3	gibbon
gibson	9	3	512	3	gibson
gipon	8	42	1241	3	gi_pon
girn	5	60	2687	3	gi_r_n
giro	5	58	2864	3	gi_ro_
girons	7	50	1437	3	gi_rons
giros	6	57	2265	3	gi_ros
gyron	9	53	1462	3	_gyron
hadron	10	29	1375	3	hadron
heron	8	50	2550	3	_heron
ichor	10	3	948	3	_ichor
icons	7	65	1649	3	_ic_ons
ikon	8	58	1496	3	_i_kon
imbrown	14	4	388	3	imbrown
improv	13	4	464	3	improv
inion	5	46	2018	3	_inion
inro	4	59	2079	3	_inro_
inrun	5	29	1137	3	_inrun
intron	6	42	1503	3	intron
ion	3	60	5103	3	_i__on
irone	5	51	2636	3	_i_rone
irons	5	53	2413	3	_i_rons
irony	8	50	1590	3	_i_rony
kirn	8	71	2345	3	ki_r_n
ladron	7	34	1332	3	ladron
lichen	11	40	1274	3	lichen
lictor	8	36	1086	3	lictor
ligroin	8	4	804	3	ligroin
linuron	7	4	651	3	linuron
lion	4	63	3445	3	li__on
lirot	5	4	3003	3	li_rot
macaroni	12	4	652	3	macaroni
macaroon	12	4	634	3	macaroon
macho	12	61	2015	3	macho_
machos	13	52	1749	3	machos
macons	10	40	1724	3	mac_ons
madrona	10	28	870	3	madrona
madrone	10	28	1266	3	madrone
madrono	10	28	874	3	madrono
mammon	9	3	964	3	mammon
maroon	8	31	1820	3	maroon
marrons	9	32	1697	3	marrons
marrow	11	28	1261	3	marrow
mascon	10	36	1274	3	mascon
mason	7	48	2018	3	m_ason
matrons	9	35	1763	3	matrons
megaron	10	24	830	3	megaron
melon	7	39	2208	3	m_elon
melton	8	3	1155	3	melton
merlon	8	30	1235	3	merlon
meson	7	41	1831	3	m_eson
metro	7	47	1880	3	metro_
metros	8	42	1780	3	metros
miaou	7	5	1308	3	mi_aou
miaow	10	5	835	3	mi_aow
mic	7	76	4765	3	mic___
mica	8	64	2826	3	mic__a
micas	9	68	2305	3	mic_as
mice	8	74	4224	3	mic__e
micell	10	9	819	3	micell
miche	12	62	1924	3	mic_he
miched	14	39	1339	3	miched
miches	13	43	2073	3	miches
miching	15	29	1180	3	miching
mick	12	63	3344	3	mic__k
mickey	17	42	1185	3	mickey
mickle	14	37	1513	3	mickle
micks	13	55	2537	3	mic_ks
micrify	17	4	469	3	micrify
microbar	14	4	589	3	microbar
microbes	14	3	940	3	microbes
microbian	15	7	656	3	micro~~bia~~n
microbic	16	4	721	3	microbic
microbus	14	5	603	3	microbus
microcap	16	4	558	3	microcap
microdont	14	4	775	3	microdont
microdot	13	4	813	3	microdot
microhms	17	6	561	3	microhms
microinch	18	4	455	3	microinch
microloan	13	4	618	3	microloan
microlux	19	4	364	3	microlux
micromho	17	4	461	3	micromho
micromini	15	4	659	3	micromini
micronize	22	4	890	3	micron~~ize~~
microtone	13	4	968	3	microtone
mics	8	74	3516	3	mic__s
midden	10	41	1285	3	midden
midirons	11	4	588	3	midirons
midnoon	10	4	468	3	midnoon
midrib	11	3	824	3	midrib
midtown	13	4	367	3	midtown
mien	6	50	2837	3	mi__en
mignons	10	3	786	3	mignons
migrant	10	3	1431	3	migrant
mihrab	13	3	552	3	mihrab
mikra	11	46	1031	3	mikr_a
mikvos	15	5	402	3	mikvos
mikvot	15	5	676	3	mikvot
milden	9	41	1315	3	milden
million	9	18	1315	3	million
millrun	9	4	418	3	millrun
milo	6	55	3611	3	mi_lo_
milord	9	9	957	3	milord
milos	7	54	2801	3	mi_los
mimeo	9	60	1868	3	mimeo_
mimeos	10	45	1154	3	mimeos
minions	9	33	1462	3	minions
minnow	11	3	558	3	minnow
minor	7	49	2006	3	mi_nor
minors	8	51	1710	3	minors
minyan	11	3	817	3	minyan
mir	5	70	4678	3	mi_r__
mire	6	67	4824	3	mi_r_e
mired	8	57	2922	3	mi_red
mires	7	56	4088	3	mi_res
mirex	14	68	1662	3	mi_rex
miri	6	67	3038	3	mi_r_i
miring	9	37	2380	3	mi_ring
mirins	8	39	1890	3	mi_rins
mirk	10	67	2951	3	mi_r_k
mirks	11	51	2214	3	mi_rks
mirky	14	63	1552	3	mi_rky
mirrors	9	3	862	3	mirrors
mirs	6	69	4058	3	mi_r_s
mirth	10	64	1889	3	mi_rth
miry	9	63	2676	3	mi_r_y
mirza	16	4	1044	3	mi_rza
miscoin	11	3	1143	3	miscoin
miscook	15	4	647	3	miscook
misdo	8	54	1319	3	misdo_
misdone	10	3	1086	3	misdone
misgrow	13	4	443	3	misgrow
misgrown	14	4	398	3	misgrown
misjoin	16	3	769	3	misjoin
miso	6	72	2991	3	mi_so_
misos	7	65	2329	3	mi_sos
mispen	10	3	1217	3	mispen
mission	9	3	1274	3	mission
mitral	8	13	1432	3	mitral
mitre	7	55	2242	3	mitr_e
mitred	9	44	1434	3	mitred
mitres	8	39	2207	3	mitres
mitring	10	35	1414	3	mitring
mitten	8	39	1409	3	mitten
mizen	16	48	1527	3	mi_zen
mizzen	16	44	795	3	mizzen
mon	5	75	6158	3	m___on
monuron	9	3	746	3	monuron
moon	6	71	4081	3	m__oon
morion	8	62	1773	3	morion
morn	6	62	3756	3	m_or_n
morons	8	49	1954	3	m_orons
morrion	9	5	900	3	morrion
morro	7	32	1695	3	morro_
morros	8	37	1467	3	morros
morrow	11	35	1009	3	morrow
motion	8	52	1755	3	motion
mourn	7	72	1501	3	mour_n
mouton	8	4	1085	3	mouton
mucho	12	50	1344	3	mucho_
mucin	9	31	1682	3	muc_in
mucor	9	40	1194	3	muc_or
mucors	10	44	1085	3	mucors
mucrones	12	3	760	3	mucrones
muon	6	57	2273	3	m__uon
muton	7	38	1700	3	m_uton
mutton	8	5	1045	3	mutton
natron	6	41	1602	3	natron
neuron	6	3	1037	3	neuron
nicol	7	11	1329	3	nic_ol
nimrod	9	3	487	3	nimrod
ninon	5	55	1738	3	ni_non
niton	5	54	1828	3	ni_ton
nitro	5	49	1435	3	nitro_
nitros	6	42	1412	3	nitros
omikrons	14	6	296	3	omikrons
operon	8	8	1177	3	operon
patron	8	40	1804	3	patron
perron	8	32	1662	3	perron
picaro	10	3	1132	3	picaro_
picaroon	12	4	565	3	picaroon
picaros	11	3	1089	3	picaros
picot	9	50	3101	3	pic_ot
picric	12	30	992	3	picric
pigeon	9	4	941	3	pigeon
pinion	8	38	1589	3	pinion
pinon	7	60	2453	3	pi_non
pinyon	11	45	976	3	pinyon
pion	6	72	3530	3	pi__on
pirn	6	71	2838	3	pi_r_n
pirog	8	39	1367	3	pi_rog
piston	8	35	1592	3	piston
piton	7	61	2158	3	pi_ton
racon	7	54	2214	3	rac_on
racoon	8	38	1447	3	racoon
reckon	12	30	1054	3	reckon
recon	7	56	2424	3	rec_on
recrown	12	25	757	3	recrown
ribbon	10	3	653	3	ribbon
richen	11	38	1251	3	richen
ricin	7	46	2021	3	ric_in
ricrac	10	3	701	3	ricrac
scion	7	22	1499	3	_scion
scorn	7	58	1745	3	_scorn
scrod	8	51	1507	3	_scrod
siccan	10	3	759	3	siccan
sicken	12	46	1525	3	sicken
sicko	11	53	1539	3	sicko_
sickos	12	51	1203	3	sickos
simoon	8	5	806	3	simoon
siphon	11	3	846	3	siphon
siren	5	45	2582	3	si_ren
submicron	15	5	243	3	~~sub~~micron
thoron	9	47	1390	3	thoron
tictoc	10	3	600	3	tictoc
tiglon	7	3	792	3	tiglon
tigon	6	39	1444	3	ti_gon
tiro	4	68	3237	3	ti_ro_
tiros	5	45	2489	3	ti_ros
tricorn	9	3	796	3	tricorn
tycoon	11	3	602	3	tycoon
uncrown	12	3	632	3	uncrown
unicorn	9	4	651	3	unicorn
vibrion	12	4	525	3	vibrion
viceroy	15	4	493	3	viceroy
victor	11	32	1067	3	victor
virion	9	3	1068	3	virion
vision	9	3	1131	3	vision
waitron	10	3	633	3	waitron
wiccan	13	3	503	3	wiccan
wigeon	10	3	722	3	wigeon
zircons	18	5	496	3	zircons

Search took 7 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	112716	0.390	458182.1
2	DLD Change Limit	112716	323	5.983	18839.4
3	Display Results	323	323	0.093	3473.1
	(SQL Overall)	178691	323	6.466	27635.5