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

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

66 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
dripper	12	34	923	(None)
dipper	11	40	1779	1	d_ipper
dripped	13	40	808	1	dripped
drippers	13	32	794	1	drippers
drippier	13	8	504	1	drippier
dropper	12	32	987	1	dropper
gripper	12	44	1071	1	gripper
ripper	10	35	1865	1	_ripper
tripper	11	37	1192	1	tripper
chipper	16	39	1258	2	chipper
clipper	13	37	1032	2	clipper
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
dapper	11	40	1663	2	d_apper
diaper	9	45	1311	2	d_iaper
dipped	12	35	1749	2	d_ipped
dippers	12	36	1518	2	d_ippers
dippier	12	31	1139	2	d_ippier
draper	9	43	1569	2	dr_aper
drier	6	44	2396	2	dri__er
drifter	11	34	870	2	drifter
driller	8	43	1188	2	driller
drinker	12	34	948	2	drinker
drippy	14	44	565	2	dripp_y
driver	10	47	1449	2	dri_ver
dropped	13	32	928	2	dropped
droppers	13	31	860	2	droppers
flipper	14	38	914	2	flipper
frippery	18	3	295	2	frippery
gipper	11	42	1530	2	_gipper
griper	9	41	1461	2	gri_per
gripier	10	32	1032	2	gripier
grippe	11	53	1032	2	grippe_
gripped	13	41	934	2	gripped
grippers	13	35	813	2	grippers
grippes	12	48	1037	2	grippes
grippier	13	5	520	2	grippier
hipper	13	38	1802	2	_hipper
kipper	14	34	1421	2	_kipper
lipper	10	42	1963	2	_lipper
nipper	10	37	1571	2	_nipper
quipper	20	9	582	2	quipper
rapper	10	46	2157	2	_rapper
riper	7	43	2840	2	_ri_per
ripped	11	44	1901	2	_ripped
rippers	11	41	1503	2	_rippers
rippler	11	32	1010	2	_rippler
shipper	14	35	1404	2	shipper
sipper	10	39	2099	2	_sipper
skipper	15	33	957	2	skipper
slipper	11	37	1298	2	slipper
snipper	11	39	1133	2	snipper
stripper	12	4	712	2	stripper
tipper	10	39	1841	2	_tipper
trapper	11	39	1280	2	trapper
tripped	12	39	1169	2	tripped
trippers	12	32	1016	2	trippers
trippet	11	37	1411	2	trippet
trippier	12	4	662	2	trippier
whipper	17	36	1138	2	whipper
wrapper	14	36	833	2	wrapper
zipper	19	38	1312	2	_zipper

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.546	327272.9
2	DLD Change Limit	107671	66	3.436	31336.1
3	Display Results	66	66	0.016	4125.0
	(SQL Overall)	178691	66	3.998	44695.1