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

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

100 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
sticked	14	41	1463	(None)
sicked	13	45	2440	1	s_icked
slicked	14	44	1384	1	slicked
snicked	14	38	1163	1	snicked
stacked	14	34	1612	1	stacked
sticker	13	35	1588	1	sticker
stickled	15	29	897	1	stickled
stocked	14	43	1287	1	stocked
ticked	13	47	2052	1	_ticked
anticked	15	3	839	2	anticked
bricked	16	43	1206	2	bricked
clicked	16	41	1245	2	clicked
cricked	16	48	1428	2	cricked
deticked	16	3	569	2	deticked
dicked	14	49	2086	2	_dicked
flicked	17	46	1067	2	flicked
hoicked	17	3	596	2	hoicked
kicked	12	44	1594	2	_kicked
licked	13	46	2156	2	_licked
nicked	13	50	1968	2	_nicked
picked	15	44	2131	2	_picked
pricked	16	46	1383	2	pricked
ricked	13	65	2362	2	_ricked
sacked	13	55	2521	2	s_acked
shacked	17	40	1539	2	shacked
shicker	16	39	1482	2	shicker
shirked	15	37	1046	2	shirked
shocked	17	46	1181	2	shocked
shucked	17	38	983	2	shucked
sicced	11	48	965	2	s_icced
sickbed	16	39	682	2	s_ickbed
sickee	12	46	2222	2	s_ickee
sicken	12	46	1525	2	s_icken
sicker	12	40	2390	2	s_icker
sickled	14	47	1343	2	s_ickled
silked	11	43	1481	2	s_ilked
skinked	11	33	901	2	skinked
slacked	14	38	1545	2	slacked
sliced	9	44	1631	2	slic_ed
slicken	13	30	929	2	slicken
slicker	13	33	1453	2	slicker
slinked	12	30	1138	2	slinked
smacked	16	37	1099	2	smacked
smirked	14	30	723	2	smirked
smocked	16	39	822	2	smocked
snacked	14	40	1311	2	snacked
snicker	13	30	1267	2	snicker
socked	13	47	2150	2	s_ocked
specked	16	32	901	2	specked
spiced	11	52	1831	2	spic_ed
spiked	13	49	1555	2	spi_ked
stacker	13	44	1626	2	stacker
staked	11	46	2194	2	st_aked
stalked	12	38	1117	2	stalked
steeked	12	40	1047	2	steeked
stick	11	51	2156	2	stick__
stickers	14	29	1303	2	stickers
stickier	14	22	976	2	stickier
stickies	14	22	1197	2	stickies
stickit	13	3	946	2	stickit
stickle	13	24	1097	2	stickle
stickler	14	25	957	2	stickler
stickles	14	25	1210	2	stickles
stickmen	16	3	454	2	stickmen
sticks	12	51	1861	2	stick_s
stickseed	16	8	348	2	stickseed
stickum	15	3	482	2	stickum
stickup	15	3	385	2	stickup
stickweed	19	8	338	2	stickweed
sticky	15	47	1134	2	stick_y
stied	6	57	2303	2	sti__ed
stiffed	14	35	958	2	stiffed
stifled	11	35	1109	2	stifled
stilled	8	33	1479	2	stilled
stilted	8	35	1147	2	stilted
stimied	10	3	1062	2	stimied
stinker	11	33	1331	2	stinker
stinted	8	29	1419	2	stinted
stiped	9	45	1707	2	sti_ped
stirred	8	35	970	2	stirred
stitched	14	14	820	2	stitched
stocker	13	37	1308	2	stocker
stoked	11	47	1829	2	st_oked
stooked	12	43	1230	2	stooked
straked	12	54	1534	2	straked
stricken	14	3	689	2	stricken
strickled	16	6	583	2	strickled
stroked	12	46	1362	2	stroked
sucked	13	41	2049	2	s_ucked
swacked	17	31	1052	2	swacked
swinked	15	34	903	2	swinked
tacked	13	47	2394	2	_tacked
ticced	11	43	844	2	_ticced
ticker	12	43	2150	2	_ticker
ticket	12	45	2485	2	_ticket
tickled	14	43	1313	2	_tickled
tricked	14	40	1616	2	tricked
tucked	13	40	1749	2	_tucked
wicked	16	43	1741	2	_wicked
wricked	17	49	1019	2	wricked

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	107671	0.373	479064.3
2	DLD Change Limit	107671	100	4.470	24087.5
3	Display Results	100	100	0.046	2173.9
	(SQL Overall)	178691	100	4.889	36549.6