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

Here are the results of your fuzzy-string dictionary search for “swarming” 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
swarming	14	5	822	(None)
swarding	13	5	900	1	swarding
warming	13	35	1508	1	_warming
alarming	11	3	858	2	alarming
arming	9	47	1980	2	__arming
awarding	13	5	604	2	awarding
beswarming	18	4	327	2	beswarming
charming	16	30	1203	2	charming
dwarfing	16	3	361	2	dwarfing
farming	13	35	1508	2	_farming
harming	13	37	1793	2	_harming
inarming	11	3	834	2	inarming
pharming	16	24	814	2	pharming
rearming	11	14	1361	2	rearming
rewarming	15	14	738	2	rewarming
scamming	15	32	854	2	scamming
scarfing	14	30	971	2	scarfing
scaring	10	34	2197	2	scar_ing
scarping	13	33	1246	2	scarping
scarring	11	25	1151	2	scarring
scarting	11	34	1526	2	scarting
seaming	10	32	2211	2	sea_ming
searing	8	33	3092	2	sear_ing
shaming	13	30	1674	2	sha_ming
shamming	16	28	941	2	shamming
sharing	11	37	2324	2	shar_ing
sharking	16	39	1297	2	sharking
sharping	14	30	1137	2	sharping
slamming	13	33	1000	2	slamming
smarting	11	32	1245	2	smarting
snarfing	12	35	866	2	snarfing
snaring	8	39	2095	2	snar_ing
snarling	9	25	1318	2	snarling
soaring	8	35	2189	2	soar_ing
spamming	15	31	760	2	spamming
sparging	12	26	1113	2	sparging
sparing	10	48	2387	2	spar_ing
sparking	15	28	1254	2	sparking
sparling	11	27	1453	2	sparling
sparring	11	31	1222	2	sparring
spasming	13	22	720	2	spasming
staring	8	45	2705	2	star_ing
starling	9	30	1712	2	starling
starring	9	23	1295	2	starring
starting	9	31	1617	2	starting
starving	12	25	1017	2	starving
storming	11	20	942	2	storming
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
swanking	16	39	996	2	swanking
swanning	12	33	881	2	swanning
swapping	16	34	867	2	swapping
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
swearing	12	37	1144	2	swear_ing
swerving	15	4	611	2	swerving
swimming	16	31	632	2	swimming
swirling	12	24	914	2	swirling
unarming	11	3	862	2	unarming
warding	12	39	1814	2	_warding
waring	10	50	2944	2	_war_ing
warking	15	35	1957	2	_warking
warning	11	37	1709	2	_warning
warping	13	37	1518	2	_warping
warring	11	37	1797	2	_warring
worming	13	28	1124	2	_worming

Search took 9 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.783	228213.3
2	DLD Change Limit	121059	70	7.966	15197.0
3	Display Results	70	70	0.046	1521.7
	(SQL Overall)	178691	70	8.795	20317.3