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

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

82 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
snapped	12	46	1120	(None)
knapped	16	39	710	1	knapped
napped	11	42	1816	1	_napped
sapped	11	44	2201	1	s_apped
slapped	12	35	1185	1	slapped
snapper	11	35	1207	1	snapper
snipped	12	35	1004	1	snipped
swapped	15	42	914	1	swapped
capped	13	47	2185	2	_capped
chapped	17	27	1144	2	chapped
clapped	14	35	1117	2	clapped
crapped	14	39	1263	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
knapper	15	38	715	2	knapper
knopped	16	35	545	2	knopped
lapped	11	43	2003	2	_lapped
mapped	13	40	1588	2	_mapped
nappe	9	61	1499	2	_nappe_
napper	10	37	1828	2	_napper
nappes	10	45	1562	2	_nappes
nipped	11	36	1585	2	_nipped
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	654	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	1247	2	slapper
slipped	12	47	1174	2	slipped
slopped	12	35	1144	2	slopped
snacked	14	40	1311	2	snacked
snafued	11	3	493	2	snafued
snagged	10	40	1067	2	snagged
snailed	8	38	1192	2	snailed
snaked	11	50	1759	2	sna_ked
snappers	12	35	1017	2	snappers
snappier	12	6	622	2	snappier
snappy	13	6	610	2	snapp_y
snapweed	14	4	345	2	snapweed
snared	7	48	2455	2	sna_red
snarfed	11	37	875	2	snarfed
snarled	8	36	1236	2	snarled
snawed	10	48	1373	2	sna_wed
sneaped	10	33	881	2	sneaped
sniped	9	49	1348	2	sn_iped
snipper	11	39	1133	2	snipper
snippet	11	33	1043	2	snippet
snooped	10	37	1181	2	snooped
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
swamped	15	49	844	2	swamped
swapper	14	35	970	2	swapper
swopped	15	43	767	2	swopped
synapsed	14	4	313	2	synapsed
tapped	11	38	2005	2	_tapped
trapped	12	45	1221	2	trapped
uncapped	15	5	669	2	uncapped
unmapped	15	3	517	2	unmapped
unsnapped	14	4	398	2	unsnapped
untapped	13	7	661	2	untapped
wapped	14	44	1647	2	_wapped
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 6 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.423	422437.4
2	DLD Change Limit	107671	82	5.310	20277.0
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	5.766	30990.5