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

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

71 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
flankers	15	34	930	(None)
flakers	14	36	1327	1	fla_kers
flangers	12	33	1137	1	flangers
flanker	14	39	1129	1	flanker_
flunkers	15	34	753	1	flunkers
frankers	15	34	835	1	frankers
bankers	13	39	1909	2	_bankers
blanker	13	46	1202	2	blanker_
blankets	14	35	650	2	blankets
blinkers	14	38	850	2	blinkers
cankers	13	44	1875	2	_cankers
clackers	16	39	1170	2	clackers
clangers	11	43	1234	2	clangers
clinkers	14	33	983	2	clinkers
clunkers	14	32	755	2	clunkers
fakers	13	42	1953	2	f_a_kers
fanners	10	39	1465	2	f_anners
flackery	20	29	524	2	flackery
flaggers	13	32	807	2	flaggers
flaker	13	49	1617	2	fla_ker_
flakes	13	41	1887	2	fla_ke_s
flamers	12	46	1636	2	fla_mers
flanes	9	45	2242	2	flan_e_s
flaneurs	11	3	395	2	flaneurs
flanger	11	34	1262	2	flanger_
flanges	11	34	1327	2	flange_s
flanked	15	37	1064	2	flanke_d
flanken	14	22	676	2	flanke_n
flanks	13	39	1340	2	flank__s
flannels	11	3	484	2	flannels
flappers	15	38	838	2	flappers
flashers	14	39	1265	2	flashers
flaskets	15	3	460	2	flaskets
flatters	11	38	1420	2	flatters
flaunters	12	3	451	2	flaunters
flayers	13	39	1203	2	fla_yers
flensers	11	3	546	2	flensers
flickers	17	33	888	2	flickers
flinders	12	43	926	2	flinders
flingers	12	34	1019	2	flingers
flunker	14	38	936	2	flunker_
flunkeys	18	26	317	2	flunkeys
franker	14	35	1018	2	franker_
funkers	14	37	1206	2	f_unkers
glancers	11	40	800	2	glancers
glanders	10	38	1150	2	glanders
hankers	14	42	1813	2	_hankers
lackers	13	41	2054	2	_lackers
lakers	10	52	2515	2	_la_kers
lancers	9	36	1664	2	_lancers
landers	8	40	2621	2	_landers
lanker	10	41	2300	2	_lanker_
lanners	7	36	1833	2	_lanners
larkers	11	30	1451	2	_larkers
linkers	11	43	1771	2	_linkers
lunkers	11	34	1460	2	_lunkers
planers	9	45	1794	2	plan_ers
plankters	15	4	458	2	plankters
planners	10	39	993	2	planners
planters	10	29	1532	2	planters
plinkers	14	30	939	2	plinkers
plunkers	14	32	833	2	plunkers
rankers	11	32	1746	2	_rankers
skankers	11	31	648	2	skankers
slackers	14	38	1274	2	slackers
slakers	11	41	1575	2	sla_kers
slanders	9	40	1401	2	slanders
spankers	14	36	986	2	spankers
tankers	11	34	1691	2	_tankers
thankers	15	29	783	2	thankers
wankers	14	45	1471	2	_wankers

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	121059	0.143	1249587.4
2	DLD Change Limit	121059	71	3.563	33976.7
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	3.736	47829.5