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

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

65 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
steamer	9	33	1309	(None)
seamer	8	42	2361	1	s_eamer
stealer	7	29	1397	1	stealer
steamed	10	37	1214	1	steamed
steamers	10	34	1087	1	steamers
steamier	10	4	830	1	steamier
stemmer	11	32	1018	1	stemmer
streamer	10	23	951	1	streamer
creamer	11	37	1409	2	creamer
dreamer	10	41	1084	2	dreamer
gleamer	10	32	851	2	gleamer
metamer	11	3	961	2	metamer
reamer	8	43	2521	2	_reamer
screamer	12	26	788	2	screamer
sealer	6	39	2896	2	s_ealer
seamed	9	48	2388	2	s_eamed
seamen	8	45	1856	2	s_eamen
seamers	9	47	1943	2	s_eamers
seamier	9	31	1463	2	s_eamier
searer	6	54	3202	2	s_earer
seater	6	45	3416	2	s_eater
seemer	8	44	1804	2	s_eemer
shearer	10	44	1468	2	shearer
smearer	9	41	1040	2	smearer
sneaker	11	29	1045	2	sneaker
speaker	13	33	1121	2	speaker
spearer	9	39	1366	2	spearer
stager	7	48	2134	2	st_ager
staler	6	40	2582	2	st_aler
stamen	8	41	1594	2	st_amen
stammer	11	60	1334	2	stammer
stamper	11	37	1440	2	st_amper
starer	6	40	2736	2	st_arer
stater	6	44	2756	2	st_ater
stayer	9	45	1648	2	st_ayer
steaded	9	28	1167	2	steaded
steadier	9	3	731	2	steadier
stealers	8	34	1220	2	stealers
steam	7	63	2293	2	steam__
steamered	12	4	491	2	steamered
steams	8	49	1690	2	steam_s
steamy	11	51	1237	2	steam_y
steeper	9	38	1277	2	steeper
steer	5	54	2386	2	ste__er
steerer	7	31	1363	2	steerer
stemmed	12	27	815	2	stemmed
stemmers	12	37	844	2	stemmers
stemmery	15	33	469	2	stemmery
stemmier	12	4	525	2	stemmier
stepper	11	30	1085	2	stepper
sterner	7	4	1191	2	sterner
strafer	10	39	1246	2	strafer
strayer	10	43	1250	2	strayer
streaker	12	22	948	2	streaker
streamed	11	25	890	2	streamed
streamers	11	22	807	2	streamers
streamier	11	5	576	2	streamier
swearer	10	34	995	2	swearer
sweater	10	37	1272	2	sweater
tamer	7	52	3010	2	_t_amer
teamed	9	54	1859	2	_teamed
tearer	6	48	2290	2	_tearer
teaser	6	54	2152	2	_teaser
teemer	8	55	1574	2	_teemer
termer	8	57	1725	2	_termer

Search took 4 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	107671	0.376	475242.0
2	DLD Change Limit	107671	65	2.920	36873.6
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	3.312	53952.6