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

Here are the results of your fuzzy-string dictionary search for “clacked” 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
clacked	16	41	1360	(None)
blacked	16	36	1337	1	blacked
clacker	15	38	1377	1	clacker
clanked	14	38	1225	1	clanked
clicked	16	41	1245	1	clicked
clocked	16	41	1283	1	clocked
clucked	16	38	1013	1	clucked
cracked	16	35	1474	1	cracked
flacked	17	37	1158	1	flacked
lacked	13	53	2465	1	_lacked
slacked	14	38	1545	1	slacked
backed	15	57	2572	2	_backed
blacken	15	43	979	2	blacken
blacker	15	45	1351	2	blacker
blanked	14	40	1122	2	blanked
blocked	16	44	998	2	blocked
cached	14	54	1920	2	c_ached
cackled	16	46	1330	2	c_ackled
caked	12	61	2862	2	c_a_ked
calked	13	46	1740	2	c_alked
carked	13	40	2482	2	c_arked
casked	13	48	1551	2	c_asked
chalked	17	44	986	2	chalked
charked	17	48	1401	2	charked
checked	19	37	1002	2	checked
chocked	19	44	1161	2	chocked
chucked	19	46	973	2	chucked
clack	13	47	2017	2	clack__
clackers	16	39	1170	2	clackers
clacks	14	45	1634	2	clack_s
cladded	12	35	692	2	cladded
clagged	12	74	923	2	clagged
claimed	12	29	883	2	claimed
clammed	14	36	996	2	clammed
clamped	14	40	1204	2	clamped
clanged	11	42	1265	2	clanged
clapped	14	35	1117	2	clapped
clashed	13	36	1401	2	clashed
clasped	12	36	1044	2	clasped
classed	10	41	1365	2	classed
clawed	12	51	1507	2	cla_wed
clayed	12	50	1304	2	cla_yed
cleeked	14	35	773	2	cleeked
clerked	14	32	665	2	clerked
cliched	15	37	1102	2	cliched
clicker	15	41	1188	2	clicker
clinked	14	40	1164	2	clinked
cloaked	14	36	854	2	cloaked
clocker	15	39	1087	2	clocker
clonked	14	42	956	2	clonked
clunked	14	43	957	2	clunked
coached	15	33	1384	2	coached
coacted	12	36	1161	2	coacted
cocked	15	50	2256	2	c_ocked
cracker	15	31	1417	2	cracker
crackled	17	42	886	2	crackled
cranked	14	38	1284	2	cranked
cricked	16	48	1428	2	cricked
crocked	16	40	1443	2	crocked
flaked	14	47	1565	2	fla_ked
flanked	15	37	1064	2	flanked
flecked	17	35	807	2	flecked
flicked	17	46	1067	2	flicked
flocked	17	45	1025	2	flocked
glaceed	11	3	619	2	glaceed
hacked	16	49	2351	2	_hacked
jacked	20	48	1752	2	_jacked
knacked	13	28	779	2	knacked
laced	8	71	3264	2	_lac_ed
lacker	12	53	2562	2	_lacker
lackey	15	48	1335	2	_lackey
laked	10	57	3112	2	_la_ked
larked	11	45	1947	2	_larked
licked	13	46	2156	2	_licked
locked	13	49	2166	2	_locked
lucked	13	51	1802	2	_lucked
packed	15	48	2260	2	_packed
placed	11	43	1800	2	plac_ed
placket	15	4	1287	2	placket
planked	14	35	1228	2	planked
plucked	16	36	796	2	plucked
quacked	23	3	679	2	quacked
racked	13	45	2608	2	_racked
sacked	13	55	2521	2	_sacked
shacked	17	40	1539	2	shacked
slacken	13	39	993	2	slacken
slacker	13	39	1529	2	slacker
slaked	11	43	1827	2	sla_ked
slicked	14	44	1384	2	slicked
smacked	16	37	1099	2	smacked
snacked	14	40	1311	2	snacked
stacked	14	34	1612	2	stacked
swacked	17	31	1052	2	swacked
tacked	13	47	2394	2	_tacked
talcked	14	4	634	2	talcked
thacked	17	38	1020	2	thacked
tracked	14	37	1613	2	tracked
whacked	20	45	862	2	whacked
wracked	17	41	1011	2	wracked
yacked	16	45	1679	2	_yacked

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.376	475242.0
2	DLD Change Limit	107671	100	3.186	33795.0
3	Display Results	100	100	0.033	3030.3
	(SQL Overall)	178691	100	3.595	49705.4