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

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

37 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
micrometers	17	4	907	(None)
micrometer	16	4	1014	1	micrometer_
microliters	15	4	580	2	microliters
micromeres	16	4	848	2	micromere_s
picometers	16	4	828	2	pic_ometers
aerometers	12	4	948	3	_aerometers
barometers	14	19	851	3	_barometers
biometers	13	3	917	3	bi__ometers
cryometers	17	4	600	3	__cryometers
cyclometers	20	4	518	3	cyclometers
durometers	13	5	637	3	_durometers
hectometers	18	4	606	3	hectometers
hydrometers	20	9	594	3	hydrometers
hygrometers	20	8	445	3	hygrometers
kilometers	16	8	665	3	ki_lometers
macromeres	16	4	575	3	macromere_s
manometers	14	4	802	3	m_anometers
microbrewers	21	6	276	3	microbrewers
microcytes	19	4	842	3	microcyte_s
microgametes	19	6	479	3	microgamete_s
microliter	14	4	742	3	microliter_
micromere	15	4	787	3	microm__ere
micromethod	21	11	330	3	micromethod
micromethods	22	12	284	3	micromethods
micromoles	16	4	842	3	micromole_s
microreaders	17	5	324	3	microreaders
millimeters	15	4	415	3	millimeters
monometers	14	4	936	3	m_onometers
orometers	11	3	1042	3	__orometers
picometer	15	4	891	3	pic_ometer_
picometres	16	4	722	3	pic_ometres
piezometers	24	4	383	3	piezometers
pycnometers	20	4	445	3	pycnometers
pyrometers	17	4	833	3	_pyrometers
spirometers	15	4	580	3	spirometers
tachometers	18	5	507	3	tachometers
viscometers	18	5	494	3	viscometers

Search took 6 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	121633	0.423	422437.4
2	DLD Change Limit	121633	37	5.076	23962.4
3	Display Results	37	37	0.033	1121.2
	(SQL Overall)	178691	37	5.532	32301.3