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

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

70 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
rippled	12	31	1027	(None)
crippled	15	33	679	1	crippled
nippled	12	30	764	1	nippled
rimpled	12	33	1142	1	rimpled
ripped	11	44	1901	1	ripp_ed
ripple	10	34	1391	1	ripple_
rippler	11	32	1010	1	rippler
ripples	11	35	1329	1	ripples
ripplet	11	34	1258	1	ripplet
tippled	12	35	839	1	tippled
crimpled	15	36	693	2	crimpled
cripple	13	37	858	2	cripple_
crippler	14	82	671	2	crippler
cripples	14	29	840	2	cripples
dappled	13	3	639	2	dappled
dimpled	13	28	1030	2	dimpled
dipped	12	35	1749	2	dipp_ed
dripped	13	40	808	2	dripp_ed
fipple	13	32	906	2	fipple_
fipples	14	29	865	2	fipples
gipped	12	48	1590	2	gipp_ed
grappled	14	33	609	2	grappled
gripped	13	41	934	2	gripp_ed
gripple	12	41	661	2	gripple_
hipped	14	43	1769	2	hipp_ed
hirpled	13	15	713	2	hirpled
hoppled	15	33	808	2	hoppled
impled	11	38	1251	2	_impled
kipped	15	31	1457	2	kipp_ed
lipped	11	44	1954	2	lipp_ed
mispled	12	3	1046	2	mispled
nipped	11	36	1585	2	nipp_ed
nipple	10	34	1037	2	nipple_
nipples	11	31	966	2	nipples
pimpled	14	28	918	2	pimpled
pipped	10	45	1654	2	pipp_ed
poppled	11	33	923	2	poppled
rapped	11	41	2268	2	rapp_ed
rappeled	13	3	500	2	rappeled
repled	9	33	1977	2	r_epled
repped	11	46	1672	2	repp_ed
riddled	10	30	1204	2	riddled
riffled	14	33	860	2	riffled
rifled	10	41	1500	2	ri_fled
riled	6	58	3325	2	ri__led
rilled	7	45	2565	2	ri_lled
rimple	10	38	1458	2	rimple_
rimples	11	31	1422	2	rimples
riped	8	52	2643	2	ri_p_ed
ripened	10	3	820	2	ripened
ripper	10	35	1865	2	ripp_er
ripplers	12	33	711	2	ripplers
ripplets	12	31	673	2	ripplets
ripplier	12	3	446	2	ripplier
ripply	13	34	800	2	rippl_y
rivaled	11	3	893	2	rivaled
rumpled	12	38	1001	2	rumpled
sipped	11	37	2063	2	sipp_ed
stippled	13	4	530	2	stippled
suppled	12	4	846	2	suppled
tipped	11	44	1826	2	tipp_ed
tipple	10	34	1191	2	tipple_
tippler	11	34	834	2	tippler
tipples	11	28	1125	2	tipples
toppled	12	34	884	2	toppled
tripled	10	41	1383	2	tri_pled
tripped	12	39	1169	2	tripp_ed
wimpled	15	33	882	2	wimpled
yipped	14	36	1328	2	yipp_ed
zipped	20	36	1298	2	zipp_ed

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.126	1418182.5
2	DLD Change Limit	107671	70	3.250	33129.5
3	Display Results	70	70	0.013	5384.6
	(SQL Overall)	178691	70	3.389	52726.8