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

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

93 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
flanker	14	39	1129	(None)
blanker	13	46	1202	1	blanker
flaker	13	49	1617	1	fla_ker
flanger	11	34	1262	1	flanger
flanked	15	37	1064	1	flanked
flanken	14	22	676	1	flanken
flankers	15	34	930	1	flankers
flunker	14	38	936	1	flunker
franker	14	35	1018	1	franker
lanker	10	41	2300	1	_lanker
banker	12	42	2273	2	_banker
blacker	15	45	1351	2	blacker
blander	10	37	1516	2	blander
blanked	14	40	1122	2	blanked
blanket	13	43	1309	2	blanket
blinker	13	41	1021	2	blinker
canker	12	44	2252	2	_canker
clacker	15	38	1377	2	clacker
clanger	10	41	1349	2	clanger
clanked	14	38	1225	2	clanked
clankier	14	32	708	2	clankier
clinker	13	38	1166	2	clinker
clunker	13	41	945	2	clunker
cranker	13	36	1278	2	cranker
danker	11	43	1966	2	_danker
faker	12	48	2459	2	f_a_ker
fanner	9	42	1818	2	f_anner
flacked	17	37	1158	2	flacked
flackery	20	29	524	2	flackery
flagger	12	46	935	2	flagger
flake	12	51	1997	2	fla_ke_
flaked	14	47	1565	2	fla_ked
flakers	14	36	1327	2	fla_kers
flakes	13	41	1887	2	fla_kes
flakey	16	44	1051	2	fla_key
flakier	14	39	1020	2	flakier
flamer	11	49	1912	2	fla_mer
flamier	12	31	1214	2	flamier
flanes	9	45	2242	2	flan_es
flaneur	10	3	418	2	flaneur
flange	10	34	1197	2	flange_
flanged	12	38	1084	2	flanged
flangers	12	33	1137	2	flangers
flanges	11	34	1327	2	flanges
flank	12	46	1809	2	flank__
flanks	13	39	1340	2	flank_s
flannel	10	3	542	2	flannel
flapper	14	35	920	2	flapper
flasher	13	39	1406	2	flasher
flasket	14	3	973	2	flasket
flatter	10	38	1596	2	flatter
flaunter	11	3	501	2	flaunter
flawier	13	37	873	2	flawier
flaxier	17	33	798	2	flaxier
flayer	12	47	1356	2	fla_yer
flenser	10	3	678	2	flenser
flicker	16	36	1062	2	flicker
flinder	11	31	987	2	flinder
flinger	11	37	1051	2	flinger
flunked	15	39	841	2	flunked
flunkers	15	34	753	2	flunkers
flunkey	17	40	579	2	flunkey
franked	15	36	1005	2	franked
frankers	15	34	835	2	frankers
funker	13	39	1576	2	f_unker
glancer	10	37	1007	2	glancer
hanker	13	46	2209	2	_hanker
lacker	12	53	2562	2	_lacker
laker	9	54	3287	2	_la_ker
lancer	8	43	1997	2	_lancer
lander	7	40	2848	2	_lander
lankier	11	37	1163	2	_lankier
lanner	6	49	2060	2	_lanner
larker	10	45	1924	2	_larker
linker	10	43	2147	2	_linker
lunker	10	47	1834	2	_lunker
planer	8	41	2265	2	plan_er
planked	14	35	1228	2	planked
plankter	14	3	536	2	plankter
planner	9	35	1162	2	planner
planter	9	40	1780	2	planter
plinker	13	40	1096	2	plinker
plunker	13	39	1064	2	plunker
ranker	10	50	2190	2	_ranker
skanker	10	26	848	2	skanker
slacker	13	39	1529	2	slacker
slaker	10	42	1927	2	sla_ker
slander	8	40	1544	2	slander
spanker	13	36	1235	2	spanker
swanker	14	36	948	2	swanker
tanker	10	45	2112	2	_tanker
thanker	14	30	959	2	thanker
wanker	13	42	1997	2	_wanker

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.140	1276364.3
2	DLD Change Limit	107671	93	3.406	31612.2
3	Display Results	93	93	0.030	3100.0
	(SQL Overall)	178691	93	3.576	49969.5