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

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

73 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
shippers	15	30	1230	(None)
chippers	17	35	1087	1	chippers
shippens	15	31	679	1	shippens
shipper	14	35	1403	1	shipper_
shoppers	15	30	1075	1	shoppers
sippers	11	31	1774	1	s_ippers
skippers	16	31	819	1	skippers
slippers	12	37	1122	1	slippers
snippers	12	29	971	1	snippers
whippers	18	32	903	1	whippers
chipper	16	39	1258	2	chipper_
chirpers	15	35	813	2	chirpers
choppers	17	41	1045	2	choppers
clippers	14	36	883	2	clippers
dippers	12	36	1517	2	_dippers
drippers	13	32	793	2	drippers
flippers	15	33	799	2	flippers
gippers	12	32	1207	2	_gippers
grippers	13	35	812	2	grippers
hipper	13	38	1802	2	_hipper_
hoppers	14	31	1514	2	_hoppers
kippers	15	32	1142	2	_kippers
lippers	11	34	1643	2	_lippers
nippers	11	30	1261	2	_nippers
quippers	21	8	480	2	quippers
reshippers	17	4	284	2	reshippers
rippers	11	41	1502	2	_rippers
sappers	11	35	1889	2	s_appers
scuppers	14	4	653	2	scuppers
shapers	12	40	1689	2	sh_apers
sharpers	13	38	1094	2	sharpers
shickers	17	30	1282	2	shickers
shiers	9	49	2175	2	shi__ers
shifters	14	31	985	2	shifters
shikkers	14	32	652	2	shikkers
shimmers	15	26	941	2	shimmers
shiners	10	40	1594	2	shi_ners
shipless	13	27	769	2	shipless
shipped	15	33	1210	2	shippe_d
shippen	14	29	886	2	shippe_n
shippons	15	25	565	2	shippons
shirkers	15	31	958	2	shirkers
shivers	13	37	1483	2	shi_vers
shopper	14	33	1262	2	shopper_
shoppes	14	34	1138	2	shoppe_s
shrimpers	16	3	381	2	shrimpers
simpers	11	30	1411	2	s_impers
sipper	10	39	2098	2	s_ipper_
sippets	11	33	1017	2	s_ippets
skipper	15	33	956	2	skipper_
skippets	16	28	455	2	skippets
slappers	12	37	1093	2	slappers
slipper	11	37	1297	2	slipper_
slippery	15	27	585	2	slippery
snappers	12	35	1016	2	snappers
snipers	9	33	1176	2	sni_pers
snipper	11	39	1132	2	snipper_
snippets	12	22	561	2	snippets
steppers	12	28	927	2	steppers
stipplers	13	3	443	2	stipplers
stoppers	12	39	1057	2	stoppers
strippers	13	5	575	2	strippers
suppers	11	33	1469	2	s_uppers
swappers	15	35	807	2	swappers
tippers	11	34	1434	2	_tippers
trippers	12	32	1015	2	trippers
whappers	18	27	674	2	whappers
whimpers	18	27	661	2	whimpers
whipper	17	36	1138	2	whipper_
whippets	18	25	525	2	whippets
whispers	16	26	699	2	whispers
whoppers	18	29	753	2	whoppers
zippers	20	33	1037	2	_zippers

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.140	1276364.3
2	DLD Change Limit	121059	73	4.233	28598.9
3	Display Results	73	73	0.063	1158.7
	(SQL Overall)	178691	73	4.436	40282.0