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

Here are the results of your fuzzy-string dictionary search for “swapped” 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
swapped	15	42	914	(None)
sapped	11	44	2201	1	s_apped
slapped	12	35	1184	1	slapped
snapped	12	46	1120	1	snapped
swamped	15	49	844	1	swamped
swapper	14	35	970	1	swapper
swopped	15	43	767	1	swopped
wapped	14	44	1647	1	_wapped
capped	13	47	2185	2	_capped
chapped	17	27	1144	2	chapped
clapped	14	35	1117	2	clapped
crapped	14	39	1262	2	crapped
dapped	12	45	1676	2	_dapped
flapped	15	32	825	2	flapped
frapped	15	31	885	2	frapped
gapped	12	42	1712	2	_gapped
happed	14	48	2010	2	_happed
knapped	16	39	710	2	knapped
lapped	11	43	2003	2	_lapped
mapped	13	40	1588	2	_mapped
napped	11	42	1816	2	_napped
rapped	11	41	2268	2	_rapped
sapper	10	38	2235	2	s_apper
scalped	12	44	1199	2	scalped
scamped	14	47	1196	2	scamped
scaped	11	55	1955	2	sca_ped
scarped	12	43	1440	2	scarped
scrapped	15	5	653	2	scrapped
shaped	12	50	2010	2	sha_ped
sharped	13	41	1205	2	sharped
shipped	15	33	1210	2	shipped
shopped	15	35	1221	2	shopped
sipped	11	37	2063	2	s_ipped
skipped	16	35	841	2	skipped
slapper	11	35	1246	2	slapper
slipped	12	47	1174	2	slipped
slopped	12	35	1144	2	slopped
snapper	11	35	1207	2	snapper
snipped	12	35	1004	2	snipped
soaped	9	58	1797	2	soa_ped
sopped	11	48	1990	2	s_opped
stamped	12	48	1281	2	stamped
stapled	10	36	1370	2	stapled
stepped	12	32	1005	2	stepped
stopped	12	45	1220	2	stopped
strapped	13	5	782	2	strapped
supped	11	44	1570	2	s_upped
swabbed	15	36	740	2	swabbed
swacked	17	31	1052	2	swacked
swaged	11	42	1225	2	swa_ged
swagged	13	41	915	2	swagged
swamper	14	34	931	2	swamper
swanked	15	35	954	2	swanked
swanned	11	35	817	2	swanned
swappers	15	35	808	2	swappers
swarded	12	3	815	2	swarded
swarmed	13	6	748	2	swarmed
swashed	14	43	1136	2	swashed
swathed	14	46	1193	2	swathed
swatted	11	41	1069	2	swatted
swayed	13	35	1026	2	swa_yed
swiped	12	38	1109	2	sw_iped
swooped	13	41	875	2	swooped
tapped	11	38	2005	2	_tapped
trapped	12	45	1221	2	trapped
warped	12	48	1641	2	_warped
whapped	18	36	757	2	whapped
wrapped	15	33	802	2	wrapped
yapped	14	44	1514	2	_yapped
zapped	20	42	1352	2	_zapped

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	107671	0.373	479064.3
2	DLD Change Limit	107671	70	3.033	35499.8
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	3.436	52005.5