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

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

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

163 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
flickery	20	36	510	(None)
flackery	20	29	524	1	flackery
flicker	16	36	1062	1	flicker_
flickers	17	33	888	1	flickers
clicker	15	41	1188	2	clicker_
clickers	16	39	1020	2	clickers
flicked	17	46	1067	2	flicke_d
flickered	19	4	375	2	flickered
licker	12	52	2204	2	_licker_
lickers	13	41	1825	2	_lickers
slicker	13	33	1453	2	slicker_
slickers	14	31	1255	2	slickers
snickery	17	29	554	2	snickery
trickery	17	29	734	2	trickery
bicker	14	48	1917	3	_bicker_
bickers	15	43	1655	3	_bickers
blacker	15	45	1351	3	blacker_
blinker	13	41	1021	3	blinker_
blinkers	14	38	850	3	blinkers
blistery	13	41	871	3	blistery
blocker	15	41	992	3	blocker_
blockers	16	39	879	3	blockers
chickory	22	4	336	3	chickory
clacker	15	38	1377	3	clacker_
clackers	16	39	1170	3	clackers
clicked	16	41	1245	3	clicke_d
clinker	13	38	1166	3	clinker_
clinkers	14	33	983	3	clinkers
clocker	15	39	1087	3	clocker_
clockers	16	36	981	3	clockers
crickey	18	41	814	3	cricke_y
crockery	19	35	660	3	crockery
dicker	13	45	2140	3	_dicker_
dickers	14	41	1766	3	_dickers
dickey	16	59	1352	3	_dicke_y
fakery	16	50	926	3	f__akery
fickler	16	34	842	3	f_ickler_
fickly	18	31	853	3	f_ick_ly
fiery	11	47	1479	3	f_i__ery
filcher	15	37	779	3	filcher_
filchers	16	28	686	3	filchers
finery	12	45	1289	3	f_i_nery
fishery	16	39	773	3	f_ishery
flacked	17	37	1158	3	flacke_d
flaker	13	49	1617	3	fl_aker_
flakers	14	36	1327	3	fl_akers
flakey	16	44	1051	3	fl_ake_y
flanker	14	39	1129	3	flanker_
flankers	15	34	930	3	flankers
flattery	14	33	829	3	flattery
flecked	17	35	807	3	flecke_d
flecky	18	38	765	3	fleck__y
flichter	16	6	496	3	flichter_
flichters	17	7	417	3	flichters
flick	14	50	1721	3	flick___
flickering	20	4	409	3	flickering
flicking	18	41	1004	3	flicking
flicks	15	45	1299	3	flick__s
flier	8	60	2340	3	fli__er_
fliers	9	44	1719	3	fli__ers
flincher	16	25	658	3	flincher_
flinchers	17	29	547	3	flinchers
flinder	11	31	987	3	flinder_
flinders	12	43	926	3	flinders
flinger	11	37	1051	3	flinger_
flingers	12	34	1019	3	flingers
flipper	14	38	914	3	flipper_
flippers	15	33	800	3	flippers
flirter	10	31	867	3	flirter_
flirters	11	33	793	3	flirters
flitter	10	34	1390	3	flitter_
flitters	11	43	1217	3	flitters
flivver	16	3	304	3	flivver_
flivvers	17	3	311	3	flivvers
flocked	17	45	1025	3	flocke_d
flockier	17	4	534	3	flockier_
flocky	18	46	842	3	flock__y
flowery	16	32	778	3	fl_owery
flukey	16	45	981	3	fl_uke_y
flummery	18	3	305	3	flummery
flunker	14	38	936	3	flunker_
flunkers	15	34	753	3	flunkers
flunkey	17	40	579	3	flunke_y
fluttery	14	37	614	3	fluttery
frippery	18	3	295	3	frippery
frisker	14	38	927	3	frisker_
friskers	15	33	737	3	friskers
frolicker	18	4	239	3	frolicker_
frolickers	19	4	203	3	frolickers
fucker	15	34	1442	3	f_ucker_
fuckers	16	36	1159	3	f_uckers
glittery	12	37	561	3	glittery
hickey	18	50	1199	3	_hicke_y
hickory	19	4	390	3	_hickory
icker	11	40	1844	3	__icker_
ickers	12	39	1418	3	__ickers
kicker	11	41	1618	3	_kicker_
kickers	12	40	1329	3	_kickers
knackery	16	28	366	3	knackery
knickers	13	30	672	3	knickers
lacker	12	53	2562	3	_lacker_
lackers	13	41	2054	3	_lackers
lackey	15	48	1335	3	_lacke_y
lechery	15	25	764	3	_lechery
licked	13	46	2156	3	_licke_d
likely	13	32	813	3	_li_kely
liker	9	56	2706	3	_li_ker_
likers	10	46	2091	3	_li_kers
linker	10	43	2147	3	_linker_
linkers	11	43	1771	3	_linkers
littery	10	37	1049	3	_littery
livery	12	49	1090	3	_li_very
locker	12	40	1942	3	_locker_
lockers	13	35	1692	3	_lockers
mickey	17	42	1185	3	_micke_y
mockery	18	37	691	3	_mockery
nicker	12	38	1870	3	_nicker_
nickers	13	44	1509	3	_nickers
picker	14	44	2217	3	_picker_
pickers	15	37	1809	3	_pickers
plinker	13	40	1096	3	plinker_
plinkers	14	30	939	3	plinkers
plucker	15	36	824	3	plucker_
pluckers	16	31	655	3	pluckers
pricker	15	40	1341	3	pricker_
prickers	16	37	1067	3	prickers
puckery	18	30	626	3	_puckery
quackery	26	3	311	3	quackery
quicker	22	4	702	3	quicker_
rickety	16	47	831	3	_rickety
rickey	15	46	1397	3	_ricke_y
rockery	16	43	925	3	_rockery
shicker	16	39	1482	3	shicker_
shickers	17	30	1282	3	shickers
sicker	12	40	2390	3	_sicker_
sickerly	17	3	403	3	_sickerly
slacker	13	39	1529	3	slacker_
slackers	14	38	1274	3	slackers
slicer	8	41	1760	3	slic_er_
slicers	9	41	1492	3	slic_ers
slicked	14	44	1384	3	slicke_d
slicken	13	30	929	3	slicke_n
slickens	14	31	726	3	slickens
slickest	14	22	925	3	slickest
slickly	16	3	585	3	slick_ly
slippery	15	27	586	3	slippery
slithery	14	35	670	3	slithery
snicker	13	30	1267	3	snicker_
snickers	14	30	1096	3	snickers
spicery	14	49	901	3	spic_ery
sticker	13	35	1588	3	sticker_
stickers	14	29	1303	3	stickers
thicker	16	36	1102	3	thicker_
thickety	20	27	410	3	thickety
ticker	12	43	2150	3	_ticker_
tickers	13	36	1772	3	_tickers
tricker	13	46	1552	3	tricker_
trickers	14	38	1281	3	trickers
whicker	19	35	977	3	whicker_
whickers	20	29	798	3	whickers
whiskery	21	31	455	3	whiskery
wicker	15	45	1867	3	_wicker_
wickers	16	41	1470	3	_wickers

Search took 8 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	146162	0.423	422437.4
2	DLD Change Limit	146162	163	7.126	20511.1
3	Display Results	163	163	0.060	2716.7
	(SQL Overall)	178691	163	7.609	23484.2