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

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

59 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
stockers	14	34	1107	(None)
shockers	17	31	946	1	shockers
stackers	14	34	1356	1	stackers
stickers	14	29	1303	1	stickers
stocker	13	37	1308	1	stocker_
stokers	11	45	1518	1	sto_kers
stookers	12	44	979	1	stookers
blockers	16	39	879	2	blockers
clockers	16	36	981	2	clockers
cockers	15	36	1833	2	_cockers
dockers	14	37	1500	2	_dockers
hockers	16	39	1591	2	_hockers
knockers	13	28	573	2	knockers
lockers	13	35	1692	2	_lockers
mockers	15	38	1294	2	_mockers
ockers	12	38	1390	2	__ockers
rockers	13	39	1655	2	_rockers
sackers	13	38	2022	2	s_ackers
shickers	17	30	1282	2	shickers
shocker	16	34	1143	2	shocker_
shuckers	17	38	813	2	shuckers
slackers	14	38	1274	2	slackers
slickers	14	31	1255	2	slickers
smackers	16	31	871	2	smackers
smokers	13	38	932	2	smo_kers
snackers	14	30	1022	2	snackers
snickers	14	30	1096	2	snickers
snookers	12	39	865	2	snookers
soakers	11	41	1495	2	s_oakers
soccers	11	3	839	2	s_occers
sockets	13	40	1298	2	s_ockets
stacker	13	44	1626	2	stacker_
stalkers	12	36	985	2	stalkers
starkers	12	37	1239	2	starkers
sticker	13	35	1588	2	sticker_
sticklers	15	22	739	2	sticklers
stinkers	12	31	1113	2	stinkers
stockcars	17	4	297	2	stockcars
stocked	14	43	1287	2	stocke_d
stockier	14	21	725	2	stockier_
stocks	12	47	1563	2	stock__s
stoker	10	44	1762	2	sto_ker_
stokes	10	48	2179	2	sto_ke_s
stompers	12	36	1004	2	stompers
stoners	7	48	1795	2	sto_ners
stooker	11	38	1173	2	stooker_
stoopers	10	37	1130	2	stoopers
stopers	9	42	1737	2	sto_pers
stoppers	12	39	1059	2	stoppers
storers	7	50	1868	2	sto_rers
stovers	10	37	1373	2	sto_vers
strikers	12	36	1129	2	strikers
strokers	12	39	1090	2	strokers
suckers	13	37	1762	2	s_uckers
tackers	13	43	1962	2	_tackers
tickers	13	36	1772	2	_tickers
tochers	12	34	1309	2	_tochers
tokers	10	48	1889	2	_to_kers
tuckers	13	40	1435	2	_tuckers

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	121059	0.406	440125.6
2	DLD Change Limit	121059	59	3.250	37248.9
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	3.686	48478.3