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

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

77 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
swanking	16	39	996	(None)
shanking	16	36	1228	1	shanking
skanking	12	28	874	1	skanking
spanking	15	39	1197	1	spanking
swanning	12	33	881	1	swanning
swinking	16	34	1032	1	swinking
wanking	15	42	1678	1	_wanking
awaking	15	4	781	2	awa_king
banking	14	46	2135	2	_banking
blanking	15	44	1193	2	blanking
clanking	15	43	1306	2	clanking
cranking	15	46	1307	2	cranking
flanking	16	42	1108	2	flanking
franking	16	43	1086	2	franking
hanking	15	46	1910	2	_hanking
planking	15	35	1301	2	planking
pranking	15	38	1338	2	pranking
ranking	12	43	2088	2	_ranking
sacking	14	41	2270	2	s_acking
sanding	9	35	2060	2	s_anding
saning	7	51	2764	2	s_an_ing
scanning	11	33	1077	2	scanning
scanting	11	39	1476	2	scanting
shacking	18	40	1408	2	shacking
shaking	15	33	1725	2	sha_king
sharking	16	39	1297	2	sharking
sinking	12	33	2054	2	s_inking
skinking	12	29	977	2	skinking
skunking	12	25	665	2	skunking
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
smacking	17	35	1076	2	smacking
snacking	15	34	1170	2	snacking
snaking	12	39	1530	2	sna_king
soaking	12	31	1661	2	soa_king
spankings	16	21	500	2	spankings
spanning	11	33	1108	2	spanning
sparking	15	28	1254	2	sparking
spunking	15	25	806	2	spunking
stacking	15	42	1508	2	stacking
staking	12	39	1980	2	sta_king
stalking	13	35	1222	2	stalking
standing	10	34	1363	2	standing
stanging	10	40	1365	2	stanging
staning	8	39	2224	2	stan_ing
stinking	13	31	1354	2	stinking
swabbing	16	24	645	2	swabbing
swagging	14	32	809	2	swagging
swaging	12	42	1063	2	swa_ging
swamping	16	30	792	2	swamping
swankier	15	22	550	2	swankier
swankily	18	3	383	2	swankily
swanskin	15	4	353	2	swanskin_
swanskins	16	4	328	2	swanskins
swapping	16	34	867	2	swapping
swarding	13	5	900	2	swarding
swarming	14	5	822	2	swarming
swashing	15	36	974	2	swashing
swathing	15	24	871	2	swathing
swatting	12	30	959	2	swatting
swaying	14	36	1064	2	swa_ying
swinging	13	34	1111	2	swinging
tanking	12	39	1879	2	_tanking
thanking	16	40	952	2	thanking
twanging	13	28	706	2	twanging
waking	14	48	2138	2	_wa_king
walking	15	40	1330	2	_walking
waning	10	36	2380	2	_wan_ing
wanning	11	38	1621	2	_wanning
wanting	11	42	2017	2	_wanting
warking	15	35	1957	2	_warking
wauking	15	34	1001	2	_wauking
winking	15	33	1796	2	_winking
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.390	458182.1
2	DLD Change Limit	121059	77	3.266	37066.4
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	3.686	48478.3