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

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

89 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
shipper	14	35	1404	(None)
chipper	16	39	1258	1	chipper
hipper	13	38	1802	1	_hipper
shipped	15	33	1210	1	shipped
shippen	14	29	886	1	shippen
shippers	15	30	1231	1	shippers
shopper	14	33	1263	1	shopper
sipper	10	39	2099	1	s_ipper
skipper	15	33	957	1	skipper
slipper	11	37	1298	1	slipper
snipper	11	39	1133	1	snipper
whipper	17	36	1138	1	whipper
chipped	17	41	1081	2	chipped
chippers	17	35	1088	2	chippers
chippier	17	29	767	2	chippier
chirper	14	35	996	2	chirper
chopper	16	36	1189	2	chopper
clipper	13	37	1032	2	clipper
dipper	11	40	1779	2	_dipper
dripper	12	34	923	2	dripper
flipper	14	38	914	2	flipper
gipper	11	42	1530	2	_gipper
gripper	12	44	1071	2	gripper
hepper	13	34	1266	2	_hepper
hipped	14	43	1769	2	_hipped
hippier	14	32	1210	2	_hippier
hopper	13	42	1848	2	_hopper
kipper	14	34	1421	2	_kipper
lipper	10	42	1963	2	_lipper
nipper	10	37	1571	2	_nipper
quipper	20	9	582	2	quipper
reshipper	16	4	362	2	reshipper
ripper	10	35	1865	2	_ripper
sapper	10	38	2235	2	s_apper
scupper	13	6	742	2	scupper
shaper	11	41	1993	2	sh_aper
sharper	12	43	1270	2	sharper
shicker	16	39	1482	2	shicker
shier	8	54	2894	2	shi__er
shifter	13	29	1108	2	shifter
shikker	13	27	702	2	shikker
shimmer	14	33	1087	2	shimmer
shiner	9	38	2087	2	shi_ner
shinier	10	41	1314	2	shinier
shipmen	14	31	728	2	shipmen
shippens	15	31	680	2	shippens
shippon	14	28	580	2	shippon
shirker	14	37	1134	2	shirker
shiver	12	45	1737	2	shi_ver
shoppe	13	31	1032	2	shoppe_
shopped	15	35	1221	2	shopped
shoppers	15	30	1076	2	shoppers
shoppes	14	34	1139	2	shoppes
shrimper	15	4	441	2	shrimper
simper	10	36	1629	2	s_imper
sipped	11	37	2063	2	s_ipped
sippers	11	31	1775	2	s_ippers
sippet	10	35	1939	2	s_ippet
skipped	16	35	841	2	skipped
skippers	16	31	820	2	skippers
skippet	15	28	846	2	skippet
slapper	11	35	1246	2	slapper
slipped	12	47	1174	2	slipped
slippers	12	37	1123	2	slippers
slippery	15	27	586	2	slippery
slippier	12	5	653	2	slippier
snapper	11	35	1207	2	snapper
sniper	8	44	1364	2	sni_per
snipped	12	35	1004	2	snipped
snippers	12	29	972	2	snippers
snippet	11	33	1043	2	snippet
snippier	12	5	579	2	snippier
stepper	11	30	1085	2	stepper
stippler	12	3	554	2	stippler
stopper	11	30	1260	2	stopper
stripper	12	4	712	2	stripper
supper	10	41	1543	2	s_upper
swapper	14	35	970	2	swapper
tipper	10	39	1841	2	_tipper
tripper	11	37	1192	2	tripper
whapper	17	34	827	2	whapper
whimper	17	29	772	2	whimper
whipped	18	37	933	2	whipped
whippers	18	32	904	2	whippers
whippet	17	32	884	2	whippet
whippier	18	26	582	2	whippier
whisper	15	29	801	2	whisper
whopper	17	32	850	2	whopper
zipper	19	38	1312	2	_zipper

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	89	2.906	37051.3
3	Display Results	89	89	0.033	2697.0
	(SQL Overall)	178691	89	3.312	53952.6