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

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

88 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
flask	12	55	1242	(None)
flack	14	45	1941	1	flack
flak	11	60	2617	1	fla_k
flank	12	46	1809	1	flank
flash	11	57	1621	1	flash
flasks	13	48	867	1	flasks
alack	11	48	2006	2	alack
alas	4	63	5812	2	alas_
alaska	10	3	671	2	alaska
ask	7	71	3070	2	__ask
bask	10	51	3142	2	_bask
black	13	47	1907	2	black
blank	11	54	1855	2	blank
blase	7	55	2423	2	blase
blast	7	65	3257	2	blast
cask	10	56	2643	2	_cask
clack	13	47	2017	2	clack
clank	11	47	1952	2	clank
clash	10	62	1903	2	clash
clasp	9	55	1719	2	clasp
class	7	55	2548	2	class
clast	7	60	3058	2	clast
false	8	48	1812	2	false
fas	6	82	6293	2	f_as_
fash	10	72	3229	2	f_ash
fast	7	70	5231	2	f_ast
fease	8	48	2487	2	fease
feast	8	59	3272	2	feast
flab	9	66	2835	2	fla_b
flabs	10	58	1864	2	flabs
flacks	15	41	1453	2	flacks
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
flashy	15	49	817	2	flashy
flasket	14	3	973	2	flasket
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
fleas	8	64	2366	2	fleas_
fleck	14	82	1359	2	fleck
flesh	11	50	1374	2	flesh
flick	14	50	1721	2	flick
flock	14	47	1742	2	flock
floss	8	51	1826	2	floss
flunk	12	50	1438	2	flunk
flus	7	56	2654	2	flus_
flush	11	51	1607	2	flush
frank	12	44	1751	2	frank
frass	8	53	2112	2	frass
frisk	12	53	1237	2	frisk
glass	6	55	1813	2	glass
lack	10	58	3768	2	_lack
lank	8	47	3445	2	_lank
lark	8	57	3386	2	_lark
las	3	72	8147	2	_las_
lase	4	61	4851	2	_lase
lash	7	65	3965	2	_lash
lass	4	74	4454	2	_lass
last	4	62	6032	2	_last
mask	10	52	2736	2	_mask
plack	13	50	1784	2	plack
plank	11	52	2114	2	plank
plash	10	46	1656	2	plash
plasm	9	41	1463	2	plasm
slack	11	50	2176	2	slack
slank	9	58	2277	2	slank
slash	8	47	1968	2	slash
task	8	53	2665	2	_task

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.076	2351197.4
2	DLD Change Limit	53800	88	1.643	32745.0
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	1.749	102167.5