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

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

78 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
gripper	12	44	1071	(None)
dripper	12	34	923	1	dripper
gipper	11	42	1530	1	g_ipper
griper	9	41	1461	1	gri_per
gripier	10	32	1032	1	gripier
grippe	11	53	1032	1	grippe_
gripped	13	41	934	1	gripped
grippers	13	35	813	1	grippers
grippes	12	48	1037	1	grippes
grippier	13	5	520	1	grippier
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
dipper	11	40	1779	2	_dipper
dripped	13	40	808	2	dripped
drippers	13	32	794	2	drippers
drippier	13	8	504	2	drippier
dropper	12	32	987	2	dropper
flipper	14	38	914	2	flipper
frippery	18	3	295	2	frippery
gipped	12	48	1590	2	g_ipped
gippers	12	32	1208	2	g_ippers
grapier	10	37	1260	2	grapier
grappler	13	33	619	2	grappler
grasper	10	38	979	2	grasper
gridder	10	36	776	2	gridder
griever	11	3	603	2	griever
grifter	11	38	1049	2	grifter
griller	8	45	1335	2	griller
grimier	10	32	1043	2	grimier
grimmer	12	35	1009	2	grimmer
grinder	9	33	1239	2	grinder
grinner	8	32	923	2	grinner
gripe	8	46	2296	2	gri_pe_
griped	10	41	1471	2	gri_ped
gripers	10	40	1146	2	gri_pers
gripes	9	46	1987	2	gri_pes
gripey	12	41	1120	2	gri_pey
gripmen	12	3	503	2	gripmen
gripple	12	41	661	2	gripple
grippy	14	44	776	2	gripp_y
grister	8	39	1541	2	grister
gritter	8	39	1335	2	gritter
groper	9	45	1725	2	gr_oper
grouper	10	42	1009	2	grouper
gypper	14	34	729	2	g_ypper
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 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	78	3.203	33615.7
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	3.593	49733.1