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

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

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.

83 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
trinketries	15	35	431	(None)
trickeries	16	4	714	2	tricke_ries
grinderies	12	4	583	3	grinde_ries
printeries	12	4	1063	3	printe_ries
rocketries	16	4	589	3	_rocketries
toiletries	10	4	661	3	toi_letries
trinities	9	3	1334	3	trin_it_ies
trinketed	14	4	425	3	trinket__ed
trinketer	13	4	456	3	trinket__er
trinketers	14	4	373	3	trinket_ers
trinketing	15	4	415	3	trinket_ing
trinketry	16	4	280	3	trinketr__y
trinkets	12	3	714	3	trinket___s
twinberries	16	5	298	3	twinberries
basketries	16	4	504	4	_basketries
binderies	12	3	1168	4	_binde_ries
biometries	14	4	893	4	_biometries
briberies	13	4	833	4	bri_be_ries
cabinetries	15	4	408	4	cabin_etries
cranberries	15	5	425	4	cranberries
crockeries	18	5	711	4	crocke_ries
crookeries	16	4	613	4	crooke_ries
drinkers	13	27	782	4	drinke_r__s
ergometries	14	5	568	4	ergometries
fineries	11	24	1674	4	_fin_e_ries
fripperies	17	4	358	4	frippe_ries
grilleries	11	4	559	4	grille_ries
inkberries	16	4	288	4	__inkberries
interties	9	3	2033	4	__interties
joineries	16	4	810	4	join_e_ries
lingeries	10	5	1181	4	_linge_ries
ministries	12	4	756	4	_ministries
monkeries	15	12	991	4	_monke_ries
musketries	16	4	330	4	_musketries
nineties	8	3	1291	4	_nin_et_ies
orangeries	11	11	694	4	orange_ries
oximetries	19	4	456	4	oxi_metries
perimetries	15	4	778	4	peri_metries
pineries	10	24	1908	4	_pin_e_ries
priggeries	14	4	499	4	prigge_ries
prinkers	14	30	1038	4	prinke_r__s
retries	7	41	2907	4	_r___etries
ricketier	15	13	458	4	_ricket_ier
ricketiest	16	4	395	4	_ricket_iest
rifleries	12	4	768	4	_rifle_ries
rockeries	15	12	897	4	_rocke_ries
rookeries	13	13	817	4	_rooke_ries
shinneries	13	4	571	4	shinne_ries
spinneries	12	4	573	4	spinne_ries
stringencies	15	5	352	4	stringencies
tanistries	10	4	706	4	t_anistries
tanneries	9	3	1042	4	t_anne_ries
telemetries	13	5	558	4	telemetries
tenantries	10	4	567	4	t_enantries
thieveries	16	4	347	4	thieve_ries
thinkers	15	30	870	4	thinke_r__s
tinkered	13	8	768	4	t_inke_r_ed
tinkerer	12	8	680	4	t_inke_r_er
tinkerers	13	9	542	4	t_inke_rers
tinkering	14	3	770	4	t_inke_ring
tinkers	11	35	1714	4	t_inke_r__s
tinkertoys	17	5	151	4	t_inkertoys
tonometries	13	4	721	4	tonometries
traceries	11	3	1286	4	tr_ace_ries
triacetates	13	7	340	4	triacetates
tributaries	13	5	320	4	tributaries
trickers	14	38	1281	4	tricke_r__s
trigonometries	17	6	226	4	trigonometries
trimetric	13	4	686	4	tri_metri_c
trinket	11	3	1481	4	trinket____
tripletails	13	5	231	4	tripletails
triquetrous	20	5	113	4	triquetrous
triskeles	13	4	427	4	triske__les
tristearins	11	5	372	4	tristearins
triunities	10	4	610	4	triunit_ies
triweeklies	18	5	100	4	triweeklies
truantries	10	4	402	4	tr_uantries
trumperies	14	4	445	4	trumpe_ries
turneries	9	4	849	4	turn_e_ries
twinkies	15	3	598	4	twink___ies
urinaries	9	4	920	4	urin__aries
vineries	11	27	1604	4	_vin_e_ries
wineries	11	23	1653	4	_win_e_ries

Search took 9 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	148819	0.406	440125.6
2	DLD Change Limit	148819	83	8.220	18104.5
3	Display Results	83	83	0.046	1804.3
	(SQL Overall)	178691	83	8.672	20605.5