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

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

78 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
marquetries	22	5	370	(None)
marqueteries	23	5	263	1	marqueteries
parquetries	22	5	412	1	parquetries
marqueterie	22	5	211	2	marqueterie_
barometries	15	4	769	3	barometries
barquettes	21	7	475	3	barquet_tes
barretries	12	4	624	3	bar_retries
coquetries	21	4	602	3	_coquetries
jacqueries	28	4	333	3	jacque_ries
manometries	15	4	725	3	manometries
maquettes	20	4	591	3	ma_quet_tes
marguerites	14	5	373	3	margue_rites
marquees	19	20	624	3	marque___es
marquesses	21	4	335	3	marque_sses
marquetry	23	6	261	3	marquetr__y
maumetries	14	4	602	3	ma_umetries
varletries	13	4	603	3	var_letries
aerometries	13	4	839	4	aerometries
archeries	14	4	1122	4	_arche_ries
arquebuses	21	5	170	4	_arquebuses
arteries	8	3	2148	4	_ar_te_ries
artistries	10	4	725	4	_artistries
banquettes	21	8	437	4	banquet_tes
barberries	14	4	623	4	bar_berries
baronetcies	15	5	324	4	baronetcies
barquentines	23	5	154	4	barquentines
barquette	20	6	490	4	barquet_te_
barratries	12	4	573	4	bar_ratries
basketries	16	4	504	4	ba_sketries
cabinetries	15	4	408	4	cabinetries
carpentries	15	4	479	4	carpentries
cartularies	13	4	537	4	cartularies
cauteries	11	6	1539	4	ca__uteries
charcuteries	19	9	315	4	charcuteries
circuitries	15	5	388	4	circuitries
corsetries	12	4	965	4	cor_setries
equerries	18	4	488	4	__equerries
farrieries	13	4	434	4	farrie_ries
gadgetries	13	4	402	4	ga_dgetries
gauntries	10	4	604	4	ga__untries
harlotries	13	4	568	4	har_lotries
harquebuses	25	5	130	4	harquebuses
jacquerie	27	5	280	4	jacque_rie_
mansuetudes	14	15	167	4	mansuetudes
maquette	19	4	611	4	ma_quet_te_
marguerite	13	5	391	4	margue_rite
marquee	18	21	858	4	marque___e_
marques	18	26	1086	4	marqu____es
marquess	19	20	495	4	marque___ss
marquessates	23	6	113	4	marquessates
marquis	18	24	706	4	marqu___i_s
marquisates	22	5	222	4	marquisates
marquise	19	20	617	4	marqu___ise
marquises	20	22	570	4	marqu__ises
marquisettes	23	5	127	4	marquiset_tes
marries	9	38	2528	4	mar____ries
martyries	14	4	656	4	mar__tyries
masquerades	23	5	176	4	masquerades
masquers	19	19	570	4	masque_r__s
masteries	11	10	1849	4	ma_ste_ries
merceries	13	4	1004	4	mer_ce_ries
mercuries	13	4	727	4	mercu__ries
moquettes	20	4	464	4	m_oquet_tes
mortuaries	12	4	537	4	mortu_aries
musketries	16	4	330	4	m_usketries
parametrizes	25	10	456	4	parametrizes
parqueted	21	4	422	4	parquet__ed
parqueting	22	4	363	4	parquet_ing
parquetry	23	5	291	4	parquetr__y
parquets	19	3	641	4	parquet___s
perimetries	15	4	778	4	perimetries
pyrometries	18	9	812	4	pyrometries
queries	16	3	1587	4	___que_ries
retries	7	41	2907	4	__r__etries
salimetries	13	4	569	4	salimetries
taquerias	18	4	353	4	ta_que_rias
varieties	12	5	920	4	var_iet_ies
wardenries	14	4	443	4	war_denries

Search took 10 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.436	409841.7
2	DLD Change Limit	148819	78	8.750	17007.9
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	9.232	19355.6