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

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

65 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
dripped	13	40	808	(None)
dipped	12	35	1749	1	d_ipped
dripper	12	34	923	1	dripper
dropped	13	32	928	1	dropped
gripped	13	41	934	1	gripped
ripped	11	44	1901	1	_ripped
tripped	12	39	1169	1	tripped
blipped	14	37	719	2	blipped
chipped	17	41	1081	2	chipped
clipped	14	43	983	2	clipped
crapped	14	39	1262	2	crapped
crimped	14	39	1076	2	crimped
crippled	15	33	679	2	crippled
crisped	12	40	1010	2	crisped
cropped	14	38	1206	2	cropped
dapped	12	45	1676	2	d_apped
dipper	11	40	1779	2	d_ipper
draped	10	53	1436	2	dr_aped
dribbed	13	32	675	2	dribbed
dried	7	53	2138	2	dri__ed
drifted	12	36	795	2	drifted
drilled	9	47	1167	2	drilled
drippers	13	32	794	2	drippers
drippier	13	8	504	2	drippier
drippy	14	44	565	2	dripp_y
drooped	11	36	843	2	drooped
dropper	12	32	987	2	dropper
dupped	12	44	1164	2	d_upped
flipped	15	35	851	2	flipped
frapped	15	31	885	2	frapped
gipped	12	48	1590	2	_gipped
griped	10	41	1471	2	gri_ped
grippe	11	53	1032	2	grippe_
gripper	12	44	1071	2	gripper
grippes	12	48	1037	2	grippes
hipped	14	43	1769	2	_hipped
kipped	15	31	1457	2	_kipped
lipped	11	44	1954	2	_lipped
nipped	11	36	1585	2	_nipped
pipped	10	45	1654	2	_pipped
prepped	11	32	990	2	prepped
primped	14	47	915	2	primped
propped	11	33	1195	2	propped
quipped	21	7	516	2	quipped
rapped	11	41	2268	2	_rapped
repped	11	46	1672	2	_repped
riped	8	52	2643	2	_ri_ped
ripper	10	35	1865	2	_ripper
rippled	12	31	1027	2	_rippled
shipped	15	33	1210	2	shipped
sipped	11	37	2063	2	_sipped
skipped	16	35	841	2	skipped
slipped	12	47	1174	2	slipped
snipped	12	35	1004	2	snipped
stripped	13	5	709	2	stripped
tipped	11	44	1826	2	_tipped
trapped	12	45	1221	2	trapped
tripled	10	41	1383	2	tripled
tripper	11	37	1192	2	tripper
trippet	11	37	1411	2	trippet
unripped	13	3	576	2	unripped
whipped	18	37	933	2	whipped
wrapped	15	33	802	2	wrapped
yipped	14	36	1328	2	_yipped
zipped	20	36	1298	2	_zipped

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	65	2.920	36873.6
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	3.310	53985.2