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

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

98 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
blacked	16	36	1337	(None)
backed	15	57	2572	1	b_acked
blacken	15	43	979	1	blacken
blacker	15	45	1351	1	blacker
blanked	14	40	1122	1	blanked
blocked	16	44	998	1	blocked
clacked	16	41	1360	1	clacked
flacked	17	37	1158	1	flacked
lacked	13	53	2465	1	_lacked
slacked	14	38	1545	1	slacked
bached	14	55	1989	2	b_ached
backer	14	45	2552	2	b_acker
baked	12	61	3077	2	b_a_ked
balked	13	52	1941	2	b_alked
banked	13	50	2144	2	b_anked
barked	13	50	2731	2	b_arked
basked	13	52	1860	2	b_asked
beached	15	45	1655	2	beached
beaked	13	59	1949	2	bea_ked
becked	15	54	1776	2	b_ecked
belaced	12	41	1215	2	belac_ed
blabbed	11	35	781	2	blabbed
black	13	47	1907	2	black__
blackened	18	4	527	2	blackened
blackens	16	38	810	2	blackens
blackest	16	26	930	2	blackest
blackhead	21	8	429	2	blackhead
blacklead	18	6	390	2	blacklead
blackleg	17	3	423	2	blackleg
blackly	18	3	525	2	blackly
blacks	14	49	1495	2	black_s
bladed	10	47	1776	2	bla_ded
blamed	11	60	1795	2	bla_med
blanched	16	30	860	2	blanched
blanker	13	46	1202	2	blanker
blanket	13	43	1309	2	blanket
blared	9	50	1824	2	bla_red
blasted	10	42	1347	2	blasted
blatted	10	48	1271	2	blatted
blawed	12	47	1389	2	bla_wed
blazed	18	43	1471	2	bla_zed
bleached	16	37	856	2	bleached
blinked	14	40	1001	2	blinked
blocker	15	41	992	2	blocker
braced	11	54	2060	2	brac_ed
bracken	15	40	981	2	bracken
bracket	15	41	1723	2	bracket
bracted	12	4	1093	2	bracted
braked	13	53	1869	2	bra_ked
bricked	16	43	1206	2	bricked
bucked	15	51	2106	2	b_ucked
clacker	15	38	1377	2	clacker
clanked	14	38	1225	2	clanked
clicked	16	41	1245	2	clicked
clocked	16	41	1283	2	clocked
clucked	16	38	1013	2	clucked
cracked	16	35	1474	2	cracked
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 6 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.126	1418182.5
2	DLD Change Limit	107671	98	5.266	20446.4
3	Display Results	98	98	0.076	1289.5
	(SQL Overall)	178691	98	5.468	32679.4