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

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

72 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
flanking	16	42	1108	(None)
blanking	15	44	1193	1	blanking
clanking	15	43	1306	1	clanking
flacking	18	43	1179	1	flacking
flaking	15	41	1449	1	fla_king
flanging	13	27	1058	1	flanging
flunking	16	31	777	1	flunking
franking	16	43	1086	1	franking
planking	15	35	1301	1	planking
banking	14	46	2135	2	_banking
blacking	17	42	1360	2	blacking
blinking	15	35	1062	2	blinking
clacking	17	33	1349	2	clacking
clanging	12	40	1212	2	clanging
clinking	15	36	1166	2	clinking
clonking	15	38	1015	2	clonking
clunking	15	32	943	2	clunking
cranking	15	46	1307	2	cranking
faking	14	55	2098	2	f_a_king
fanning	11	36	1507	2	f_anning
finking	15	40	1660	2	f_inking
flagging	14	32	922	2	flagging
flailing	12	29	892	2	flailing
flaming	13	42	1644	2	fla_ming
flamming	16	35	715	2	flamming
flanken	14	22	676	2	flanken_
flapping	16	29	815	2	flapping
flaring	11	41	1680	2	fla_ring
flashing	15	37	1155	2	flashing
flatling	12	34	1001	2	flatling
flatting	12	35	1125	2	flatting
flaunting	13	3	504	2	flaunting
flawing	14	38	1256	2	fla_wing
flaying	14	39	1446	2	fla_ying
flecking	18	40	823	2	flecking
flensing	12	4	697	2	flensing
flicking	18	41	1004	2	flicking
flinging	13	33	1005	2	flinging
flinting	12	34	1234	2	flinting
flocking	18	34	1087	2	flocking
fluking	15	44	1051	2	fl_uking
funking	15	40	1302	2	f_unking
glancing	12	4	706	2	glancing
hanking	15	46	1910	2	_hanking
lacking	14	38	2154	2	_lacking
laking	11	50	2704	2	_la_king
lancing	10	33	1412	2	_lancing
landing	9	28	1932	2	_landing
larking	12	37	1825	2	_larking
linking	12	38	1825	2	_linking
planing	10	34	1825	2	plan_ing
plankings	16	32	611	2	plankings
planning	11	36	1022	2	planning
planting	11	35	1538	2	planting
plinking	15	36	1124	2	plinking
plonking	15	35	856	2	plonking
plunking	15	32	848	2	plunking
pranking	15	38	1338	2	pranking
ranking	12	43	2088	2	_ranking
shanking	16	36	1228	2	shanking
skanking	12	28	874	2	skanking
slacking	15	39	1413	2	slacking
slaking	12	37	1747	2	sla_king
slanging	10	34	1343	2	slanging
slanting	9	41	1509	2	slanting
slinking	13	34	1298	2	slinking
spanking	15	39	1197	2	spanking
swanking	16	39	996	2	swanking
tanking	12	39	1879	2	_tanking
thanking	16	40	952	2	thanking
wanking	15	42	1678	2	_wanking
yanking	15	45	1246	2	_yanking

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.406	440125.6
2	DLD Change Limit	121059	72	3.143	38517.0
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	3.579	49927.6