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

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

89 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
tripped	12	39	1169	(None)
dripped	13	40	808	1	dripped
gripped	13	41	934	1	gripped
ripped	11	44	1901	1	_ripped
stripped	13	5	709	1	stripped
tipped	11	44	1826	1	t_ipped
trapped	12	45	1221	1	trapped
tripled	10	41	1383	1	tripled
tripper	11	37	1192	1	tripper
trippet	11	37	1411	1	trippet
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
dipped	12	35	1749	2	_dipped
dripper	12	34	923	2	dripper
dropped	13	32	928	2	dropped
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
strapped	13	5	782	2	strapped
striped	10	52	1436	2	stri_ped
stripper	12	4	712	2	stripper
stropped	13	6	734	2	stropped
tapped	11	38	2005	2	t_apped
tipper	10	39	1841	2	t_ipper
tippet	10	39	1787	2	t_ippet
tippled	12	35	839	2	t_ippled
topped	11	46	1772	2	t_opped
traipsed	11	3	475	2	traipsed
tramped	12	43	1243	2	tramped
trapper	11	39	1280	2	trapper
triaged	9	28	1044	2	triaged
triced	9	55	1867	2	tri_ced
tricked	14	40	1616	2	tricked
tried	6	50	2691	2	tri__ed
trifled	11	37	1196	2	trifled
trigged	10	35	985	2	trigged
trilled	8	41	1631	2	trilled
trimmed	12	34	893	2	trimmed
trined	7	49	2071	2	tri_ned
tripe	7	54	2538	2	tri_pe_
tripes	8	53	2487	2	tri_pes
triple	8	42	1592	2	triple_
triples	9	46	1687	2	triples
triplet	9	43	1921	2	triplet
triplex	16	44	780	2	triplex
tripod	9	39	985	2	tri_pod
trippers	12	32	1016	2	trippers
trippets	12	35	742	2	trippets
trippier	12	4	662	2	trippier
trippy	13	45	780	2	tripp_y
tromped	12	42	1029	2	tromped
trooped	10	40	1072	2	trooped
trouped	10	39	1098	2	trouped
trumped	12	43	971	2	trumped
tupped	11	40	1323	2	t_upped
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.390	458182.1
2	DLD Change Limit	107671	89	3.296	32667.2
3	Display Results	89	89	0.033	2697.0
	(SQL Overall)	178691	89	3.719	48048.1