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

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

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.

49 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
stereoscopes	16	5	429	(None)
stereoscope	15	5	422	1	stereoscope_
stereoscopies	17	6	346	1	stereoscopies
stereoscopic	18	6	354	2	stereoscopic
stereoscopy	18	5	300	2	stereoscop_y
stethoscopes	19	6	381	2	stethoscopes
aeroscopes	14	4	801	3	_aer_oscopes
statoscopes	15	5	482	3	st_atoscopes
stereotypes	16	10	388	3	stereo_types
stethoscope	18	6	363	3	stethoscope_
streetscapes	16	6	178	3	streetscapes
stroboscopes	18	6	326	3	stroboscopes
telescopes	14	4	520	3	_tele_scopes
thermoscopes	21	6	494	3	thermoscopes
aeroscope	13	4	768	4	_aer_oscope_
arthroscopes	19	12	531	4	arthr_oscopes
baroscopes	16	4	675	4	_bar_oscopes
borescopes	16	4	517	4	_bore_scopes
cryoscopes	19	9	525	4	__cryoscopes
endoscopes	15	4	581	4	__endoscopes
fetoscopes	17	4	539	4	_fe_toscopes
gastroscopes	17	10	469	4	gast_r_oscopes
gyroscopes	18	4	507	4	_gyr_oscopes
horoscopes	17	4	764	4	_hor_oscopes
microscopes	19	11	909	4	micr_oscopes
nephoscopes	20	5	429	4	_nephoscopes
otoscopes	13	4	651	4	ot___oscopes
periscopes	16	4	635	4	_per_iscopes
sniperscopes	18	6	208	4	sniperscopes
spectroscopes	21	6	339	4	spectroscopes
statoscope	14	5	472	4	st_atoscope_
stereographs	18	5	518	4	stereographs
stereoisomer	14	6	181	4	stereoisomer
stereoisomers	15	6	150	4	stereoisomers
stereologies	13	4	591	4	stereologies
stereophonies	18	7	265	4	stereophonies
stereopses	12	5	469	4	stereo__pses
stereotype	15	6	351	4	stereo_type_
stereotyped	17	7	301	4	stereo_typed
stereotyper	16	6	337	4	stereo_typer
stereotypers	17	8	290	4	stereo_typers
stereotypies	17	5	329	4	stereotypies
stethoscopic	21	6	300	4	stethoscopic
streetscape	15	7	158	4	streetscape_
stroboscope	17	6	291	4	stroboscope_
telescope	13	5	506	4	_tele_scope_
telescoped	15	5	364	4	_tele_scoped
telescopies	15	5	384	4	_tele_scopies
thermoscope	20	8	480	4	thermoscope_

Search took 9 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	124790	0.373	479064.3
2	DLD Change Limit	124790	49	7.890	15816.2
3	Display Results	49	49	0.033	1484.8
	(SQL Overall)	178691	49	8.296	21539.4