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

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

60 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
speaker	13	33	1121	(None)
sneaker	11	29	1045	1	sneaker
speakers	14	29	945	1	speakers
spearer	9	39	1366	1	spearer
beaker	12	55	2069	2	_beaker
bleaker	13	35	1053	2	bleaker
breaker	13	39	1292	2	breaker
leaker	10	46	2007	2	_leaker
peaked	13	61	1740	2	_peaked
peakier	13	44	1144	2	_peakier
pecker	14	46	1536	2	_pecker
saker	9	51	3202	2	s__aker
sealer	6	39	2896	2	s_ealer
seamer	8	42	2361	2	s_eamer
searer	6	54	3202	2	s_earer
seater	6	45	3416	2	s_eater
seeker	10	36	1536	2	s_eeker
shaker	13	43	1946	2	s_haker
shearer	10	44	1468	2	shearer
slaker	10	42	1927	2	s_laker
sleeker	11	33	982	2	sleeker
smearer	9	41	1040	2	smearer
sneaked	12	32	969	2	sneaked
sneakers	12	30	864	2	sneakers
sneakier	12	4	514	2	sneakier
soaker	10	57	1753	2	s_oaker
spacer	10	49	1779	2	sp_acer
spader	9	43	1713	2	sp_ader
spake	11	43	2274	2	sp_ake_
spanker	13	36	1235	2	spanker
sparer	8	45	2496	2	sp_arer
sparker	13	39	1436	2	sparker
speak	11	46	1867	2	speak__
speaks	12	51	1458	2	speak_s
speaned	10	34	1152	2	speaned
spear	7	58	2106	2	spea__r
speared	10	43	1442	2	speared
spearers	10	37	1114	2	spearers
specked	16	32	901	2	specked
specter	11	31	1173	2	specter
speeder	10	38	1107	2	speeder
speer	7	46	2390	2	spe__er
speller	9	54	1515	2	speller
spelter	9	41	1370	2	spelter
spencer	11	36	1097	2	spencer
spender	10	37	1369	2	spender
spewer	11	51	1215	2	spe_wer
spiker	12	43	1566	2	sp_iker
splake	12	5	978	2	splake_
splakes	13	4	967	2	splakes
sprayer	12	36	904	2	sprayer
spreader	11	3	748	2	spreader
squeaker	21	8	488	2	squeaker
stealer	7	29	1398	2	stealer
steamer	9	33	1309	2	steamer
streaker	12	22	948	2	streaker
swearer	10	34	995	2	swearer
sweater	10	37	1272	2	sweater
weaker	13	40	1544	2	_weaker
wreaker	14	36	1004	2	wreaker

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.373	479064.3
2	DLD Change Limit	107671	60	3.393	31733.3
3	Display Results	60	60	0.030	2000.0
	(SQL Overall)	178691	60	3.796	47073.5