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

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

65 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
swapping	16	34	867	(None)
sapping	12	35	1931	1	s_apping
slapping	13	35	1083	1	slapping
snapping	13	34	965	1	snapping
swamping	16	30	792	1	swamping
swopping	16	37	796	1	swopping
wapping	15	35	1460	1	_wapping
capping	14	38	1967	2	_capping
chapping	18	37	1072	2	chapping
clapping	15	38	1060	2	clapping
crapping	15	39	1145	2	crapping
dapping	13	37	1479	2	_dapping
flapping	16	29	815	2	flapping
frapping	16	34	810	2	frapping
gapping	13	42	1478	2	_gapping
happing	15	38	1723	2	_happing
knapping	17	31	497	2	knapping
lapping	12	41	1702	2	_lapping
mapping	14	34	1399	2	_mapping
napping	12	35	1418	2	_napping
rapping	12	36	1910	2	_rapping
sapling	10	32	1786	2	s_apling
scalping	13	34	1045	2	scalping
scamping	15	35	1019	2	scamping
scaping	12	37	1569	2	sca_ping
scarping	13	33	1246	2	scarping
scrapping	16	3	574	2	scrapping
shaping	13	31	1618	2	sha_ping
sharping	14	30	1137	2	sharping
shipping	16	36	1125	2	shipping
shopping	16	36	1129	2	shopping
sipping	12	31	1743	2	s_ipping
skipping	17	29	760	2	skipping
slipping	13	35	1066	2	slipping
slopping	13	38	1142	2	slopping
snipping	13	30	885	2	snipping
soaping	10	36	1622	2	soa_ping
sopping	12	39	1720	2	s_opping
stamping	13	33	1096	2	stamping
stapling	11	28	1315	2	stapling
stepping	13	32	907	2	stepping
stopping	13	36	1141	2	stopping
strapping	14	3	699	2	strapping
supping	12	38	1453	2	s_upping
swabbing	16	24	645	2	swabbing
swagging	14	32	809	2	swagging
swaging	12	42	1063	2	swa_ging
swanking	16	39	996	2	swanking
swanning	12	33	881	2	swanning
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
sweeping	14	38	914	2	sweeping
swiping	13	31	982	2	sw_iping
swooping	14	33	840	2	swooping
tapping	12	33	1713	2	_tapping
trapping	13	29	1139	2	trapping
warping	13	37	1518	2	_warping
whapping	19	31	711	2	whapping
wrapping	16	29	762	2	wrapping
yapping	15	34	1261	2	_yapping
zapping	21	32	1147	2	_zapping

Search took 5 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	65	3.593	33693.0
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	4.015	44505.9