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

Here are the results of your fuzzy-string dictionary search for “frippery” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

137 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
frippery	18	3	295	(None)
dripper	12	34	923	2	dripper_
drippers	13	32	794	2	drippers
flipper	14	38	914	2	flipper_
flippers	15	33	800	2	flippers
foppery	17	38	562	2	f_oppery
gripper	12	44	1071	2	gripper_
grippers	13	35	813	2	grippers
ripper	10	35	1865	2	_ripper_
rippers	11	41	1503	2	_rippers
slippery	15	27	586	2	slippery
tripper	11	37	1192	2	tripper_
trippers	12	32	1016	2	trippers
bribery	14	42	649	3	bri_bery
briery	11	45	1077	3	bri__ery
chipper	16	39	1258	3	chipper_
chippers	17	35	1088	3	chippers
clipper	13	37	1032	3	clipper_
clippers	14	36	884	3	clippers
coppery	16	40	939	3	_coppery
crapper	13	39	1319	3	crapper_
crappers	14	40	1102	3	crappers
crimper	13	65	1042	3	crimper_
crimpers	14	31	893	3	crimpers
crippler	14	82	671	3	crippler_
cripplers	15	31	499	3	cripplers
crisper	11	35	1105	3	crisper_
crispers	12	30	944	3	crispers
cropper	13	33	1297	3	cropper_
croppers	14	33	1148	3	croppers
crupper	13	33	856	3	crupper_
cruppers	14	31	732	3	cruppers
dipper	11	40	1779	3	_dipper_
dippers	12	36	1518	3	_dippers
drapery	13	38	794	3	dr_apery
dripped	13	40	808	3	drippe_d
drippier	13	8	504	3	drippier_
drippily	16	4	303	3	drippily
drippy	14	44	565	3	dripp__y
dropper	12	32	987	3	dropper_
droppers	13	31	860	3	droppers
fiery	11	47	1479	3	f_i__ery
finery	12	45	1289	3	f_i_nery
fishery	16	39	773	3	f_ishery
flapper	14	35	920	3	flapper_
flappers	15	38	838	3	flappers
flickery	20	36	510	3	flickery
flipped	15	35	851	3	flippe_d
flippest	15	3	518	3	flippest
flippy	16	5	461	3	flipp__y
flopper	14	32	847	3	flopper_
floppers	15	33	746	3	floppers
frappe	13	28	695	3	frappe__
frapped	15	31	885	3	frappe_d
frappes	14	32	838	3	frappe_s
friary	12	40	1009	3	fri__ary
frier	8	52	2584	3	fri__er_
friers	9	47	1893	3	fri__ers
friller	10	41	1174	3	friller_
frillers	11	34	987	3	frillers
fripperies	17	4	359	3	fripperies
frisker	14	38	927	3	frisker_
friskers	15	33	737	3	friskers
fritter	10	39	1277	3	fritter_
fritters	11	38	1078	3	fritters
frizer	18	40	1128	3	fri_zer_
frizers	19	32	955	3	fri_zers
frizzer	18	44	689	3	frizzer_
frizzers	19	33	510	3	frizzers
gipper	11	42	1530	3	_gipper_
gippers	12	32	1208	3	_gippers
grapery	13	45	795	3	gr_apery
grillery	12	35	550	3	grillery
grindery	13	25	551	3	grindery
griper	9	41	1461	3	gri_per_
gripers	10	40	1146	3	gri_pers
gripey	12	41	1120	3	gri_pe_y
gripier	10	32	1032	3	gripier_
grippe	11	53	1032	3	grippe__
gripped	13	41	934	3	grippe_d
grippes	12	48	1037	3	grippe_s
grippier	13	5	520	3	grippier_
grippy	14	44	776	3	gripp__y
hipper	13	38	1802	3	_hipper_
kipper	14	34	1421	3	_kipper_
kippers	15	32	1143	3	_kippers
lipper	10	42	1963	3	_lipper_
lippers	11	34	1644	3	_lippers
nipper	10	37	1571	3	_nipper_
nippers	11	30	1262	3	_nippers
peppery	13	28	625	3	_peppery
periphery	19	4	384	3	periphery
priggery	15	4	399	3	priggery
printery	13	31	843	3	printery
quipper	20	9	582	3	quipper_
quippers	21	8	481	3	quippers
rapper	10	46	2157	3	_rapper_
rappers	11	36	1844	3	_rappers
riflery	13	34	580	3	_riflery
ripely	11	25	1115	3	_ri_pely
riper	7	43	2840	3	_ri_per_
ripped	11	44	1901	3	_rippe_d
rippler	11	32	1010	3	_rippler_
ripplers	12	33	711	3	_ripplers
ripply	13	34	800	3	_ripp_ly
ropery	11	43	1387	3	_r_opery
shipper	14	35	1404	3	shipper_
shippers	15	30	1231	3	shippers
sipper	10	39	2099	3	_sipper_
sippers	11	31	1775	3	_sippers
skipper	15	33	957	3	skipper_
skippers	16	31	820	3	skippers
slipper	11	37	1298	3	slipper_
slippers	12	37	1123	3	slippers
snipper	11	39	1133	3	snipper_
snippers	12	29	972	3	snippers
snippety	15	26	349	3	snippety
stripper	12	4	712	3	stripper_
strippers	13	5	577	3	strippers
tipper	10	39	1841	3	_tipper_
tippers	11	34	1435	3	_tippers
trapper	11	39	1280	3	trapper_
trappers	12	37	1104	3	trappers
trickery	17	29	734	3	trickery
tripped	12	39	1169	3	trippe_d
trippet	11	37	1411	3	trippe_t
trippets	12	35	742	3	trippets
trippier	12	4	662	3	trippier_
trippy	13	45	780	3	tripp__y
trumpery	15	3	361	3	trumpery
whipper	17	36	1138	3	whipper_
whippers	18	32	904	3	whippers
whispery	19	28	429	3	whispery
wrapper	14	36	833	3	wrapper_
wrappers	15	30	693	3	wrappers
zipper	19	38	1312	3	_zipper_
zippers	20	33	1038	3	_zippers

Search took 8 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	146162	0.466	383457.1
2	DLD Change Limit	146162	137	7.236	20199.3
3	Display Results	137	137	0.063	2174.6
	(SQL Overall)	178691	137	7.765	23012.4