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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

103 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
steams	8	49	1690	(None)
seams	7	57	3166	1	s_eams
steads	7	41	1622	1	steads
steaks	10	44	1585	1	steaks
steals	6	40	2006	1	steals
steam	7	63	2292	1	steam_
steamy	11	51	1237	1	steamy
stems	7	52	1995	1	ste_ms
streams	9	47	1337	1	streams
teams	7	57	2651	1	_teams
beams	9	53	2817	2	_beams
breams	10	48	1504	2	breams
creams	10	47	1525	2	creams
dreams	9	45	1398	2	dreams
esteems	9	3	524	2	esteems
fleams	11	50	1194	2	fleams
gleams	9	48	1225	2	gleams
items	7	49	961	2	ite_ms
reams	7	57	2962	2	_reams
reteams	9	33	956	2	reteams
scams	9	44	2397	2	s_cams
scrams	10	52	1662	2	scrams
screams	11	48	1061	2	screams
seals	5	48	3969	2	s_eals
seam	6	66	4597	2	s_eam_
seamy	10	59	2127	2	s_eamy
sears	5	47	4491	2	s_ears
seas	4	57	5527	2	s_ea_s
seats	5	48	4434	2	s_eats
seems	7	55	2502	2	s_eems
shams	10	58	2941	2	s_hams
sheafs	12	49	1288	2	sheafs
sheals	9	44	2064	2	sheals
shears	9	38	2090	2	shears
sheas	8	63	3179	2	shea_s
skeans	10	45	1291	2	skeans
skelms	12	36	802	2	skelms
slams	7	49	2790	2	s_lams
smears	8	47	1443	2	smears
sneaks	10	43	1249	2	sneaks
sneaps	8	45	1086	2	sneaps
spams	9	49	2219	2	s_pams
speaks	12	51	1458	2	speaks
speans	8	54	1714	2	speans
spears	8	40	1947	2	spears
sperms	10	25	1260	2	sperms
stabs	7	62	2138	2	st_abs
stags	6	62	2674	2	st_ags
stamp	9	52	1736	2	st_amp
stamps	10	56	1402	2	st_amps
stars	5	58	3657	2	st_ars
stats	5	59	3336	2	st_ats
stays	8	60	2202	2	st_ays
stead	6	55	2027	2	stea_d
steady	10	35	1020	2	steady
steak	9	52	1980	2	stea_k
steal	5	61	2547	2	stea_l
steamed	10	37	1214	2	steamed
steamer	9	33	1309	2	steamer
steamers	10	34	1087	2	steamers
steeds	7	38	1488	2	steeds
steeks	10	36	1370	2	steeks
steels	6	41	1798	2	steels
steeps	8	52	1519	2	steeps
steers	6	38	2098	2	steers
steins	6	48	1834	2	steins
steles	6	37	2566	2	steles
stem	6	106	2824	2	ste_m_
stemma	10	32	813	2	stemma
stemmas	11	25	697	2	stemmas
stemmy	13	41	703	2	stemmy
stenos	6	39	1577	2	stenos
stents	6	50	1945	2	stents
steps	7	66	1988	2	ste_ps
steres	6	39	2953	2	steres
sterns	6	46	1675	2	sterns
stets	5	54	2391	2	ste_ts
stews	8	55	1914	2	ste_ws
stoas	5	51	2602	2	stoa_s
stoats	6	51	1748	2	stoats
stomas	8	48	1632	2	stomas
storms	8	58	1460	2	storms
straps	8	77	2178	2	straps
strass	6	71	1722	2	strass
straws	9	87	1867	2	straws
strays	9	64	1793	2	strays
streaks	11	44	1127	2	streaks
stream	8	47	1728	2	stream_
streamy	12	50	948	2	streamy
strums	8	47	1645	2	strums
stums	7	53	2008	2	st_ums
swears	9	41	1407	2	swears
sweats	9	48	1461	2	sweats
tams	6	72	4793	2	_t_ams
teaks	9	42	2290	2	_teaks
teals	5	62	3413	2	_teals
team	6	62	3865	2	_team_
tears	5	54	3646	2	_tears
teas	4	58	5149	2	_tea_s
teats	5	56	3681	2	_teats
teems	7	60	1978	2	_teems
terms	7	55	2347	2	_terms
trams	7	53	2767	2	_trams

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	82551	0.126	1418182.5
2	DLD Change Limit	82551	103	6.733	12260.7
3	Display Results	103	103	0.080	1287.5
	(SQL Overall)	178691	103	6.939	25751.7