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

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

80 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
chipper	16	39	1258	(None)
chipped	17	41	1081	1	chipped
chippers	17	35	1088	1	chippers
chippier	17	29	767	1	chippier
chirper	14	35	996	1	chirper
chopper	16	36	1189	1	chopper
clipper	13	37	1032	1	clipper
hipper	13	38	1802	1	_hipper
shipper	14	35	1404	1	shipper
whipper	17	36	1138	1	whipper
capper	12	44	2198	2	c_apper
champer	16	38	1341	2	champer
chapped	17	27	1144	2	chapped
chapter	14	42	1385	2	chapter
cheaper	14	40	1058	2	cheaper
cheeper	14	36	1074	2	cheeper
chicer	13	45	1360	2	chi_cer
chider	12	51	1605	2	chi_der
chiefer	15	3	686	2	chiefer
chigger	14	3	600	2	chigger
chiller	12	41	1218	2	chiller
chimer	13	55	1720	2	chi_mer
chippered	19	4	500	2	chippered
chippie	16	29	769	2	chippie
chippies	17	30	975	2	chippies
chippy	18	43	761	2	chipp_y
chirker	16	42	932	2	chirker
chirped	15	37	978	2	chirped
chirpers	15	35	813	2	chirpers
chirpier	15	27	630	2	chirpier
chitter	12	41	1296	2	chitter
chomper	16	38	1007	2	chomper
chopped	17	45	1100	2	chopped
choppers	17	41	1046	2	choppers
choppier	17	28	664	2	choppier
cipher	13	37	1026	2	c_ipher
clapper	13	40	1186	2	clapper
clipped	14	43	983	2	clipped
clippers	14	36	884	2	clippers
copper	12	43	2189	2	c_opper
crapper	13	39	1319	2	crapper
crimper	13	65	1042	2	crimper
crippler	14	82	671	2	crippler
crisper	11	35	1105	2	crisper
cropper	13	33	1296	2	cropper
crupper	13	33	856	2	crupper
cupper	12	43	1386	2	c_upper
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
ripper	10	35	1865	2	_ripper
shipped	15	33	1210	2	shipped
shippen	14	29	886	2	shippen
shippers	15	30	1231	2	shippers
shopper	14	33	1263	2	shopper
sipper	10	39	2099	2	_sipper
skipper	15	33	957	2	skipper
slipper	11	37	1298	2	slipper
snipper	11	39	1133	2	snipper
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.360	496363.9
2	DLD Change Limit	107671	80	3.513	30649.3
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	3.906	45747.8