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

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

67 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
trippers	12	32	1016	(None)
drippers	13	32	794	1	drippers
grippers	13	35	813	1	grippers
rippers	11	41	1503	1	_rippers
strippers	13	5	577	1	strippers
tippers	11	34	1435	1	t_ippers
trappers	12	37	1104	1	trappers
tripper	11	37	1192	1	tripper_
trippets	12	35	742	1	trippets
chippers	17	35	1088	2	chippers
clippers	14	36	884	2	clippers
crappers	14	40	1102	2	crappers
crimpers	14	31	893	2	crimpers
cripplers	15	31	499	2	cripplers
crispers	12	30	943	2	crispers
croppers	14	33	1148	2	croppers
cruppers	14	31	732	2	cruppers
dippers	12	36	1518	2	_dippers
dripper	12	34	923	2	dripper_
droppers	13	31	860	2	droppers
flippers	15	33	800	2	flippers
frippery	18	3	295	2	frippery
gippers	12	32	1208	2	_gippers
gripers	10	40	1146	2	gri_pers
gripper	12	44	1071	2	gripper_
grippes	12	48	1037	2	grippe_s
kippers	15	32	1143	2	_kippers
lippers	11	34	1644	2	_lippers
nippers	11	30	1262	2	_nippers
quippers	21	8	481	2	quippers
rappers	11	36	1844	2	_rappers
ripper	10	35	1865	2	_ripper_
ripplers	12	33	711	2	_ripplers
shippers	15	30	1231	2	shippers
sippers	11	31	1775	2	_sippers
skippers	16	31	820	2	skippers
slippers	12	37	1123	2	slippers
snippers	12	29	972	2	snippers
strappers	13	4	674	2	strappers
stripers	10	39	1159	2	stri_pers
stripper	12	4	712	2	stripper_
stroppers	13	5	671	2	stroppers
tappers	11	34	1654	2	t_appers
tipper	10	39	1841	2	t_ipper_
tippets	11	33	937	2	t_ippets
tipplers	12	33	635	2	t_ipplers
toppers	11	39	1460	2	t_oppers
trampers	12	32	1039	2	trampers
trapper	11	39	1280	2	trapper_
trickers	14	38	1281	2	trickers
triers	6	43	2152	2	tri__ers
triflers	11	31	1021	2	triflers
triggers	10	25	784	2	triggers
trillers	8	36	1349	2	trillers
trimers	9	46	1514	2	tri_mers
trimmers	12	28	891	2	trimmers
tripes	8	53	2487	2	tri_pe_s
triples	9	46	1687	2	triple_s
triplets	10	35	1026	2	triplets
tripped	12	39	1169	2	trippe_d
trippet	11	37	1411	2	trippe_t
trippier	12	4	662	2	trippier_
troopers	10	28	944	2	troopers
troupers	10	35	944	2	troupers
whippers	18	32	904	2	whippers
wrappers	15	30	693	2	wrappers
zippers	20	33	1038	2	_zippers

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	121059	0.390	458182.1
2	DLD Change Limit	121059	67	3.860	31362.4
3	Display Results	67	67	0.016	4187.5
	(SQL Overall)	178691	67	4.266	41887.2