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

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

82 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
blocked	16	44	998	(None)
blacked	16	36	1337	1	blacked
blocker	15	41	992	1	blocker
clocked	16	41	1283	1	clocked
flocked	17	45	1025	1	flocked
locked	13	49	2166	1	_locked
backed	15	57	2572	2	b_acked
becked	15	54	1776	2	b_ecked
bemocked	19	3	407	2	bemocked
blacken	15	43	979	2	blacken
blacker	15	45	1351	2	blacker
blanked	14	40	1122	2	blanked
blinked	14	40	1001	2	blinked
bloated	10	45	1343	2	bloated
blobbed	11	36	656	2	blobbed
block	13	49	1784	2	block__
blockade	17	4	403	2	blockade
blockaded	19	4	308	2	blockaded
blockers	16	39	879	2	blockers
blockhead	21	5	273	2	blockhead
blockier	16	6	613	2	blockier
blocks	14	45	1394	2	block_s
blocky	17	38	835	2	block_y
bloke	11	43	1663	2	blo_ke_
blokes	12	38	1388	2	blo_kes
blooded	11	37	980	2	blooded
bloomed	12	43	943	2	bloomed
blooped	12	39	854	2	blooped
blotched	16	3	565	2	blotched
blotted	10	39	1183	2	blotted
bloused	10	43	1064	2	bloused
blowed	12	50	1669	2	blo_wed
blowsed	13	44	902	2	blowsed
blowzed	22	43	597	2	blowzed
bonked	13	55	1731	2	b_onked
booked	13	53	1950	2	b_ooked
borked	13	51	1729	2	b_orked
bricked	16	43	1206	2	bricked
brocket	15	40	1338	2	brocket
brooked	14	36	1003	2	brooked
bucked	15	51	2106	2	b_ucked
chocked	19	44	1161	2	chocked
clacked	16	41	1360	2	clacked
clicked	16	41	1245	2	clicked
cloaked	14	36	854	2	cloaked
clocker	15	39	1087	2	clocker
clonked	14	42	956	2	clonked
clucked	16	38	1013	2	clucked
cocked	15	50	2256	2	_cocked
crocked	16	40	1443	2	crocked
docked	14	50	1833	2	_docked
flacked	17	37	1158	2	flacked
flecked	17	35	807	2	flecked
flicked	17	46	1067	2	flicked
flocced	15	36	548	2	flocced
frocked	17	43	933	2	frocked
hocked	16	55	2130	2	_hocked
knocked	13	23	630	2	knocked
lacked	13	53	2465	2	_lacked
licked	13	46	2156	2	_licked
locker	12	40	1942	2	_locker
locket	12	39	2247	2	_locket
locoed	9	43	1219	2	_locoed
looked	11	47	1707	2	_looked
lucked	13	51	1802	2	_lucked
mocked	15	47	1661	2	_mocked
nocked	13	46	1738	2	_nocked
plonked	14	34	810	2	plonked
plucked	16	36	796	2	plucked
pocked	15	48	1898	2	_pocked
relocked	15	21	774	2	relocked
rocked	13	50	2232	2	_rocked
shocked	17	46	1181	2	shocked
slacked	14	38	1545	2	slacked
slicked	14	44	1384	2	slicked
smocked	16	39	822	2	smocked
socked	13	47	2150	2	_socked
stocked	14	43	1287	2	stocked
trocked	14	43	1224	2	trocked
unblocked	18	6	435	2	unblocked
unlocked	15	26	838	2	unlocked
yocked	16	41	1442	2	_yocked

Search took 4 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	82	3.236	33272.9
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	3.639	49104.4