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

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

87 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
shipped	15	33	1210	(None)
chipped	17	41	1081	1	chipped
hipped	14	43	1769	1	_hipped
shippen	14	29	886	1	shippen
shipper	14	35	1404	1	shipper
shopped	15	35	1221	1	shopped
sipped	11	37	2063	1	s_ipped
skipped	16	35	841	1	skipped
slipped	12	47	1174	1	slipped
snipped	12	35	1004	1	snipped
whipped	18	37	933	1	whipped
blipped	14	37	719	2	blipped
chapped	17	27	1144	2	chapped
chipper	16	39	1258	2	chipper
chirped	15	37	978	2	chirped
chopped	17	45	1101	2	chopped
clipped	14	43	983	2	clipped
dipped	12	35	1749	2	_dipped
dripped	13	40	808	2	dripped
flipped	15	35	851	2	flipped
gipped	12	48	1590	2	_gipped
gripped	13	41	934	2	gripped
happed	14	48	2010	2	_happed
hipper	13	38	1802	2	_hipper
hopped	14	43	1811	2	_hopped
kipped	15	31	1457	2	_kipped
lipped	11	44	1954	2	_lipped
nipped	11	36	1585	2	_nipped
pipped	10	45	1654	2	_pipped
quipped	21	7	516	2	quipped
reshipped	17	5	389	2	reshipped
ripped	11	44	1901	2	_ripped
sapped	11	44	2201	2	s_apped
shaped	12	50	2010	2	sh_aped
sharped	13	41	1205	2	sharped
shied	9	61	2549	2	shi__ed
shifted	14	35	998	2	shifted
shilled	11	33	1362	2	shilled
shimmed	15	33	858	2	shimmed
shined	10	46	2078	2	shi_ned
shinned	11	43	1092	2	shinned
shipmen	14	31	728	2	shipmen
shippens	15	31	680	2	shippens
shippers	15	30	1231	2	shippers
shippon	14	28	580	2	shippon
shirked	15	37	1046	2	shirked
shirred	11	37	1050	2	shirred
shitted	11	42	1205	2	shitted
shlepped	16	3	364	2	shlepped
shoppe	13	31	1032	2	shoppe_
shopper	14	33	1263	2	shopper
shoppes	14	34	1140	2	shoppes
shrimped	16	3	421	2	shrimped
siped	8	49	2768	2	s_i_ped
sipper	10	39	2099	2	s_ipper
sippet	10	35	1939	2	s_ippet
skimped	16	25	622	2	skimped
skipper	15	33	957	2	skipper
skippet	15	28	846	2	skippet
slapped	12	35	1185	2	slapped
sliped	9	54	1706	2	sli_ped
slipper	11	37	1298	2	slipper
slopped	12	35	1144	2	slopped
snapped	12	46	1120	2	snapped
sniped	9	49	1348	2	sni_ped
snipper	11	39	1133	2	snipper
snippet	11	33	1043	2	snippet
sopped	11	48	1990	2	s_opped
stepped	12	32	1005	2	stepped
stiped	9	45	1707	2	sti_ped
stippled	13	4	530	2	stippled
stopped	12	45	1220	2	stopped
stripped	13	5	709	2	stripped
supped	11	44	1570	2	s_upped
swapped	15	42	914	2	swapped
swiped	12	38	1109	2	swi_ped
swopped	15	43	767	2	swopped
tipped	11	44	1826	2	_tipped
tripped	12	39	1169	2	tripped
unshipped	17	4	386	2	unshipped
whapped	18	36	757	2	whapped
whipper	17	36	1138	2	whipper
whippet	17	32	884	2	whippet
whopped	18	35	800	2	whopped
whupped	18	36	541	2	whupped
yipped	14	36	1328	2	_yipped
zipped	20	36	1298	2	_zipped

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	107671	0.423	422437.4
2	DLD Change Limit	107671	87	3.810	28260.1
3	Display Results	87	87	0.033	2636.4
	(SQL Overall)	178691	87	4.266	41887.2