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

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

90 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
flacked	17	37	1158	(None)
blacked	16	36	1337	1	blacked
clacked	16	41	1360	1	clacked
flaked	14	47	1565	1	fla_ked
flanked	15	37	1064	1	flanked
flecked	17	35	807	1	flecked
flicked	17	46	1067	1	flicked
flocked	17	45	1025	1	flocked
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
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
faced	11	77	2765	2	f_ac_ed
faked	13	52	2548	2	f_a_ked
flaccid	15	4	439	2	flaccid
flack	14	45	1941	2	flack__
flackery	20	29	524	2	flackery
flacks	15	41	1453	2	flack_s
flagged	13	45	963	2	flagged
flailed	11	3	730	2	flailed
flake	12	51	1997	2	fla_ke_
flaker	13	49	1617	2	fla_ker
flakes	13	41	1887	2	fla_kes
flakey	16	44	1051	2	fla_key
flamed	12	46	1897	2	fla_med
flammed	15	37	741	2	flammed
flanged	12	38	1084	2	flanged
flanken	14	22	676	2	flanken
flanker	14	39	1129	2	flanker
flapped	15	32	825	2	flapped
flared	10	53	1760	2	fla_red
flashed	14	41	1218	2	flashed
flasket	14	3	973	2	flasket
flatbed	13	39	798	2	flatbed
flatted	11	40	1294	2	flatted
flawed	13	47	1272	2	fla_wed
flayed	13	44	1405	2	fla_yed
flicker	16	36	1062	2	flicker
flocced	15	36	548	2	flocced
fluked	14	51	1209	2	fl_uked
flunked	15	39	841	2	flunked
fracted	13	3	937	2	fracted
franked	15	36	1005	2	franked
frocked	17	43	933	2	frocked
fucked	16	41	1448	2	f_ucked
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	90	3.173	33933.5
3	Display Results	90	90	0.030	3000.0
	(SQL Overall)	178691	90	3.579	49927.6