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

Here are the results of your fuzzy-string dictionary search for “flicker” 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
flicker	16	36	1062	(None)
clicker	15	41	1188	1	clicker
flicked	17	46	1067	1	flicked
flickers	17	33	888	1	flickers
flickery	20	36	510	1	flickery
licker	12	52	2204	1	_licker
slicker	13	33	1453	1	slicker
bicker	14	48	1917	2	_bicker
blacker	15	45	1351	2	blacker
blinker	13	41	1021	2	blinker
blocker	15	41	992	2	blocker
clacker	15	38	1377	2	clacker
clicked	16	41	1245	2	clicked
clickers	16	39	1020	2	clickers
clinker	13	38	1166	2	clinker
clocker	15	39	1087	2	clocker
dicker	13	45	2140	2	_dicker
fickler	16	34	842	2	f_ickler
filcher	15	37	779	2	filcher
flacked	17	37	1158	2	flacked
flackery	20	29	524	2	flackery
flaker	13	49	1617	2	fl_aker
flanker	14	39	1129	2	flanker
flecked	17	35	807	2	flecked
flichter	16	6	496	2	flichter
flick	14	50	1721	2	flick__
flickered	19	4	375	2	flickered
flicks	15	45	1299	2	flick_s
flier	8	60	2340	2	fli__er
flincher	16	25	658	2	flincher
flinder	11	31	987	2	flinder
flinger	11	37	1051	2	flinger
flipper	14	38	914	2	flipper
flirter	10	31	867	2	flirter
flitter	10	34	1390	2	flitter
flivver	16	3	304	2	flivver
flocked	17	45	1025	2	flocked
flockier	17	4	534	2	flockier
flunker	14	38	936	2	flunker
frisker	14	38	927	2	frisker
frolicker	18	4	239	2	frolicker
fucker	15	34	1442	2	f_ucker
icker	11	40	1844	2	__icker
kicker	11	41	1618	2	_kicker
lacker	12	53	2562	2	_lacker
licked	13	46	2156	2	_licked
lickers	13	41	1825	2	_lickers
liker	9	56	2706	2	_li_ker
linker	10	43	2147	2	_linker
locker	12	40	1942	2	_locker
nicker	12	38	1870	2	_nicker
picker	14	44	2217	2	_picker
plinker	13	40	1096	2	plinker
plucker	15	36	824	2	plucker
pricker	15	40	1341	2	pricker
quicker	22	4	702	2	quicker
shicker	16	39	1482	2	shicker
sicker	12	40	2390	2	_sicker
slacker	13	39	1529	2	slacker
slicer	8	41	1760	2	slic_er
slicked	14	44	1384	2	slicked
slicken	13	30	929	2	slicken
slickers	14	31	1255	2	slickers
snicker	13	30	1267	2	snicker
sticker	13	35	1588	2	sticker
thicker	16	36	1102	2	thicker
ticker	12	43	2150	2	_ticker
tricker	13	46	1552	2	tricker
whicker	19	35	977	2	whicker
wicker	15	45	1867	2	_wicker

Search took 4 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	107671	0.186	960704.3
2	DLD Change Limit	107671	70	3.376	31893.1
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	3.592	49746.9