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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

91 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
midiron	10	4	600	(None)
midirons	11	4	588	1	midirons
andiron	8	4	828	2	andiron
gridiron	10	7	251	2	gridiron
micron	10	37	1428	2	mi_cron
midnoon	10	4	468	2	midnoon
mikron	12	31	850	2	mi_kron
minion	8	34	1624	2	mini_on
sadiron	8	3	604	2	sadiron
vidicon	13	4	378	2	vidicon
aileron	7	3	983	3	aileron
amidin	9	40	1567	3	amidi__n
andirons	9	4	842	3	andirons
bicron	10	37	1077	3	bi_cron
biotron	9	3	729	3	biotron
cistron	9	29	988	3	cistron
citron	8	31	1298	3	ci_tron
diatron	8	3	928	3	diatron
diuron	7	3	857	3	di_uron
eidolon	8	4	491	3	eidolon
environ	10	4	476	3	environ
giron	6	61	1899	3	__giron
gridirons	11	6	257	3	gridirons
hadron	10	29	1375	3	had_ron
idiom	8	9	996	3	_idi_om
idiot	6	7	1886	3	_idi_ot
inion	5	46	2018	3	_ini_on
intron	6	42	1502	3	_intron
iron	4	67	2846	3	___iron
ladron	7	34	1332	3	lad_ron
liaison	7	4	447	3	liaison
linuron	7	4	651	3	linuron
macron	10	36	1567	3	m_acron
madrona	10	28	870	3	mad_rona
madrone	10	28	1266	3	mad_rone
madrono	10	28	874	3	mad_rono
maduro	9	3	698	3	maduro_
maduros	10	3	630	3	maduros
madzoon	19	9	606	3	madzoon
malison	9	3	969	3	malison
marron	8	37	1754	3	m_arron
matron	8	39	1831	3	m_atron
median	9	41	1754	3	medi_an
medico	11	37	1116	3	medico_
medicos	12	33	983	3	medicos
megaron	10	24	830	3	megaron
micro	9	47	1599	3	mi_cro_
microns	11	38	1478	3	mi_crons
micros	10	41	1536	3	mi_cros
midair	9	3	799	3	midair__
midairs	10	3	720	3	midair_s
midbrain	13	4	392	3	midbrain
midden	10	41	1285	3	mid_den
midi	7	56	2848	3	midi___
midis	8	59	2341	3	midi__s
midnoons	11	4	440	3	midnoons
midrib	11	3	824	3	mid_rib
midribs	12	3	551	3	midribs
midriff	16	4	551	3	midriff
midtown	13	4	367	3	midtown
mignon	9	3	795	3	mi_gnon
mikrons	13	42	841	3	mi_krons
million	9	18	1314	3	million
millrun	9	4	418	3	millrun
minikin	13	25	898	3	minikin
minions	9	33	1462	3	mini_ons
minivan	12	4	571	3	minivan
mirin	7	50	2315	3	m__irin
mirliton	10	4	418	3	mirliton
mirror	8	4	800	3	mi_rror
misgrow	13	4	443	3	misgrow
misgrown	14	4	398	3	misgrown
mission	9	3	1274	3	mission
modern	9	3	952	3	moder_n
monuron	9	3	746	3	monuron
morion	8	62	1773	3	mori_on
moron	7	69	2542	3	m__oron
morrion	9	5	900	3	morrion
motion	8	52	1755	3	moti_on
noniron	7	3	837	3	noniron
omicron	11	6	506	3	omi_cron
omikron	13	5	317	3	omi_kron
pinion	8	38	1589	3	pini_on
sadirons	9	3	603	3	sadirons
silicon	9	11	753	3	silicon
smidgeon	12	30	327	3	smidgeon
vibrion	12	4	525	3	vibrion
vidicons	14	4	386	3	vidicons
virion	9	3	1068	3	viri_on
vision	9	3	1131	3	visi_on
widgeon	12	4	414	3	widgeon

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	134027	0.410	435831.7
2	DLD Change Limit	134027	91	5.873	22820.9
3	Display Results	91	91	0.030	3033.3
	(SQL Overall)	178691	91	6.313	28305.2