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

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

401 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
errant	6	6	1873	(None)
arrant	6	6	2325	1	arrant
errand	7	5	879	1	errand
errants	7	4	1064	1	errants
aberrant	10	4	954	2	aberrant
brant	7	47	4217	2	_brant
currant	9	3	1417	2	currant
eluant	6	3	1509	2	eluant
enrapt	8	3	1301	2	enrapt
entrant	7	3	1887	2	entrant
errancy	12	5	636	2	errancy
errands	8	4	760	2	errands
errantly	11	7	579	2	errantly
errantry	11	11	346	2	errantry
errata	6	3	901	2	errata
erring	7	38	1648	2	erring
extant	13	27	1475	2	extant
grant	6	48	4002	2	_grant
inerrant	8	4	1249	2	inerrant
jurant	13	42	1655	2	jurant
rant	4	58	6468	2	__rant
recant	8	32	2868	2	recant
regrant	8	3	1732	2	regrant
reran	5	73	2910	2	reran_
rerent	6	38	3245	2	rerent
riant	5	58	3315	2	_riant
serrano	7	6	846	2	serrano
servant	10	3	1363	2	servant
terrane	7	28	1423	2	terrane
truant	6	3	1578	2	truant
tyrant	9	3	1533	2	tyrant
verdant	11	3	1329	2	verdant
versant	10	3	1383	2	versant
warrant	10	6	1424	2	warrant
aberrants	11	4	585	3	aberrants
alant	5	57	4229	3	_alant
ant	3	72	7079	3	___ant
arcana	8	9	1258	3	arcana
arcane	8	12	1674	3	arcane
ardent	7	30	2261	3	ardent
argent	7	40	2366	3	argent
arhat	8	3	2709	3	arha_t
aroint	6	3	2815	3	aroint
aroynt	9	3	1289	3	aroynt
arpent	8	48	2209	3	arpent
arrack	12	11	1025	3	arrack
arrange	8	3	868	3	arrange
arrantly	11	5	610	3	arrantly
arras	5	56	2613	3	arra_s
array	8	63	1714	3	arra_y
arrays	9	53	1168	3	arrays
arrest	6	37	2263	3	arrest
arrogant	9	4	915	3	arrogant
askant	10	4	1271	3	askant
aslant	6	3	1775	3	aslant
avant	8	62	2466	3	_avant
bewrapt	14	14	713	3	bewrapt
bezant	17	8	1454	3	bezant
bezzant	17	4	689	3	bezzant
borane	8	46	2021	3	borane
bract	9	63	3272	3	_bract
bran	6	57	4038	3	_bran_
brand	8	51	2449	3	_brand
brank	11	52	2228	3	_brank
brans	7	54	3743	3	_brans
brants	8	57	2305	3	_brants
brat	6	60	5554	3	_bra_t
breast	8	3	1963	3	breast
brent	7	57	3413	3	_brent
brisant	9	3	1268	3	brisant
brunt	7	57	2875	3	_brunt
buran	7	52	2530	3	buran_
burans	8	50	1930	3	burans
burnt	7	52	3033	3	bur_nt
byzant	20	9	681	3	byzant
cant	6	63	6203	3	__cant
carat	7	50	4879	3	cara_t
chant	10	59	3269	3	_chant
coranto	9	3	1189	3	coranto
courant	9	3	1797	3	courant
craft	10	53	2766	3	_craft
crane	7	53	3160	3	_crane
crank	11	48	1961	3	_crank
curran	8	3	1202	3	curran_
currans	9	3	1061	3	currans
currants	10	3	793	3	currants
current	9	3	1369	3	current
decant	9	35	2422	3	decant
defiant	11	3	1192	3	defiant
derat	6	50	4408	3	dera_t
descant	10	43	1559	3	descant
detract	10	14	1463	3	detract
deviant	11	3	1131	3	deviant
dopant	9	3	1613	3	dopant
dormant	10	28	1437	3	dormant
draft	9	55	2668	3	_draft
drank	10	48	1620	3	_drank
drat	5	62	4783	3	_dra_t
dreamt	9	46	1571	3	dreamt
earing	7	52	3548	3	earing
earn	4	67	3755	3	ear_n_
earns	5	59	2756	3	ear_ns
earring	8	35	1901	3	earring
east	4	66	5910	3	e__ast
eat	3	69	8905	3	e__a_t
eclat	7	5	2360	3	ecla_t
egret	6	33	2731	3	egr_et
elan	4	67	3424	3	e_lan_
eland	6	58	2039	3	e_land
elans	5	55	2775	3	e_lans
elegant	8	3	1150	3	elegant
elint	5	54	3647	3	e_lint
eluants	7	3	758	3	eluants
eluent	6	3	1548	3	eluent
emanant	9	4	1109	3	emanant
embank	14	34	655	3	embank
emigrant	11	4	856	3	emigrant
enact	7	35	2536	3	e_nact
enchant	12	3	1313	3	enchant
engraft	11	11	862	3	engraft
enrage	7	27	1507	3	enrage
enroot	6	6	1599	3	enroot
entrants	8	3	1175	3	entrants
epact	9	49	2153	3	e_pact
era	3	57	4150	3	e_ra__
eras	4	54	4150	3	e_ra_s
erase	5	49	2549	3	e_rase
erect	7	41	2933	3	e_rect
ergate	7	3	1514	3	ergate
ergot	6	54	2289	3	e_rgot
ermine	8	4	1692	3	ermine
ern	3	57	3836	3	e_r_n_
erne	4	67	2743	3	e_r_ne
erns	4	54	2823	3	e_r_ns
erodent	8	3	1382	3	erodent
err	3	56	2653	3	err___
errable	9	3	1218	3	errable
erratas	7	3	686	3	erratas
erratic	9	3	1112	3	erratic
erratum	9	4	451	3	erratum
erred	6	59	1567	3	err_ed
errhine	10	3	659	3	errhine
error	5	37	1223	3	err_or
errors	6	33	1131	3	errors
errs	4	56	2253	3	err__s
ersatz	15	3	665	3	ersatz
erst	4	74	3643	3	e_r_st
eruct	7	40	2235	3	e_ruct
erupt	7	42	2006	3	e_rupt
etchant	12	4	982	3	etchant
ethane	9	46	1324	3	ethane
event	8	59	2444	3	e_vent
exact	14	35	1693	3	e_xact
exalt	12	30	1853	3	e_xalt
exeunt	13	3	870	3	exeunt
expand	16	23	657	3	expand
expat	14	3	1381	3	expa_t
explant	16	3	1013	3	explant
extent	13	27	1491	3	extent
extract	16	3	1101	3	extract
extranet	15	4	1299	3	extranet
eyra	7	62	1755	3	eyra__
eyras	8	47	1592	3	eyra_s
ferment	12	3	1557	3	ferment
ferrate	10	30	1404	3	ferrate
ferret	9	30	2117	3	ferr_et
fervent	13	3	1006	3	fervent
forint	9	3	2502	3	forint
formant	12	34	1600	3	formant
fragrant	12	4	711	3	fragrant
franc	10	46	1541	3	_franc
frank	12	44	1751	3	_frank
frat	7	56	4854	3	_fra_t
front	8	50	2922	3	_front
furan	8	43	2001	3	furan_
furane	9	40	1549	3	furane
furans	9	45	1595	3	furans
gardant	9	3	1446	3	gardant
gelant	7	28	2167	3	gelant
gellant	8	32	1405	3	gellant
gerent	7	32	2310	3	gerent
german	9	6	1198	3	german_
germane	10	4	966	3	germane
germans	10	7	947	3	germans
giant	6	54	3059	3	_giant
graft	9	53	2720	3	_graft
gran	5	63	3501	3	_gran_
grana	6	57	2209	3	_grana
grand	7	51	2269	3	_grand
grans	6	48	3254	3	_grans
grants	7	37	2247	3	_grants
grat	5	56	5128	3	_gra_t
great	6	60	3424	3	grea_t
groan	6	56	1842	3	groan_
groans	7	48	1506	3	groans
groat	6	55	3197	3	groa_t
grunt	6	55	2354	3	_grunt
hant	7	54	6159	3	__hant
hereat	9	35	2741	3	herea_t
herring	11	36	1588	3	herring
horrent	10	3	1355	3	horrent
hydrant	14	8	905	3	hydrant
incant	8	24	1851	3	incant
infant	9	23	1513	3	infant
intrant	7	3	1875	3	intrant
irritant	8	4	769	3	irritant
irrupt	8	4	699	3	irrupt
iterant	7	3	1778	3	iterant
jessant	14	3	844	3	jessant
jurants	14	37	921	3	jurants
jurat	12	48	2932	3	jura_t
karat	9	68	3760	3	kara_t
korat	9	49	3443	3	kora_t
kraft	12	57	2101	3	_kraft
krait	9	47	2677	3	_krait
kraut	9	52	2140	3	_kraut
leant	5	67	3778	3	_leant
learnt	6	40	1925	3	lear_nt
levant	9	3	1449	3	levant
loran	5	59	2509	3	loran_
lorans	6	51	1760	3	lorans
maranta	9	3	1169	3	maranta
marrano	9	3	942	3	marrano
meant	7	65	3721	3	_meant
mediant	10	35	1670	3	mediant
merchant	15	4	882	3	merchant
merman	10	5	1386	3	merman_
migrant	10	3	1431	3	migrant
mordant	10	3	1240	3	mordant
mutant	8	3	1769	3	mutant
natant	6	3	1873	3	natant
nutant	6	3	1638	3	nutant
octant	8	12	1655	3	octant
odorant	8	4	1139	3	odorant
operant	9	3	1722	3	operant
orang	6	51	1994	3	_orang
organ	6	9	1539	3	organ_
organa	7	8	921	3	organa
organs	7	9	1291	3	organs
orient	6	3	2253	3	orient
orra	4	61	2072	3	orra__
ourang	7	33	1106	3	ourang
overran	10	3	1166	3	overran_
overrank	15	4	811	3	overrank
pant	6	60	6126	3	__pant
parang	9	37	1551	3	parang
parent	8	32	3042	3	parent
peasant	9	3	1492	3	peasant
peccant	13	3	1173	3	peccant
pedant	9	3	1949	3	pedant
pendant	10	3	1485	3	pendant
pennant	9	3	1249	3	pennant
percent	11	35	2060	3	percent
perianth	13	4	855	3	perianth
periapt	11	3	1341	3	periapt
permeant	12	3	1091	3	permeant
perpent	11	23	1881	3	perpent
perron	8	32	1662	3	perron_
perrons	9	31	1548	3	perrons
persalt	9	3	1541	3	persalt
pirana	8	7	1326	3	pirana
plant	7	54	3711	3	_plant
pliant	8	39	1882	3	pliant
prang	8	48	2032	3	_prang
prank	11	50	1945	3	_prank
prat	6	59	5204	3	_pra_t
preact	10	32	2039	3	preact
print	7	48	3746	3	_print
purana	8	7	1293	3	purana
pyran	10	5	1447	3	pyran_
pyrans	11	4	1106	3	pyrans
quant	14	36	2481	3	_quant
raft	7	62	4591	3	__raft
ran	3	82	6662	3	__ran_
rand	5	58	3957	3	__rand
rang	5	69	3917	3	__rang
rani	4	66	4011	3	__rani
rank	8	51	3553	3	__rank
rants	5	59	3534	3	__rants
rapt	6	72	4531	3	__rapt
rat	3	78	9274	3	__ra_t
react	7	46	3433	3	_react
rebait	8	3	2040	3	rebait
reboant	9	3	1509	3	reboant
recane	8	30	2287	3	recane
recants	9	32	1709	3	recants
recast	8	34	2277	3	recast
recent	8	36	3085	3	recent
recreant	10	3	1128	3	recreant
redact	9	4	1904	3	redact
redan	6	61	2501	3	redan_
redans	7	54	2102	3	redans
redraft	11	3	1057	3	redraft
refract	12	13	1160	3	refract
refront	10	3	1326	3	refront
regent	7	41	2767	3	regent
regnant	8	3	1284	3	regnant
regraft	11	3	1015	3	regraft
regrants	9	3	1001	3	regrants
rehang	10	3	982	3	rehang
reland	7	59	2043	3	reland
relent	6	44	3185	3	relent
reliant	7	3	1924	3	reliant
reman	7	57	3015	3	reman_
remand	9	56	1896	3	remand
remans	8	48	2300	3	remans
remint	8	53	2998	3	remint
remnant	9	3	1264	3	remnant
rent	4	66	6124	3	__rent
repaint	9	3	1836	3	repaint
repand	9	53	1606	3	repand
repast	8	35	2063	3	repast
repent	8	47	2887	3	repent
replant	9	33	1853	3	replant
reprint	9	3	1898	3	reprint
reptant	9	28	1707	3	reptant
rerack	12	25	1316	3	rerack
rerents	7	33	1942	3	rerents
rerun	5	87	2215	3	rerun_
reruns	6	64	1374	3	reruns
resat	5	51	3968	3	resa_t
resent	6	38	3362	3	resent
retint	6	56	3344	3	retint
retirant	8	3	1359	3	retirant
retract	9	13	1811	3	retract
rewan	8	56	2366	3	rewan_
rewrapt	12	13	811	3	rewrapt
roan	4	72	3420	3	_roan_
roans	5	49	2644	3	_roans
roast	5	62	3014	3	_roast
ruana	5	3	1242	3	_ruana
runt	4	66	4799	3	__runt
saran	5	37	3030	3	saran_
sarans	6	42	2443	3	sarans
savant	9	4	1604	3	savant
scant	7	97	3507	3	_scant
sealant	7	31	1830	3	sealant
seawant	10	36	1341	3	seawant
secant	8	40	2329	3	secant
sejant	13	31	1448	3	sejant
sejeant	14	8	972	3	sejeant
sergeant	9	12	940	3	sergeant
serjeant	15	9	647	3	serjeant
serpent	9	29	1628	3	serpent
serranid	9	4	757	3	serranid
serranos	8	5	787	3	serranos
serrate	7	30	1754	3	serrate
servants	11	3	800	3	servants
sextant	14	29	1196	3	sextant
shrank	13	35	912	3	shrank
sierran	7	3	719	3	sierran_
slant	5	52	3870	3	_slant
sonant	6	6	2195	3	sonant
spirant	9	8	1429	3	spirant
sprang	9	57	1352	3	sprang
sprat	7	66	3597	3	spra_t
sprent	8	45	2238	3	sprent
sprint	8	45	2679	3	sprint
strait	6	40	2589	3	strait
strand	7	45	1482	3	strand
strang	7	57	1831	3	strang
strunt	6	49	1891	3	strunt
tenant	6	3	2247	3	tenant
terra	5	44	1967	3	terra__
terrace	9	33	1184	3	terrace
terrae	6	29	1521	3	terra_e
terrain	7	4	1085	3	terrain
terrains	8	4	1032	3	terrains
terranes	8	25	1443	3	terranes
terras	6	35	1697	3	terra_s
terrene	7	24	1103	3	terrene
terret	6	34	2562	3	terr_et
terrine	7	25	1757	3	terrine
territ	6	34	2138	3	terr_it
titrant	7	3	1519	3	titrant
torrent	7	3	1341	3	torrent
tract	7	56	3571	3	_tract
trait	5	69	4084	3	_trait
trank	9	62	2242	3	_trank
tranq	14	54	1689	3	_tranq
trans	5	49	3304	3	_trans
trapt	7	64	3339	3	_trapt
treat	5	62	4035	3	trea_t
truants	7	3	816	3	truants
tyrants	10	3	745	3	tyrants
unrent	6	32	1978	3	unrent
urban	7	20	1386	3	urban_
urbane	8	22	1138	3	urbane
urgent	7	38	1604	3	urgent
vacant	11	4	1513	3	vacant
vagrant	11	4	1066	3	vagrant
variant	10	3	1680	3	variant
versants	11	3	778	3	versants
vibrant	12	4	1039	3	vibrant
volant	9	3	1632	3	volant
want	7	61	5617	3	__want
warrants	11	6	850	3	warrants
warranty	14	6	504	3	warranty
wrang	9	47	1611	3	_wrang
wrapt	10	51	2318	3	_wrapt
zebrano	18	4	385	3	zebrano

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	112716	0.390	458182.1
2	DLD Change Limit	112716	401	5.890	19136.8
3	Display Results	401	401	0.143	2804.2
	(SQL Overall)	178691	401	6.423	27820.5