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

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

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.

51 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
steamers	10	34	1087	(None)
seamers	9	47	1943	1	s_eamers
stealers	8	34	1221	1	stealers
steamer	9	33	1309	1	steamer_
stemmers	12	37	844	1	stemmers
streamers	11	22	807	1	streamers
creamers	12	41	1131	2	creamers
dreamers	11	36	900	2	dreamers
gleamers	11	30	656	2	gleamers
metamers	12	4	962	2	metamers
reamers	9	42	2108	2	_reamers
screamers	13	23	626	2	screamers
sealers	7	43	2355	2	s_ealers
seamer	8	42	2361	2	s_eamer_
seaters	7	40	2894	2	s_eaters
seemers	9	38	1433	2	s_eemers
shearers	11	39	1132	2	shearers
smearers	10	30	862	2	smearers
sneakers	12	30	864	2	sneakers
speakers	14	29	945	2	speakers
spearers	10	37	1114	2	spearers
stagers	8	41	1667	2	st_agers
stamens	9	34	1148	2	st_amens
stammers	12	36	1152	2	stammers
stampers	12	42	1160	2	st_ampers
starers	7	45	2231	2	st_arers
staters	7	39	2234	2	st_aters
stayers	10	38	1363	2	st_ayers
steadiers	10	3	508	2	steadiers
stealer	7	29	1398	2	stealer_
steamed	10	37	1214	2	steame_d
steamered	12	4	491	2	steamered
steamier	10	4	830	2	steamier_
steams	8	49	1690	2	steam__s
steepers	10	30	1137	2	steepers
steerers	8	25	1135	2	steerers
steers	6	38	2098	2	ste__ers
stemmer	11	32	1018	2	stemmer_
stemmery	15	33	469	2	stemmery
steppers	12	28	928	2	steppers
strafers	11	37	991	2	strafers
strayers	11	35	1014	2	strayers
streakers	13	21	813	2	streakers
streamer	10	23	951	2	streamer_
swearers	11	32	858	2	swearers
sweaters	11	38	1106	2	sweaters
tamers	8	42	2403	2	_t_amers
tearers	7	52	1823	2	_tearers
teasers	7	53	1724	2	_teasers
teemers	9	50	1290	2	_teemers
termers	9	54	1450	2	_termers

Search took 5 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	121059	0.406	440125.6
2	DLD Change Limit	121059	51	3.920	30882.4
3	Display Results	51	51	0.016	3187.5
	(SQL Overall)	178691	51	4.342	41154.1