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

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

79 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
smoker	12	43	1169	(None)
smoke	11	50	1582	1	smoke_
smoked	13	43	1172	1	smoked
smokers	13	38	932	1	smokers
smokes	12	48	1434	1	smokes
smokey	15	39	865	1	smokey
smokier	13	5	670	1	smokier
stoker	10	44	1762	1	stoker
booker	12	47	1919	2	booker
broker	12	43	1424	2	broker
choker	15	43	1437	2	choker
cooker	12	47	2245	2	cooker
emoter	8	54	1519	2	emoter
evoker	13	46	791	2	evoker
hooker	13	48	2017	2	hooker
joker	16	57	1589	2	_joker
looker	10	48	1695	2	looker
maker	11	41	2781	2	_maker
mocker	14	33	1544	2	_mocker
moke	10	62	3422	2	_moke_
mokes	11	46	3103	2	_mokes
moper	9	49	2592	2	_moper
mover	10	42	2086	2	_mover
mower	10	45	2345	2	_mower
poker	11	51	2288	2	_poker
sacker	12	51	2484	2	sacker
saker	9	51	3202	2	s_aker
scorer	8	48	1825	2	scorer
scoter	8	38	1547	2	scoter
seeker	10	36	1536	2	seeker
shaker	13	43	1946	2	shaker
shocker	16	34	1142	2	shocker
shoer	8	47	2215	2	sho_er
shover	12	45	1598	2	shover
shower	12	43	1510	2	shower
sicker	12	40	2390	2	sicker
siker	9	53	2603	2	s_iker
sinker	10	36	2090	2	sinker
slaker	10	42	1927	2	slaker
sloper	8	46	1591	2	sloper
slower	9	40	1615	2	slower
smacker	15	34	1058	2	smacker
smiler	8	39	1668	2	smiler
smirker	13	32	742	2	smirker
smiter	8	36	1641	2	smiter
smocked	16	39	822	2	smocked
smoky	14	38	868	2	smok_y
smolder	10	32	775	2	smolder
smote	7	58	2027	2	smote_
smother	12	35	1020	2	smother
snooker	11	39	1030	2	snooker
snorer	6	43	1676	2	snorer
soaker	10	57	1753	2	soaker
sober	7	48	2240	2	s_ober
soke	8	54	3626	2	s_oke_
sokes	9	50	3142	2	s_okes
somber	10	37	1399	2	somber
sooner	6	42	2046	2	sooner
sorer	5	62	3657	2	s_orer
sower	8	52	2931	2	s_ower
spiker	12	43	1566	2	spiker
spoke	11	48	1866	2	spoke_
spoked	13	44	1389	2	spoked
spoken	12	46	1000	2	spoken
spokes	12	44	1721	2	spokes
stocker	13	37	1308	2	stocker
stoke	9	49	2251	2	stoke_
stoked	11	47	1829	2	stoked
stokers	11	45	1518	2	stokers
stokes	10	48	2179	2	stokes
stoner	6	58	2320	2	stoner
stooker	11	38	1173	2	stooker
stoper	8	43	2009	2	stoper
storer	6	47	2167	2	storer
stover	9	41	1564	2	stover
stroker	11	41	1351	2	stroker
sucker	12	41	2066	2	sucker
sulker	10	40	1592	2	sulker
toker	9	59	2491	2	_toker

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	82551	0.143	1249587.4
2	DLD Change Limit	82551	79	4.750	17379.2
3	Display Results	79	79	0.060	1316.7
	(SQL Overall)	178691	79	4.953	36077.3