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

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

77 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
stickers	14	29	1303	(None)
shickers	17	30	1282	1	shickers
slickers	14	31	1255	1	slickers
snickers	14	30	1096	1	snickers
stackers	14	34	1356	1	stackers
sticker	13	35	1588	1	sticker_
sticklers	15	22	739	1	sticklers
stinkers	12	31	1113	1	stinkers
stockers	14	34	1107	1	stockers
tickers	13	36	1772	1	_tickers
bickers	15	43	1655	2	_bickers
clickers	16	39	1020	2	clickers
detickers	16	3	442	2	detickers
dickers	14	41	1766	2	_dickers
flickers	17	33	888	2	flickers
ickers	12	39	1418	2	__ickers
kickers	12	40	1329	2	_kickers
knickers	13	30	672	2	knickers
lickers	13	41	1825	2	_lickers
nickers	13	44	1509	2	_nickers
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
snackers	14	30	1022	2	snackers
snicker	13	30	1267	2	snicker_
snickery	17	29	554	2	snickery
spicers	11	38	1555	2	spic_ers
spikers	13	53	1199	2	spi_kers
stacker	13	44	1626	2	stacker_
stalkers	12	36	985	2	stalkers
starkers	12	37	1239	2	starkers
sticked	14	41	1463	2	sticke_d
stickier	14	22	976	2	stickier_
stickies	14	22	1197	2	stickies
stickler	14	25	957	2	stickler_
stickles	14	25	1210	2	stickles
sticks	12	51	1861	2	stick__s
stickums	16	4	394	2	stickums
stickups	16	4	330	2	stickups
stiflers	11	23	883	2	stiflers
stingers	9	40	1274	2	stingers
stinker	11	33	1331	2	stinker_
stinters	8	33	1275	2	stinters
stirrers	8	26	693	2	stirrers
stitchers	14	14	701	2	stitchers
stivers	10	36	1354	2	sti_vers
stocker	13	37	1308	2	stocker_
stokers	11	45	1518	2	st_okers
stookers	12	44	979	2	stookers
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
ticker	12	43	2150	2	_ticker_
tickets	13	41	1368	2	_tickets
ticklers	14	33	930	2	_ticklers
tinkers	11	35	1714	2	_tinkers
trickers	14	38	1281	2	trickers
tuckers	13	40	1435	2	_tuckers
whickers	20	29	798	2	whickers
wickers	16	41	1470	2	_wickers

Search took 6 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.156	1145455.1
2	DLD Change Limit	121059	77	4.830	25064.0
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	5.016	35624.2