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

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

70 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
flakey	16	44	1051	(None)
fakey	15	55	1542	1	f_akey
flake	12	51	1997	1	flake_
flaked	14	47	1565	1	flaked
flaker	13	49	1617	1	flaker
flakes	13	41	1887	1	flakes
flaky	15	57	1558	1	flak_y
flukey	16	45	981	1	flukey
cakey	14	55	1727	2	_cakey
clayey	14	40	766	2	clayey
fake	11	55	3494	2	f_ake_
faked	13	52	2548	2	f_aked
faker	12	48	2459	2	f_aker
fakery	16	50	926	2	f_akery
fakes	12	60	3248	2	f_akes
flabby	16	3	457	2	flabby
flacked	17	37	1158	2	flacked
flackery	20	29	524	2	flackery
flaggy	14	41	592	2	flaggy
flak	11	60	2617	2	flak__
flakers	14	36	1327	2	flakers
flakier	14	39	1020	2	flakier
flakily	17	3	629	2	flakily
flame	10	51	2444	2	flame_
flamed	12	46	1897	2	flamed
flamen	11	52	1599	2	flamen
flamer	11	49	1912	2	flamer
flames	11	47	2369	2	flames
flamy	13	52	1747	2	fla_my
flanes	9	45	2242	2	flanes
flanked	15	37	1064	2	flanked
flanken	14	22	676	2	flanken
flanker	14	39	1129	2	flanker
flappy	16	5	448	2	flappy
flare	8	48	2363	2	flare_
flared	10	53	1760	2	flared
flares	9	45	2170	2	flares
flashy	15	49	817	2	flashy
flasket	14	3	973	2	flasket
flatly	12	31	1021	2	flatly
flawed	13	47	1272	2	flawed
flawy	14	59	1338	2	fla_wy
flaxen	16	51	857	2	flaxen
flaxes	16	50	1535	2	flaxes
flaxy	18	90	1229	2	fla_xy
flay	10	63	3280	2	fla__y
flayed	13	44	1405	2	flayed
flayer	12	47	1356	2	flayer
fley	10	66	2685	2	fl__ey
flooey	12	39	1017	2	flooey
fluke	12	50	1689	2	fluke_
fluked	14	51	1209	2	fluked
flukes	13	51	1419	2	flukes
fluky	15	45	1229	2	fluk_y
flunkey	17	40	579	2	flunkey
flutey	12	52	1252	2	flutey
lacey	10	58	2091	2	_lacey
lackey	15	48	1335	2	_lackey
lake	8	57	4160	2	_lake_
laked	10	57	3112	2	_laked
laker	9	54	3287	2	_laker
lakes	9	57	3765	2	_lakes
laky	11	67	2582	2	_lak_y
slake	9	37	2405	2	slake_
slaked	11	43	1827	2	slaked
slaker	10	42	1927	2	slaker
slakes	10	40	2188	2	slakes
slatey	9	54	1706	2	slatey
slavey	12	40	1180	2	slavey
snakey	13	50	1127	2	snakey

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	70	2.483	33246.5
3	Display Results	70	70	0.033	2121.2
	(SQL Overall)	178691	70	2.626	68046.8