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

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

67 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
snickers	14	30	1096	(None)
knickers	13	30	672	1	knickers
nickers	13	44	1509	1	_nickers
shickers	17	30	1282	1	shickers
slickers	14	31	1255	1	slickers
snackers	14	30	1022	1	snackers
snicker	13	30	1267	1	snicker_
snickery	17	29	554	1	snickery
stickers	14	29	1303	1	stickers
bickers	15	43	1655	2	_bickers
clickers	16	39	1020	2	clickers
dickers	14	41	1766	2	_dickers
flickers	17	33	888	2	flickers
ickers	12	39	1418	2	__ickers
kickers	12	40	1329	2	_kickers
knackers	13	28	684	2	knackers
knockers	13	28	573	2	knockers
lickers	13	41	1825	2	_lickers
monickers	17	4	508	2	monickers
neckers	13	42	1046	2	_neckers
nickels	13	33	865	2	_nickels
nicker	12	38	1870	2	_nicker_
pickers	15	37	1809	2	_pickers
prickers	16	37	1067	2	prickers
sackers	13	38	2022	2	s_ackers
shicker	16	39	1482	2	shicker_
shikkers	14	32	652	2	shikkers
shirkers	15	31	958	2	shirkers
shockers	17	31	946	2	shockers
shuckers	17	38	813	2	shuckers
sickees	13	45	1421	2	s_ickees
sickens	13	44	1148	2	s_ickens
sicker	12	40	2390	2	s_icker_
sinkers	11	36	1854	2	s_inkers
skinkers	11	29	818	2	skinkers
slackers	14	38	1274	2	slackers
slicers	9	41	1492	2	slic_ers
slickens	14	31	726	2	slickens
slicker	13	33	1453	2	slicker_
smackers	16	31	871	2	smackers
smirkers	14	31	635	2	smirkers
snacker	13	31	1260	2	snacker_
sneakers	12	30	864	2	sneakers
snicked	14	38	1163	2	snicke_d
snickered	16	11	534	2	snickered
snickerer	15	13	456	2	snickerer
snickerers	16	13	358	2	snickerers
snicks	12	43	1247	2	snick__s
sniffers	14	25	712	2	sniffers
snifters	11	31	861	2	snifters
sniggers	10	31	709	2	sniggers
snipers	9	33	1177	2	sni_pers
snippers	12	29	972	2	snippers
snitchers	14	16	604	2	snitchers
snookers	12	39	865	2	snookers
spicers	11	38	1555	2	spic_ers
spikers	13	53	1199	2	spi_kers
stackers	14	34	1356	2	stackers
sticker	13	35	1588	2	sticker_
sticklers	15	22	739	2	sticklers
stinkers	12	31	1113	2	stinkers
stockers	14	34	1107	2	stockers
suckers	13	37	1762	2	s_uckers
tickers	13	36	1772	2	_tickers
trickers	14	38	1281	2	trickers
whickers	20	29	798	2	whickers
wickers	16	41	1470	2	_wickers

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	121059	0.423	422437.4
2	DLD Change Limit	121059	67	3.686	32842.9
3	Display Results	67	67	0.016	4187.5
	(SQL Overall)	178691	67	4.125	43319.0