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

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

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.

72 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
pimentos	12	4	623	(None)
pimento	11	5	722	1	pimento_
pimientos	13	4	283	1	pimientos
mementos	12	26	737	2	mementos
momentos	12	33	833	2	momentos
pigments	13	3	734	2	pigment_s
pimiento	12	4	325	2	pimiento_
pintos	8	60	2129	2	pi__ntos
ailments	10	3	943	3	ailment_s
aliments	10	3	1109	3	aliment_s
aments	8	52	1980	3	_ament_s
bentos	8	62	1830	3	__bentos
cements	11	27	1422	3	cement_s
centos	8	59	2046	3	__centos
dements	10	30	1662	3	dement_s
figments	14	4	694	3	figment_s
fitments	13	7	679	3	fitment_s
foments	12	29	1205	3	foment_s
kimonos	13	11	463	3	kimon_os
laments	9	43	1485	3	lament_s
lentos	6	53	1740	3	__lentos
limens	8	46	1803	3	limen__s
loments	9	34	1347	3	loment_s
memento	11	37	813	3	memento_
mementoes	13	32	538	3	mementoes
mentor	8	4	1436	3	__mentor
mentors	9	3	1499	3	__mentors
mimeos	10	45	1154	3	mime__os
momento	11	34	890	3	momento_
momentoes	13	28	625	3	momentoes
momentous	13	28	577	3	momentous
moments	11	31	1312	3	moment_s
obentos	9	3	670	3	_obentos
orpiments	13	4	600	3	orpiment_s
palmettos	13	4	370	3	palmettos
pantos	8	52	2274	3	p__antos
parents	9	34	1812	3	parent_s
patentor	10	4	637	3	patentor
patentors	11	4	674	3	patentors
patents	9	48	1520	3	patent_s
payments	15	3	694	3	payment_s
pediments	14	4	834	3	pediment_s
pengos	9	46	1241	3	p__engos
pentose	9	3	1159	3	p__entose
pestos	8	47	1908	3	p__estos
pianos	8	43	1593	3	pi_an_os
pietas	8	45	1650	3	pi_e_tas
pigment	12	5	1073	3	pigment__
pigmented	15	4	406	3	pigmented
pinenes	9	34	1667	3	pinen_es
pingos	9	53	1767	3	pi__ngos
pinkos	12	53	1387	3	pi__nkos
pinots	8	59	2027	3	pi__nots
pintas	8	50	2139	3	pi__ntas
pinto	7	56	2575	3	pi__nto_
pintoes	9	51	1771	3	pi__ntoes
pints	7	59	3622	3	pi__nt_s
pipets	10	57	1477	3	pipe_t_s
pipettes	12	3	756	3	pipettes
polentas	10	3	874	3	polentas
pomelos	11	21	813	3	pome_los
prestos	9	37	1608	3	p_restos
primeness	13	3	865	3	primeness
primeros	12	33	688	3	prime_ros
pumelos	11	19	609	3	pume_los
puntos	8	59	1579	3	p__untos
raiments	10	3	990	3	raiment_s
seicentos	11	4	455	3	seicentos
silents	7	35	1449	3	silent_s
spintos	9	3	913	3	spi__ntos
tomentose	11	4	356	3	tomentose
wisents	10	24	906	3	wisent_s

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.420	425454.8
2	DLD Change Limit	146162	72	6.736	21698.6
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	7.186	24866.5