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

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

246 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
piteous	9	3	1068	(None)
piceous	11	3	1069	1	piceous
pileous	9	5	1052	1	pileous
citreous	10	5	685	2	citreous
citrous	9	31	1299	2	citrous
duteous	8	3	845	2	duteous
epigeous	11	4	653	2	epigeous
hideous	11	6	843	2	hideous
luteous	7	3	927	2	luteous
nitrous	7	35	1248	2	nitrous
niveous	10	3	719	2	niveous
petrous	9	27	1442	2	petrous
pigeons	10	3	918	2	pigeons
pileus	8	45	1494	2	pile_us
pilous	8	47	1775	2	pi_lous
pious	7	46	2127	2	pi__ous
pistous	9	27	1438	2	pistous
piteously	14	4	631	2	piteously
pitons	8	53	1904	2	pit_ons
timeous	9	3	840	2	timeous
vitreous	11	4	584	2	vitreous
acetous	9	4	1036	3	acetous
aeneous	7	3	989	3	aeneous
aphthous	16	9	487	3	aphthous
apiaceous	13	4	405	3	apiaceous
apterous	10	4	1046	3	apterous
aqueous	16	3	605	3	aqueous
bijous	15	4	804	3	bi_jous
bilious	9	3	1093	3	bilious
biters	8	39	2524	3	bite_rs
bites	7	56	4117	3	bite__s
buteos	8	49	1341	3	buteo_s
caseous	9	3	1251	3	caseous
cineols	9	12	885	3	cineols
cirrous	9	31	1106	3	cirrous
citers	8	50	2298	3	cite_rs
cites	7	44	3559	3	cite__s
citrons	9	29	1322	3	citrons
citrus	8	36	1092	3	cit_rus
despiteous	13	5	232	3	~~des~~piteous
dimerous	11	3	932	3	dimerous
dipterous	12	5	628	3	dipterous
dispiteous	13	5	291	3	~~dis~~piteous
dites	6	63	3915	3	dite__s
dittos	7	41	1197	3	ditto_s
epigenous	12	4	535	3	epigenous
estrous	7	7	1253	3	estrous
fatuous	10	3	778	3	fatuous
fibrous	12	3	759	3	fibrous
gaseous	8	3	950	3	gaseous
gateaus	8	6	633	3	gateaus
gibbous	12	6	533	3	gibbous
gites	6	56	3018	3	gite__s
goitrous	9	4	576	3	goitrous
griseous	9	4	561	3	griseous
hideout	11	7	979	3	hideout
hideouts	12	8	557	3	hideouts
hugeous	11	3	713	3	hugeous
icterus	9	3	607	3	icterus
igneous	8	3	577	3	igneous
ileus	5	46	1689	3	_ile_us
iodous	7	3	1150	3	_iodous
items	7	49	961	3	_ite_ms
iterum	8	3	790	3	_iterum
kiters	10	52	1859	3	kite_rs
kites	9	54	3254	3	kite__s
lacteous	10	4	677	3	lacteous
libelous	10	4	719	3	libelous
lieus	5	62	1848	3	li_e_us
ligneous	9	4	523	3	ligneous
liters	6	54	2988	3	lite_rs
lithops	12	30	725	3	lithops
lithos	9	42	1255	3	litho_s
litmus	8	3	632	3	lit_mus
meous	7	61	2006	3	__meous
meteors	9	46	1001	3	meteors
miaous	8	5	1169	3	mi_aous
mimeos	10	45	1154	3	mimeo_s
miters	8	43	2878	3	mite_rs
mites	7	51	4180	3	mite__s
nimious	9	3	766	3	nimious
niobous	9	3	633	3	niobous
niters	6	46	2421	3	nite_rs
nites	5	57	3634	3	nite__s
nitons	6	46	1490	3	nit_ons
nitros	6	42	1412	3	nitro_s
osseous	7	3	605	3	osseous
paeons	8	39	1552	3	p_aeons
pappous	10	5	746	3	pappous
pareos	8	70	2377	3	pareo_s
pareus	8	54	2074	3	pare_us
parlous	9	4	1429	3	parlous
parous	8	40	2416	3	p_arous
paseos	8	80	1581	3	paseo_s
patens	8	48	2086	3	pate_ns
patents	9	48	1520	3	patents
paters	8	49	3583	3	pate_rs
pates	7	60	4789	3	pate__s
pathos	11	55	1669	3	patho_s
patios	8	52	2178	3	patio_s
patois	8	43	1936	3	pat_ois
patrols	9	35	1351	3	patrols
patrons	9	38	1810	3	patrons
patulous	10	11	636	3	patulous
peons	7	53	2718	3	p__eons
pereons	9	28	1500	3	pereons
petalous	10	5	897	3	petalous
petasus	9	4	636	3	petasus
peters	8	66	2459	3	pete_rs
petrols	9	29	1308	3	petrols
phoebus	14	4	382	3	phoebus
pianos	8	43	1593	3	piano_s
picots	10	46	1644	3	pi_cots
pieces	10	42	1727	3	pi_eces
piers	7	59	2633	3	pi_e_rs
pies	6	69	4960	3	pi_e__s
pietas	8	45	1650	3	pi_etas
pieties	9	4	1922	3	pieties
pigeon	9	4	941	3	pigeo_n
pignus	9	3	795	3	pi_gnus
pigout	9	3	1461	3	pi_gout
pigouts	10	3	759	3	pi_gouts
pikers	12	47	1739	3	pike_rs
pikes	11	50	3103	3	pike__s
pilaus	8	41	1413	3	pi_laus
piles	7	47	4261	3	pile__s
pileum	10	39	951	3	pile_um
pileup	10	43	792	3	pile_up
pileups	11	36	543	3	pileups
pillows	12	26	1012	3	pillows
pilots	8	40	1887	3	pi_lots
pilus	7	59	2106	3	pi__lus
pinaceous	13	4	532	3	pinaceous
pineals	9	32	1284	3	pineals
pinenes	9	34	1667	3	pinenes
pines	7	60	4886	3	pine__s
pinetum	11	4	555	3	pinetum
pingoes	10	51	1652	3	pingoes
pingos	9	53	1767	3	pingo_s
pinions	9	34	1360	3	pinions
pinkoes	13	55	1231	3	pinkoes
pinkos	12	53	1387	3	pinko_s
pinons	8	60	1994	3	pi_nons
pinots	8	59	2027	3	pi_nots
pintoes	9	51	1771	3	pintoes
pintos	8	60	2129	3	pinto_s
pinyons	12	29	900	3	pinyons
pions	7	58	2639	3	pi__ons
pipeful	14	4	564	3	pipeful
pipefuls	15	4	375	3	pipefuls
pipers	10	43	1866	3	pipe_rs
pipes	9	60	3014	3	pipe__s
pipets	10	57	1477	3	pipe_ts
piscos	10	51	1259	3	pisco_s
pisos	7	60	2106	3	pi_so_s
pistes	8	53	2563	3	piste__s
pistols	9	32	1398	3	pistols
pistons	9	30	1637	3	pistons
pistou	8	32	1184	3	pistou_
pitas	7	74	2767	3	pit__as
pitayas	12	8	626	3	pitayas
pitches	14	36	1775	3	pitches
pitchout	15	4	694	3	pitchout
pitchouts	16	4	367	3	pitchouts
pitheads	14	33	814	3	pitheads
piths	10	58	1754	3	pit__hs
pitiers	9	38	1265	3	pitiers
pities	8	38	2808	3	pit_ies
pitiful	12	4	586	3	pitiful
pitmans	11	18	874	3	pitmans
piton	7	61	2158	3	pit_o_n
pits	6	63	4874	3	pit___s
pitsaws	12	3	499	3	pitsaws
pittas	8	60	1452	3	pit_tas
pivots	11	51	1190	3	pi_vots
pixels	15	47	853	3	pixe_ls
pixes	14	43	2317	3	pixe__s
plateaus	10	3	553	3	plateaus
plenteous	11	4	445	3	plenteous
pleons	8	42	1334	3	p_leons
plexus	15	37	728	3	p_lexus
pluteus	9	32	624	3	plute_us
poaceous	12	6	717	3	poaceous
pompous	13	3	806	3	pompous
porous	8	44	1948	3	p_orous
potboys	14	7	527	3	potboys
poteens	9	29	1088	3	poteens
pothos	11	42	1469	3	potho_s
pothouse	13	4	870	3	pothouse
potions	9	34	1742	3	potions
pottos	8	46	1587	3	potto_s
poyous	11	29	1162	3	p_oyous
preops	10	49	1194	3	p_reops
pretors	9	3	1681	3	pretors
proteus	9	25	1159	3	prote_us
pulpous	11	7	701	3	pulpous
pumiceous	15	6	347	3	pumiceous
putlogs	10	6	508	3	putlogs
putons	8	35	1515	3	put_ons
putout	8	3	1511	3	put_out
putouts	9	3	708	3	put_outs
pyritous	13	4	493	3	pyrit_ous
pythons	15	3	736	3	pythons
righteous	13	4	507	3	righteous
rimous	8	3	1191	3	ri_mous
riotous	7	3	986	3	riotous
rites	5	44	4255	3	rite__s
setous	6	49	1737	3	set_ous
silenus	7	36	969	3	silenus
simious	9	3	980	3	simious
sinuous	7	3	906	3	sinuous
sitcoms	11	4	553	3	sitcoms
sites	5	60	4543	3	site__s
situs	5	50	1923	3	sit__us
spinous	9	3	1044	3	spi_nous
spiteful	13	4	430	3	spiteful
spites	8	41	2733	3	spite__s
thous	8	60	1726	3	__thous
timeout	9	4	859	3	timeout
timeouts	10	4	477	3	timeouts
titanous	8	4	655	3	titanous
titers	6	45	2641	3	tite_rs
titmouse	10	4	313	3	titmouse
uterus	6	3	920	3	_uterus
uveous	9	3	660	3	_uveous
vicious	12	3	949	3	vicious
videos	10	49	1137	3	video_s
villous	10	28	1002	3	villous
vinous	9	39	1417	3	vi_nous
viperous	13	4	761	3	viperous
vireos	9	42	1245	3	vireo_s
virtuous	11	4	466	3	virtuous
viscous	12	3	883	3	viscous
vitellus	11	4	414	3	vitellus
whiteout	14	4	558	3	whiteout
whiteouts	15	4	317	3	whiteouts
wideout	11	7	903	3	wideout
wideouts	12	7	523	3	wideouts
wigeons	11	3	698	3	wigeons
wipeout	12	8	787	3	wipeout
wipeouts	13	5	420	3	wipeouts
wites	8	55	3696	3	wite__s
without	13	4	889	3	without
withouts	14	4	512	3	withouts
wittols	10	3	573	3	wittols
zincous	18	3	705	3	zincous

Search took 7 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	134027	0.403	443402.0
2	DLD Change Limit	134027	246	5.956	22502.9
3	Display Results	246	246	0.076	3236.8
	(SQL Overall)	178691	246	6.435	27768.6