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

Here are the results of your fuzzy-string dictionary search for “flacks” 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
flacks	15	41	1453	(None)
blacks	14	49	1495	1	blacks
clacks	14	45	1634	1	clacks
flack	14	45	1941	1	flack_
flanks	13	39	1340	1	flanks
flasks	13	48	867	1	flasks
flecks	15	43	1080	1	flecks
flicks	15	45	1299	1	flicks
flocks	15	47	1353	1	flocks
lacks	11	61	2920	1	_lacks
placks	14	44	1415	1	placks
slacks	12	44	1653	1	slacks
alack	11	48	2006	2	alack_
backs	13	57	2962	2	_backs
black	13	47	1907	2	black_
blanks	12	41	1289	2	blanks
blocks	14	45	1394	2	blocks
clachs	13	35	1132	2	clachs
clack	13	47	2017	2	clack_
clanks	12	46	1518	2	clanks
clicks	14	53	1511	2	clicks
clocks	14	49	1623	2	clocks
clucks	14	45	1207	2	clucks
cracks	14	48	1700	2	cracks
faces	10	64	3943	2	f_aces
facts	10	70	2189	2	f_acts
falces	11	52	1600	2	falces
fecks	14	54	1785	2	f_ecks
flabs	10	58	1864	2	fla_bs
flacked	17	37	1158	2	flacked
flacon	11	3	863	2	flacon
flacons	12	3	805	2	flacons
flags	9	53	2128	2	fla_gs
flails	9	43	1300	2	flails
flairs	9	57	1191	2	flairs
flak	11	60	2617	2	fla_k_
flake	12	51	1997	2	fla_ke
flakes	13	41	1887	2	flakes
flaky	15	57	1558	2	fla_ky
flames	11	47	2369	2	flames
flams	10	51	2501	2	fla_ms
flanes	9	45	2242	2	flanes
flank	12	46	1809	2	flank_
flans	8	53	2797	2	fla_ns
flaps	10	56	2138	2	fla_ps
flares	9	45	2170	2	flares
flask	12	55	1242	2	flask_
flats	8	64	2974	2	fla_ts
flatus	9	43	1078	2	flatus
flaws	11	59	2034	2	fla_ws
flaxes	16	50	1535	2	flaxes
flays	11	63	2105	2	fla_ys
fleck	14	82	1359	2	fleck_
flecky	18	38	765	2	flecky
flick	14	50	1721	2	flick_
flics	10	54	1836	2	flic_s
flock	14	47	1742	2	flock_
flocky	18	46	842	2	flocky
flocs	10	55	1923	2	floc_s
flunks	13	46	986	2	flunks
fracas	11	3	1199	2	fracas
franks	13	49	1273	2	franks
frocks	15	41	1121	2	frocks
fucks	14	44	1925	2	f_ucks
glaces	9	42	1802	2	glaces
glacis	9	40	1213	2	glacis
hacks	14	49	2871	2	_hacks
jacks	18	52	1983	2	_jacks
klicks	11	46	872	2	klicks
knacks	11	42	854	2	knacks
kyacks	14	41	606	2	kyacks
laces	7	61	4176	2	_laces
lack	10	58	3768	2	_lack_
lacs	6	69	4248	2	_lac_s
larks	9	52	2781	2	_larks
licks	11	53	2539	2	_licks
locks	11	51	2692	2	_locks
lucks	11	57	2356	2	_lucks
macks	13	51	2760	2	_macks
packs	13	55	2893	2	_packs
places	10	43	2370	2	places
plack	13	50	1784	2	plack_
planks	12	41	1675	2	planks
plucks	14	37	973	2	plucks
quacks	21	47	1010	2	quacks
racks	11	50	2885	2	_racks
sacks	11	42	2887	2	_sacks
shacks	15	48	1756	2	shacks
slack	11	50	2176	2	slack_
slicks	12	48	1611	2	slicks
smacks	14	41	1232	2	smacks
snacks	12	45	1455	2	snacks
stacks	12	43	1726	2	stacks
tacks	11	54	3013	2	_tacks
thacks	15	43	1192	2	thacks
tracks	12	48	1884	2	tracks
wacks	14	66	2628	2	_wacks
whacks	18	46	1048	2	whacks
wracks	15	47	1111	2	wracks
yacks	14	44	1981	2	_yacks

Search took 3 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	82551	0.110	1624463.6
2	DLD Change Limit	82551	100	2.733	30205.3
3	Display Results	100	100	0.030	3333.3
	(SQL Overall)	178691	100	2.873	62196.7