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

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

94 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
shicker	16	39	1482	(None)
shickers	17	30	1282	1	shickers
shikker	13	27	702	1	shikker
shirker	14	37	1134	1	shirker
shocker	16	34	1143	1	shocker
shucker	16	37	1010	1	shucker
sicker	12	40	2390	1	s_icker
slicker	13	33	1453	1	slicker
snicker	13	30	1267	1	snicker
sticker	13	35	1588	1	sticker
thicker	16	36	1102	1	thicker
whicker	19	35	977	1	whicker
bicker	14	48	1917	2	_bicker
checker	18	32	953	2	checker
chicer	13	45	1360	2	chic_er
chickee	18	31	1155	2	chickee
chicken	18	27	898	2	chicken
chirker	16	42	932	2	chirker
clicker	15	41	1188	2	clicker
dicker	13	45	2140	2	_dicker
flicker	16	36	1062	2	flicker
hacker	15	48	2269	2	_hacker
hickey	18	50	1199	2	_hickey
hiker	12	51	1939	2	_hi_ker
hocker	15	51	1856	2	_hocker
icker	11	40	1844	2	__icker
kicker	11	41	1618	2	_kicker
licker	12	52	2204	2	_licker
nicker	12	38	1870	2	_nicker
picker	14	44	2217	2	_picker
pricker	15	40	1341	2	pricker
quicker	22	4	702	2	quicker
sacker	12	51	2484	2	s_acker
shacked	17	40	1539	2	shacked
shackler	17	31	797	2	shackler
shaker	13	43	1946	2	sh_aker
sharker	14	43	1381	2	sharker
shickered	19	11	572	2	shickered
shicksa	16	3	410	2	shicksa
shier	8	54	2894	2	shi__er
shifter	13	29	1108	2	shifter
shikar	13	3	680	2	shi_kar
shikkers	14	32	652	2	shikkers
shimmer	14	33	1087	2	shimmer
shiner	9	38	2087	2	shi_ner
shinier	10	41	1314	2	shinier
shipper	14	35	1404	2	shipper
shirked	15	37	1046	2	shirked
shirkers	15	31	958	2	shirkers
shiver	12	45	1737	2	shi_ver
shocked	17	46	1181	2	shocked
shockers	17	31	946	2	shockers
shrieker	15	26	565	2	shrieker
shrinker	15	23	636	2	shrinker
shtickier	18	4	316	2	shtickier
shucked	17	38	983	2	shucked
shuckers	17	38	813	2	shuckers
sicked	13	45	2440	2	s_icked
sickee	12	46	2222	2	s_ickee
sicken	12	46	1525	2	s_icken
siker	9	53	2603	2	s_i_ker
sinker	10	36	2090	2	s_inker
skinker	10	31	944	2	skinker
slacker	13	39	1529	2	slacker
slicer	8	41	1760	2	slic_er
slicked	14	44	1384	2	slicked
slicken	13	30	929	2	slicken
slickers	14	31	1255	2	slickers
smacker	15	34	1058	2	smacker
smirker	13	32	742	2	smirker
snacker	13	31	1260	2	snacker
snicked	14	38	1163	2	snicked
snickers	14	30	1096	2	snickers
snickery	17	29	554	2	snickery
spicer	10	47	1931	2	spic_er
spicier	11	51	1246	2	spicier
spiker	12	43	1566	2	spi_ker
stacker	13	44	1626	2	stacker
sticked	14	41	1463	2	sticked
stickers	14	29	1303	2	stickers
stickier	14	22	976	2	stickier
stickler	14	25	957	2	stickler
stinker	11	33	1331	2	stinker
stocker	13	37	1308	2	stocker
sucker	12	41	2066	2	s_ucker
thicken	16	31	787	2	thicken
thicket	16	32	1307	2	thicket
thinker	14	36	1068	2	thinker
ticker	12	43	2150	2	_ticker
tricker	13	46	1552	2	tricker
whacker	19	36	850	2	whacker
whickers	20	29	798	2	whickers
whisker	17	36	793	2	whisker
wicker	15	45	1867	2	_wicker

Search took 8 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.500	357382.0
2	DLD Change Limit	107671	94	6.813	15803.8
3	Display Results	94	94	0.046	2043.5
	(SQL Overall)	178691	94	7.359	24282.0