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

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

58 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
optometers	14	5	674	(None)
optometer	13	4	729	1	optometer_
potometers	14	4	906	1	potometers
octameters	14	4	483	2	octameters
odometers	12	4	713	2	o_dometers
optometry	16	5	445	2	optomet_ry
orometers	11	3	1042	2	o_rometers
osmometers	14	4	492	2	osmometers
potometer	13	4	984	2	potometer_
aerometers	12	4	948	3	aerometers
algometers	13	4	600	3	algometers
altimeters	12	4	635	3	altimeters
atmometers	14	4	587	3	atmometers
barometers	14	19	851	3	barometers
biometers	13	3	917	3	_biometers
bolometers	14	4	738	3	bolometers
copromoters	17	5	398	3	copromoters
coulometers	15	4	510	3	coulometers
cryometers	17	4	600	3	cryometers
durometers	13	5	637	3	durometers
ergometers	13	4	578	3	ergometers
gasometers	13	4	664	3	gasometers
geometers	12	3	819	3	_geometers
goniometers	14	4	485	3	goniometers
hectometers	18	4	606	3	hectometers
heptameters	18	5	327	3	heptameters
hypsometers	21	5	377	3	hypsometers
kilometers	16	8	665	3	kilometers
manometers	14	4	802	3	manometers
monometers	14	4	936	3	monometers
nanometers	12	4	712	3	nanometers
octameter	13	5	501	3	octameter_
odometer	11	4	741	3	o_dometer_
ohmmeters	16	4	378	3	o_hmmeters
optimizers	23	4	302	3	optimizers
optometric	16	4	607	3	optometric
optometries	15	5	574	3	optometries
optometrist	15	5	443	3	optometrist
orometer	10	3	1070	3	o_rometer_
osmometer	13	4	520	3	osmometer_
ostomates	11	4	934	3	ostomate_s
oximeters	18	5	514	3	o_ximeters
pedometers	15	4	721	3	pedometers
photometers	18	4	844	3	photometers
picometers	16	4	828	3	picometers
promoters	13	3	1009	3	_promoters
prompters	15	3	755	3	_prompters
pyrometers	17	4	833	3	pyrometers
ratemeters	12	4	499	3	ratemeters
rheometers	15	4	575	3	rheometers
rotameters	12	4	503	3	rotameters
salometers	12	5	807	3	salometers
spirometers	15	4	580	3	spirometers
tonometers	12	4	811	3	tonometers
udometers	12	4	574	3	_udometers
voltmeters	15	5	428	3	volt_meters
wattmeters	15	4	360	3	wattmeters
zymometers	26	198	693	3	zymometers

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	140603	0.156	1145455.1
2	DLD Change Limit	140603	58	6.453	21788.8
3	Display Results	58	58	0.033	1757.6
	(SQL Overall)	178691	58	6.642	26903.2