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

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

40 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
nightscopes	19	5	264	(None)
nightscope	18	5	301	1	nightscope_
nephoscopes	20	5	429	3	nephoscopes
nightcaps	17	4	319	3	night_cap_s
nightshades	19	5	191	3	nightshades
nightsides	15	4	394	3	nights_ides
nightspots	16	5	227	3	nightspo_ts
tightropes	16	5	359	3	tight_ropes
bioscopes	15	4	655	4	bi__oscopes
dichroscopes	22	5	411	4	dichroscopes
fiberscopes	20	5	249	4	fiberscopes
hagioscopes	19	5	389	4	hagioscopes
hightops	17	4	504	4	hight__op_s
kinescopes	18	6	421	4	ki_nescopes
kinetoscopes	20	6	249	4	kinetoscopes
lightships	19	5	328	4	lightship_s
lightsome	15	11	417	4	lights_ome_
microscopes	19	11	909	4	microscopes
nephoscope	19	5	409	4	nephoscope_
nightcap	16	4	296	4	night_cap__
nightclothes	21	6	123	4	nightclothes
nightclubs	18	5	198	4	night_clubs
nightglows	18	5	206	4	nightglo_ws
nightgowns	18	5	199	4	night_gowns
nighties	12	10	1138	4	night___ies
nightlifes	17	9	375	4	night_lifes
nightlives	17	6	380	4	night_lives
nightmares	16	5	356	4	night_mares
nightshade	18	5	240	4	nightshade_
nightshirts	18	6	153	4	nightshirts
nightside	14	4	412	4	nights_ide_
nightspot	15	5	286	4	nights__pot
nightstands	16	5	179	4	nightstands
nightsticks	21	5	175	4	nightsticks
nighttides	15	4	376	4	night_tides
nighttimes	16	5	318	4	night_times
rightsizes	23	5	343	4	rights_izes
sightsees	13	4	454	4	sights__ees
sniperscopes	18	6	208	4	sniperscopes
tightrope	15	5	375	4	tight_rope_

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	148819	0.436	409841.7
2	DLD Change Limit	148819	40	8.220	18104.5
3	Display Results	40	40	0.030	1333.3
	(SQL Overall)	178691	40	8.686	20572.3