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

Here are the results of your fuzzy-string dictionary search for “flack” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

112 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
flack	14	45	1941	(None)
alack	11	48	2006	1	alack
black	13	47	1907	1	black
clack	13	47	2017	1	clack
flacks	15	41	1453	1	flacks
flak	11	60	2617	1	fla_k
flank	12	46	1809	1	flank
flask	12	55	1242	1	flask
fleck	14	82	1359	1	fleck
flick	14	50	1721	1	flick
flock	14	47	1742	1	flock
lack	10	58	3768	1	_lack
plack	13	50	1784	1	plack
slack	11	50	2176	1	slack
aback	13	48	1617	2	aback
back	12	55	3576	2	_back
blacks	14	49	1495	2	blacks
blank	11	54	1855	2	blank
block	13	49	1784	2	block
clach	12	46	1782	2	clach
clacks	14	45	1634	2	clacks
clank	11	47	1952	2	clank
click	13	52	1795	2	click
clock	13	49	1798	2	clock
cluck	13	49	1489	2	cluck
crack	13	41	2053	2	crack
face	9	61	4012	2	f_ace
fact	9	71	4254	2	f_act
feck	13	49	2343	2	f_eck
flab	9	66	2835	2	fla_b
flabs	10	58	1864	2	flabs
flacked	17	37	1158	2	flacked
flacon	11	3	863	2	flacon
flag	8	74	2708	2	fla_g
flags	9	53	2128	2	flags
flail	8	53	1618	2	flail
flair	8	61	1412	2	flair
flake	12	51	1997	2	flake
flaky	15	57	1558	2	flaky
flam	9	63	3329	2	fla_m
flame	10	51	2444	2	flame
flams	10	51	2501	2	flams
flamy	13	52	1747	2	flamy
flan	7	61	3418	2	fla_n
flanks	13	39	1340	2	flanks
flans	8	53	2797	2	flans
flap	9	61	2870	2	fla_p
flaps	10	56	2138	2	flaps
flare	8	48	2363	2	flare
flash	11	57	1621	2	flash
flasks	13	48	867	2	flasks
flat	7	71	4782	2	fla_t
flats	8	64	2974	2	flats
flaw	10	63	2664	2	fla_w
flaws	11	59	2034	2	flaws
flawy	14	59	1338	2	flawy
flax	14	73	2563	2	fla_x
flaxy	18	90	1229	2	flaxy
flay	10	63	3280	2	fla_y
flays	11	63	2105	2	flays
flecks	15	43	1080	2	flecks
flecky	18	38	765	2	flecky
flic	9	62	2373	2	flic_
flicks	15	45	1299	2	flicks
flics	10	54	1836	2	flics
floc	9	59	2212	2	floc_
flocks	15	47	1353	2	flocks
flocky	18	46	842	2	flocky
flocs	10	55	1923	2	flocs
flunk	12	50	1438	2	flunk
frank	12	44	1751	2	frank
frock	14	53	1465	2	frock
fuck	13	49	2463	2	f_uck
glace	8	74	2015	2	glace
hack	13	51	3454	2	_hack
jack	17	52	2486	2	_jack
klick	10	53	1143	2	klick
knack	10	43	1104	2	knack
kyack	13	46	826	2	kyack
lac	5	101	5582	2	_lac_
lace	6	68	4847	2	_lace
lacks	11	61	2920	2	_lacks
lacs	6	69	4248	2	_lacs
lacy	9	58	2963	2	_lacy
lank	8	47	3445	2	_lank
lark	8	57	3386	2	_lark
lick	10	69	3507	2	_lick
lock	10	61	3436	2	_lock
luck	10	53	2982	2	_luck
mack	12	57	3365	2	_mack
pack	12	55	3544	2	_pack
place	9	48	2461	2	place
placks	14	44	1415	2	placks
plank	11	52	2114	2	plank
pluck	13	42	1230	2	pluck
quack	20	38	1250	2	quack
rack	10	62	3488	2	_rack
sack	10	53	3731	2	_sack
shack	14	53	2175	2	shack
slacks	12	44	1653	2	slacks
slank	9	58	2277	2	slank
slick	11	55	2052	2	slick
smack	13	46	1545	2	smack
snack	11	47	1806	2	snack
stack	11	44	2169	2	stack
tack	10	65	3629	2	_tack
thack	14	49	1517	2	thack
track	11	48	2301	2	track
wack	13	53	3091	2	_wack
whack	17	48	1302	2	whack
wrack	14	54	1388	2	wrack
yack	13	54	2597	2	_yack

Search took 2 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	53800	0.300	595636.7
2	DLD Change Limit	53800	112	1.606	33499.4
3	Display Results	112	112	0.033	3393.9
	(SQL Overall)	178691	112	1.939	92156.3