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

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

319 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
errants	7	4	1064	(None)
errands	8	4	760	1	errands
errant	6	6	1873	1	errant_
aberrants	11	4	585	2	aberrants
arrant	6	6	2325	2	arrant_
brants	8	57	2305	2	_brants
currants	10	3	793	2	currants
eluants	7	3	758	2	eluants
entrants	8	3	1175	2	entrants
errancy	12	5	636	2	errancy
errand	7	5	879	2	erran_d
errantly	11	7	579	2	errantly
errantry	11	11	346	2	errantry
errata	6	3	901	2	erra_ta
erratas	7	3	686	2	erratas
grants	7	37	2247	2	_grants
jurants	14	37	921	2	jurants
rants	5	59	3534	2	__rants
recants	9	32	1709	2	recants
regrants	9	3	1001	2	regrants
rerents	7	33	1942	2	rerents
serranos	8	5	787	2	serranos
servants	11	3	800	2	servants
terranes	8	25	1443	2	terranes
truants	7	3	816	2	truants
tyrants	10	3	745	2	tyrants
versants	11	3	778	2	versants
warrants	11	6	850	2	warrants
aberrant	10	4	954	3	aberrant_
alants	6	77	2202	3	_alants
ants	4	72	4347	3	___ants
argents	8	40	1485	3	argents
arhats	9	3	1297	3	arha_ts
aroints	7	3	1313	3	aroints
aroynts	10	3	663	3	aroynts
arpents	9	36	1308	3	arpents
arracks	13	8	773	3	arracks
arrange	8	3	868	3	arrange
arranges	9	3	941	3	arranges
arrantly	11	5	610	3	arrantly
arras	5	56	2613	3	arra__s
arrases	7	12	1454	3	arrases
arrays	9	53	1168	3	arra_ys
arrests	7	33	1268	3	arrests
bezants	18	7	734	3	bezants
bezzants	18	4	364	3	bezzants
boranes	9	37	2040	3	boranes
bracts	10	56	1777	3	_bracts
brands	9	51	1894	3	_brands
branks	12	48	1738	3	_branks
brans	7	54	3743	3	_bran_s
brant	7	47	4217	3	_brant_
brats	7	53	3601	3	_bra_ts
breasts	9	3	970	3	breasts
brents	8	47	1727	3	_brents
brunts	8	52	1545	3	_brunts
burans	8	50	1930	3	buran_s
byzants	21	5	322	3	byzants
cants	7	70	3694	3	__cants
carats	8	59	2902	3	cara_ts
chants	11	50	2039	3	_chants
coranto	9	3	1189	3	coranto
corantos	10	3	1010	3	corantos
courants	10	3	1080	3	courants
crafts	11	53	1274	3	_crafts
cranes	8	43	3075	3	_cranes
cranks	12	50	1531	3	_cranks
currans	9	3	1061	3	curran_s
currant	9	3	1417	3	currant_
currents	10	3	837	3	currents
decants	10	35	1444	3	decants
derats	7	46	2506	3	dera_ts
descants	11	29	1014	3	descants
detracts	11	13	883	3	detracts
deviants	12	3	673	3	deviants
dopants	10	3	843	3	dopants
drafts	10	50	1253	3	_drafts
drats	6	66	2837	3	_dra_ts
earings	8	45	1771	3	earings
earns	5	59	2756	3	ear_n_s
earrings	9	29	963	3	earrings
easts	5	75	3032	3	e__asts
eats	4	70	5487	3	e__a_ts
eclats	8	3	1303	3	ecla_ts
egrets	7	27	1224	3	egr_ets
elands	7	49	1477	3	e_lands
elans	5	55	2775	3	e_lan_s
elints	6	58	1642	3	e_lints
eluant	6	3	1509	3	eluant_
eluents	7	3	870	3	eluents
embanks	15	29	570	3	embanks
emigrants	12	4	473	3	emigrants
enacts	8	40	1297	3	e_nacts
enchants	13	4	783	3	enchants
engrafts	12	9	470	3	engrafts
enrages	8	31	1485	3	enrages
enrapt	8	3	1301	3	enrapt_
enroots	7	3	871	3	enroots
entrant	7	3	1887	3	entrant_
epacts	10	50	1039	3	e_pacts
eras	4	54	4150	3	e_ra__s
erases	6	44	2540	3	e_rases
erects	8	41	1618	3	e_rects
ergate	7	3	1514	3	erga_te
ergates	8	3	1449	3	ergates
ergots	7	45	1237	3	e_rgots
ermines	9	4	1667	3	ermines
ernes	5	52	2481	3	e_r_nes
erns	4	54	2823	3	e_r_n_s
errable	9	3	1218	3	errable
errancies	11	4	796	3	errancies
errantries	10	4	494	3	errant~~rie~~s
erratic	9	3	1112	3	erratic
erratics	10	4	698	3	erratics
erratum	9	4	451	3	erratum
errhines	11	3	641	3	errhines
erring	7	38	1648	3	errin_g
errors	6	33	1131	3	err_ors
errs	4	56	2253	3	err___s
ersatz	15	3	665	3	ersa_tz
eructs	8	36	1079	3	e_ructs
erupts	8	34	890	3	e_rupts
etchants	13	4	602	3	etchants
ethanes	10	37	1351	3	ethanes
events	9	48	1407	3	e_vents
exacts	15	35	961	3	e_xacts
exalts	13	32	831	3	e_xalts
expands	17	19	573	3	expands
expats	15	3	768	3	expa_ts
explants	17	3	702	3	explants
extant	13	27	1475	3	extant_
extents	14	26	1017	3	extents
extracts	17	4	762	3	extracts
extranets	16	4	636	3	extranets
eyras	8	47	1592	3	eyra__s
ferments	13	3	1147	3	ferments
ferrate	10	30	1404	3	ferra_te
ferrates	11	30	1342	3	ferrates
ferrets	10	31	1139	3	ferr_ets
forints	10	4	1183	3	forints
formants	13	26	995	3	formants
francs	11	41	1219	3	_francs
franks	13	49	1273	3	_franks
frats	8	68	2967	3	_fra_ts
fronts	9	44	1579	3	_fronts
furanes	10	32	1486	3	furanes
furans	9	45	1595	3	furan_s
gelants	8	26	1144	3	gelants
gellants	9	30	828	3	gellants
gerents	8	26	1292	3	gerents
germans	10	7	947	3	german_s
giants	7	47	1350	3	_giants
grafts	10	50	1325	3	_grafts
grands	8	42	1824	3	_grands
grans	6	48	3254	3	_gran_s
grant	6	48	4002	3	_grant_
greats	7	63	1839	3	grea_ts
groans	7	48	1506	3	groan_s
groats	7	48	1665	3	groa_ts
grunts	7	55	1185	3	_grunts
hants	8	63	3540	3	__hants
herrings	12	37	953	3	herrings
hydrants	15	8	579	3	hydrants
incants	9	20	1280	3	incants
inerrant	8	4	1249	3	inerrant_
infants	10	22	1077	3	infants
intrants	8	3	1286	3	intrants
irritants	9	4	461	3	irritants
irrupts	9	4	373	3	irrupts
jurant	13	42	1655	3	jurant_
jurats	13	42	1320	3	jura_ts
karats	10	64	2049	3	kara_ts
korats	10	54	1606	3	kora_ts
krafts	13	43	885	3	_krafts
kraits	10	49	1220	3	_kraits
krauts	10	41	851	3	_krauts
levants	10	3	772	3	levants
lorans	6	51	1760	3	loran_s
maranta	9	3	1169	3	maranta
marantas	10	3	1002	3	marantas
marranos	10	3	842	3	marranos
mediants	11	29	949	3	mediants
merchants	16	4	622	3	merchants
migrants	11	3	818	3	migrants
mordants	11	3	714	3	mordants
mutants	9	3	858	3	mutants
octants	9	12	873	3	octants
odorants	9	4	604	3	odorants
operants	10	3	948	3	operants
orangs	7	41	1603	3	_orangs
organs	7	9	1291	3	organ_s
orients	7	3	1158	3	orients
ourangs	8	31	850	3	ourangs
pants	7	65	3692	3	__pants
parangs	10	43	1437	3	parangs
parents	9	34	1812	3	parents
peasants	10	3	826	3	peasants
pedants	10	3	1011	3	pedants
pendants	11	3	909	3	pendants
pennants	10	3	706	3	pennants
percents	12	27	1337	3	percents
perianth	13	4	855	3	perianth
perianths	14	4	547	3	perianths
periapts	12	3	727	3	periapts
perpents	12	23	1204	3	perpents
perrons	9	31	1548	3	perron_s
persalts	10	3	819	3	persalts
piranas	9	9	1260	3	piranas
plants	8	49	2180	3	_plants
prangs	9	48	1623	3	_prangs
pranks	12	48	1472	3	_pranks
prats	7	63	3339	3	_pra_ts
preacts	11	32	1136	3	preacts
prints	8	43	2010	3	_prints
puranas	9	7	1264	3	puranas
pyrans	11	4	1106	3	pyran_s
quants	15	36	1414	3	_quants
rafts	8	78	2063	3	__rafts
rands	6	59	3045	3	__rands
ranis	5	52	3583	3	__ranis
ranks	9	52	2573	3	__ranks
rant	4	58	6468	3	__rant_
rats	4	62	6037	3	__ra_ts
reacts	8	36	1660	3	_reacts
rebaits	9	3	1257	3	rebaits
recanes	9	32	2226	3	recanes
recant	8	32	2868	3	recant_
recasts	9	34	1353	3	recasts
recreants	11	4	662	3	recreants
redacts	10	5	1094	3	redacts
redans	7	54	2102	3	redan_s
redrafts	12	3	560	3	redrafts
refracts	13	13	738	3	refracts
refronts	11	3	777	3	refronts
regents	8	34	1654	3	regents
regrafts	12	3	530	3	regrafts
regrant	8	3	1732	3	regrant_
rehangs	11	3	756	3	rehangs
relands	8	52	1488	3	relands
relents	7	40	1850	3	relents
remands	10	49	1488	3	remands
remans	8	48	2300	3	reman_s
remints	9	51	1729	3	remints
remnants	10	3	684	3	remnants
rents	5	59	3518	3	__rents
repaints	10	3	848	3	repaints
repasts	9	36	1193	3	repasts
repents	9	37	1762	3	repents
replants	10	28	1124	3	replants
reprints	10	3	990	3	reprints
reracks	13	23	1053	3	reracks
reran	5	73	2910	3	reran__
rerent	6	38	3245	3	rerent_
reruns	6	64	1374	3	rerun_s
resents	7	42	2122	3	resents
retints	7	47	1701	3	retints
retirants	9	4	732	3	retirants
retracts	10	11	1131	3	retracts
riant	5	58	3315	3	_riant_
roans	5	49	2644	3	_roan_s
roasts	6	49	1541	3	_roasts
ruanas	6	3	1126	3	_ruanas
runts	5	59	2763	3	__runts
sarans	6	42	2443	3	saran_s
savants	10	3	865	3	savants
scants	8	52	1972	3	_scants
sealants	8	26	1074	3	sealants
seawants	11	33	797	3	seawants
secants	9	34	1389	3	secants
sergeants	10	11	559	3	sergeants
serjeants	16	7	396	3	serjeants
serpents	10	24	1037	3	serpents
serranid	9	4	757	3	serranid
serranids	10	4	553	3	serranids
serrano	7	6	846	3	serran_o
serrate	7	30	1754	3	serra_te
serrates	8	26	1702	3	serrates
servant	10	3	1363	3	servant_
sextants	15	28	738	3	sextants
slants	6	48	1908	3	_slants
sonants	7	5	1123	3	sonants
spirants	10	8	828	3	spirants
sprangs	10	46	1005	3	sprangs
sprats	8	58	1993	3	spra_ts
sprints	9	41	1377	3	sprints
straits	7	49	1632	3	straits
strands	8	37	1195	3	strands
strunts	7	42	954	3	strunts
tarantas	8	3	919	3	tarantas
tenants	7	3	1101	3	tenants
terraces	10	27	1225	3	terraces
terrains	8	4	1032	3	terrains
terrane	7	28	1423	3	terran_e
terras	6	35	1697	3	terra__s
terrases	8	21	1148	3	terrases
terrenes	8	22	1260	3	terrenes
terrets	7	29	1358	3	terr_ets
terrines	8	21	1755	3	terrines
territs	7	27	1450	3	terr_its
titrants	8	3	848	3	titrants
torrents	8	3	814	3	torrents
tracts	8	50	1907	3	_tracts
traits	6	51	2198	3	_traits
tranks	10	40	1776	3	_tranks
tranqs	15	52	1031	3	_tranqs
trans	5	49	3304	3	_tran_s
treats	6	48	2169	3	trea_ts
truant	6	3	1578	3	truant_
tyrant	9	3	1533	3	tyrant_
vagrants	12	4	614	3	vagrants
variants	11	3	920	3	variants
verdant	11	3	1329	3	verdant_
versant	10	3	1383	3	versant_
vibrants	13	4	591	3	vibrants
wants	8	79	3221	3	__wants
warrant	10	6	1424	3	warrant_
warranty	14	6	504	3	warranty
wrangs	10	46	1191	3	_wrangs
zebranos	19	4	371	3	zebranos

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	134027	0.483	369960.7
2	DLD Change Limit	134027	319	7.720	17361.0
3	Display Results	319	319	0.126	2531.7
	(SQL Overall)	178691	319	8.329	21454.1