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

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

64 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
smokers	13	38	932	(None)
smoker	12	43	1169	1	smoker_
smokes	12	48	1434	1	smoke_s
stokers	11	45	1518	1	stokers
bookers	13	40	1661	2	bookers
brokers	13	31	1191	2	brokers
chokers	16	43	1152	2	chokers
cookers	13	46	1946	2	cookers
emoters	9	47	1287	2	emoters
evokers	14	38	679	2	evokers
hookers	14	49	1652	2	hookers
jokers	17	55	1119	2	_jokers
lookers	11	40	1407	2	lookers
makers	12	39	2173	2	_makers
mockers	15	38	1294	2	_mockers
mokes	11	46	3103	2	_moke_s
mopers	10	42	2037	2	_mopers
movers	11	51	1719	2	_movers
mowers	11	32	1940	2	_mowers
pokers	12	46	1792	2	_pokers
sackers	13	38	2022	2	sackers
sakers	10	41	2543	2	s_akers
scorers	9	41	1532	2	scorers
scoters	9	33	1381	2	scoters
seekers	11	37	1233	2	seekers
shakers	14	40	1556	2	shakers
shockers	17	31	946	2	shockers
shoers	9	45	1833	2	sho_ers
shovers	13	46	1300	2	shovers
showers	13	46	1268	2	showers
sinkers	11	36	1854	2	sinkers
slakers	11	41	1575	2	slakers
slopers	9	42	1309	2	slopers
smackers	16	31	871	2	smackers
smilers	9	41	1385	2	smilers
smirkers	14	31	635	2	smirkers
smiters	9	34	1436	2	smiters
smoke	11	50	1582	2	smoke__
smoked	13	43	1172	2	smoke_d
smokey	15	39	865	2	smoke_y
smokier	13	5	670	2	smokier_
smolders	11	28	719	2	smolders
smothers	13	34	993	2	smothers
snookers	12	39	865	2	snookers
snorers	7	43	1380	2	snorers
soakers	11	41	1495	2	soakers
sobers	8	52	1886	2	s_obers
sokes	9	50	3142	2	s_oke_s
sooners	7	39	1664	2	sooners
sowers	9	49	2344	2	s_owers
spikers	13	53	1199	2	spikers
spokes	12	44	1721	2	spoke_s
stockers	14	34	1107	2	stockers
stoker	10	44	1762	2	stoker_
stokes	10	48	2179	2	stoke_s
stoners	7	48	1795	2	stoners
stookers	12	44	979	2	stookers
stopers	9	42	1737	2	stopers
storers	7	50	1868	2	storers
stovers	10	37	1373	2	stovers
strokers	12	39	1090	2	strokers
suckers	13	37	1762	2	suckers
sulkers	11	36	1334	2	sulkers
tokers	10	48	1889	2	_tokers

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.393	454684.5
2	DLD Change Limit	107671	64	3.203	33615.7
3	Display Results	64	64	0.013	4923.1
	(SQL Overall)	178691	64	3.609	49512.6