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

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

81 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
shocked	17	46	1181	(None)
chocked	19	44	1161	1	chocked
hocked	16	55	2130	1	_hocked
shacked	17	40	1539	1	shacked
shocker	16	34	1143	1	shocker
shucked	17	38	983	1	shucked
smocked	16	39	822	1	smocked
socked	13	47	2150	1	s_ocked
stocked	14	43	1287	1	stocked
blocked	16	44	998	2	blocked
checked	19	37	1002	2	checked
choked	16	49	1479	2	cho_ked
chucked	19	46	973	2	chucked
clocked	16	41	1283	2	clocked
cocked	15	50	2256	2	_cocked
crocked	16	40	1444	2	crocked
docked	14	50	1833	2	_docked
flocked	17	45	1025	2	flocked
frocked	17	43	933	2	frocked
hacked	16	49	2351	2	_hacked
hocker	15	51	1856	2	_hocker
hockey	18	48	1315	2	_hockey
hoicked	17	3	596	2	_hoicked
hoked	13	53	2699	2	_ho_ked
holked	14	49	1366	2	_holked
honked	14	45	1791	2	_honked
hooked	14	53	2055	2	_hooked
howked	17	73	1234	2	_howked
knocked	13	23	630	2	knocked
locked	13	49	2166	2	_locked
mocked	15	47	1661	2	_mocked
nocked	13	46	1738	2	_nocked
pocked	15	48	1898	2	_pocked
rocked	13	50	2232	2	_rocked
sacked	13	55	2521	2	s_acked
shackled	18	27	760	2	shackled
shanked	15	32	1212	2	shanked
sharked	15	36	1391	2	sharked
shicker	16	39	1482	2	shicker
shirked	15	37	1046	2	shirked
shoaled	11	38	1097	2	shoaled
shock	14	49	1703	2	shock__
shockers	17	31	946	2	shockers
shocks	15	44	1458	2	shock_s
shoed	9	57	2301	2	sho__ed
shogged	13	39	796	2	shogged
shooed	10	39	1608	2	sho_oed
shooled	11	52	1266	2	shooled
shopped	15	35	1221	2	shopped
shored	10	57	2365	2	sho_red
shorted	11	36	1440	2	shorted
shotted	11	39	1240	2	shotted
shouted	11	39	1155	2	shouted
shoved	13	42	1428	2	sho_ved
showed	13	50	1697	2	sho_wed
shucker	16	37	1010	2	shucker
shylocked	22	4	220	2	shylocked
sicked	13	45	2440	2	s_icked
slacked	14	38	1545	2	slacked
slicked	14	44	1384	2	slicked
smacked	16	37	1099	2	smacked
smoked	13	43	1172	2	smo_ked
snacked	14	40	1311	2	snacked
snicked	14	38	1163	2	snicked
snooked	12	37	1149	2	snooked
soaked	11	47	1759	2	s_oaked
socket	12	39	2352	2	s_ocket
specked	16	32	901	2	specked
spoked	13	44	1389	2	spo_ked
spooked	14	45	1047	2	spooked
stacked	14	34	1612	2	stacked
sticked	14	41	1463	2	sticked
stocker	13	37	1308	2	stocker
stoked	11	47	1829	2	sto_ked
stooked	12	43	1230	2	stooked
sucked	13	41	2049	2	s_ucked
swacked	17	31	1052	2	swacked
thacked	17	38	1020	2	thacked
trocked	14	43	1224	2	trocked
whacked	20	45	862	2	whacked
yocked	16	41	1442	2	_yocked

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.436	409841.7
2	DLD Change Limit	107671	81	3.906	27565.5
3	Display Results	81	81	0.033	2454.5
	(SQL Overall)	178691	81	4.375	40843.7