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

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

309 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
errand	7	5	879	(None)
errands	8	4	760	1	errands
errant	6	6	1873	1	errant
arrant	6	6	2325	2	arrant
brand	8	51	2449	2	_brand
eland	6	58	2039	2	e_land
errancy	12	5	636	2	errancy
errants	7	4	1064	2	errants
errata	6	3	901	2	errata
erred	6	59	1567	2	err_ed
erring	7	38	1648	2	erring
expand	16	23	657	2	expand
grand	7	51	2269	2	_grand
rand	5	58	3957	2	__rand
reland	7	59	2043	2	reland
remand	9	56	1896	2	remand
repand	9	53	1606	2	repand
reran	5	73	2910	2	reran_
serranid	9	4	757	2	serranid
serrano	7	6	846	2	serrano
strand	7	45	1482	2	strand
terrane	7	28	1423	2	terrane
aberrant	10	4	954	3	aberrant
afraid	10	4	972	3	afraid
aland	6	55	2641	3	_aland
and	4	72	4417	3	___and
arcana	8	9	1258	3	arcana
arcane	8	12	1674	3	arcane
armband	12	6	598	3	armband
around	7	27	1241	3	around
arrack	12	11	1025	3	arrack
arrange	8	3	868	3	arrange
arranged	10	3	693	3	arranged
arras	5	56	2613	3	arra_s
arrased	8	14	986	3	arrased
array	8	63	1714	3	arra_y
arrayed	11	11	715	3	arrayed
arrays	9	53	1168	3	arrays
band	7	67	4092	3	__band
berried	10	37	1405	3	berried
bland	8	53	2045	3	_bland
borane	8	46	2021	3	borane
brad	7	52	3434	3	_bra_d
braid	8	58	2226	3	_braid
bran	6	57	4038	3	_bran_
brands	9	51	1894	3	_brands
brandy	12	47	1206	3	_brandy
brank	11	52	2228	3	_brank
brans	7	54	3743	3	_brans
brant	7	47	4217	3	_brant
bread	8	55	2311	3	brea_d
briard	9	43	1129	3	briard
brigand	11	3	664	3	brigand
broad	8	48	1769	3	broa_d
buran	7	52	2530	3	buran_
burans	8	50	1930	3	burans
crane	7	53	3160	3	_crane
craned	9	61	2165	3	_craned
crank	11	48	1961	3	_crank
curran	8	3	1202	3	curran_
currans	9	3	1061	3	currans
currant	9	3	1417	3	currant
defraud	12	4	391	3	defraud
demand	10	43	1425	3	demand
deodand	10	3	571	3	deodand
desand	8	48	1263	3	desand
drank	10	48	1620	3	_drank
dread	7	44	1902	3	drea_d
drownd	11	47	831	3	drownd
dryad	10	47	758	3	drya_d
dryland	12	5	430	3	dryland
earbud	9	3	628	3	earbud
eared	6	51	3950	3	ear_ed
earing	7	52	3548	3	earing
earn	4	67	3755	3	ear_n_
earned	7	48	1833	3	earned
earns	5	59	2756	3	ear_ns
earring	8	35	1901	3	earring
echard	12	4	922	3	echard
egad	6	42	1541	3	e_ga_d
elan	4	67	3424	3	e_lan_
elands	7	49	1477	3	e_lands
elans	5	55	2775	3	e_lans
eluant	6	3	1509	3	eluant
embank	14	34	655	3	embank
emend	8	62	1489	3	e_mend
emerald	10	4	692	3	emerald
end	4	68	3435	3	e___nd
enrage	7	27	1507	3	enrage
enraged	9	35	1178	3	enraged
enrapt	8	3	1301	3	enrapt
entrant	7	3	1887	3	entrant
enwind	10	29	808	3	enwind
era	3	57	4150	3	e_ra__
eras	4	54	4150	3	e_ra_s
erase	5	49	2549	3	e_rase
erased	7	48	1676	3	erased
ergate	7	3	1514	3	ergate
ermine	8	4	1692	3	ermine
ermined	10	4	1060	3	ermined
ern	3	57	3836	3	e_r_n_
erne	4	67	2743	3	e_r_ne
erns	4	54	2823	3	e_r_ns
eroded	8	43	1359	3	eroded
err	3	56	2653	3	err___
errable	9	3	1218	3	errable
errantly	11	7	579	3	errantly
errantry	11	11	346	3	errantry
erratas	7	3	686	3	erratas
erratic	9	3	1112	3	erratic
erratum	9	4	451	3	erratum
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
ethane	9	46	1324	3	ethane
expands	17	19	573	3	expands
expend	16	24	750	3	expend
extant	13	27	1475	3	extant
extend	14	26	752	3	extend
eyra	7	62	1755	3	eyra__
eyras	8	47	1592	3	eyra_s
farad	9	57	2067	3	fara_d
fenland	11	3	569	3	fenland
ferrate	10	30	1404	3	ferrate
ferried	11	34	1153	3	ferried
franc	10	46	1541	3	_franc
frank	12	44	1751	3	_frank
fraud	9	3	986	3	_fraud
friend	10	38	893	3	friend
frond	9	53	1634	3	_frond
furan	8	43	2001	3	furan_
furane	9	40	1549	3	furane
furans	9	45	1595	3	furans
garland	9	4	870	3	garland
german	9	6	1198	3	german_
germane	10	4	966	3	germane
germans	10	7	947	3	germans
gerund	8	3	616	3	gerund
gland	7	52	1771	3	_gland
gormand	11	5	745	3	gormand
grad	6	68	2986	3	_gra_d
gran	5	63	3501	3	_gran_
grana	6	57	2209	3	_grana
grands	8	42	1824	3	_grands
grans	6	48	3254	3	_grans
grant	6	48	4002	3	_grant
grind	7	59	1756	3	_grind
groan	6	56	1842	3	groan_
groaned	9	25	997	3	groaned
groans	7	48	1506	3	groans
ground	8	23	1027	3	ground
hand	8	68	3371	3	__hand
herald	10	3	1134	3	herald
herried	11	35	1446	3	herried
herring	11	36	1588	3	herring
inerrant	8	4	1249	3	inerrant
inland	7	3	1031	3	inland
island	7	3	853	3	island
jerreed	15	3	521	3	jerreed
jerrid	14	25	914	3	jerr_id
jurant	13	42	1655	3	jurant
land	5	63	3731	3	__land
ligand	8	50	1129	3	ligand
loran	5	59	2509	3	loran_
lorans	6	51	1760	3	lorans
maraud	9	3	894	3	maraud
marrano	9	3	942	3	marrano
mermaid	12	9	785	3	mermaid
merman	10	5	1386	3	merman_
norland	8	3	716	3	norland
operand	10	3	800	3	operand
orad	5	60	3169	3	_ora_d
orang	6	51	1994	3	_orang
oread	6	46	1960	3	orea_d
organ	6	9	1539	3	organ_
organa	7	8	921	3	organa
organdy	12	5	457	3	organdy
organs	7	9	1291	3	organs
orra	4	61	2072	3	orra__
ourang	7	33	1106	3	ourang
overhand	15	22	996	3	overhand
overland	12	23	1200	3	overland
overran	10	3	1166	3	overran_
overrank	15	4	811	3	overrank
parang	9	37	1551	3	parang
perpend	12	25	935	3	perpend
perron	8	32	1662	3	perron_
perrons	9	31	1548	3	perrons
pirana	8	7	1326	3	pirana
prang	8	48	2032	3	_prang
prank	11	50	1945	3	_prank
proband	12	27	1024	3	proband
purana	8	7	1293	3	purana
pyran	10	5	1447	3	pyran_
pyrans	11	4	1106	3	pyrans
rad	4	76	6200	3	__ra_d
raid	5	52	4307	3	__raid
ran	3	82	6662	3	__ran_
rands	6	59	3045	3	__rands
randy	9	50	2208	3	__randy
rang	5	69	3917	3	__rang
rani	4	66	4011	3	__rani
ranid	6	64	2933	3	__ranid
rank	8	51	3553	3	__rank
rant	4	58	6468	3	__rant
rared	6	57	3832	3	_rared
read	5	59	4253	3	_rea_d
readd	7	46	1713	3	_readd
reared	7	59	3001	3	reared
rebind	9	44	1693	3	rebind
recane	8	30	2287	3	recane
recaned	10	28	1720	3	recaned
recant	8	32	2868	3	recant
redan	6	61	2501	3	redan_
redans	7	54	2102	3	redans
refind	10	47	1707	3	refind
refund	10	48	1030	3	refund
regard	8	52	1577	3	regard
regrant	8	3	1732	3	regrant
regrind	9	3	898	3	regrind
rehang	10	3	982	3	rehang
relaid	7	55	1844	3	relaid
relands	8	52	1488	3	relands
relend	7	61	1645	3	relend
reman	7	57	3015	3	reman_
remands	10	49	1488	3	remands
remans	8	48	2300	3	remans
remend	9	52	1655	3	remend
remind	9	48	1979	3	remind
rend	5	61	3657	3	__rend
repaid	9	47	1632	3	repaid
rerack	12	25	1316	3	rerack
reread	7	17	1543	3	reread
rerent	6	38	3245	3	rerent
rerun	5	87	2215	3	rerun_
reruns	6	64	1374	3	reruns
resaid	7	45	1708	3	resaid
resend	7	50	1677	3	resend
retard	7	50	1893	3	retard
rewan	8	56	2366	3	rewan_
reward	10	60	1764	3	reward
rewind	10	47	1588	3	rewind
riant	5	58	3315	3	_riant
riband	9	23	962	3	riband
rind	5	65	3560	3	__rind
road	5	63	3211	3	_roa_d
roan	4	72	3420	3	_roan_
roans	5	49	2644	3	_roans
roband	9	23	1072	3	roband
round	6	43	1843	3	_round
ruana	5	3	1242	3	_ruana
rynd	8	64	1410	3	__rynd
sand	5	53	3847	3	__sand
saran	5	37	3030	3	saran_
sarans	6	42	2443	3	sarans
serranids	10	4	553	3	serranids
serranoid	10	4	520	3	serranoid
serranos	8	5	787	3	serranos
serrate	7	30	1754	3	serrate
serrated	9	25	1343	3	serrated
serried	8	25	1397	3	serried
servant	10	3	1363	3	servant
shrank	13	35	912	3	shrank
sierran	7	3	719	3	sierran_
soland	7	51	1504	3	soland
sprang	9	57	1352	3	sprang
stand	6	59	2328	3	_stand
strands	8	37	1195	3	strands
strang	7	57	1831	3	strang
terra	5	44	1966	3	terra__
terrace	9	33	1184	3	terrace
terraced	11	31	812	3	terraced
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
terrine	7	25	1757	3	terrine
tetrad	7	36	1205	3	tetra_d
trad	5	56	3091	3	_tra_d
trank	9	62	2242	3	_trank
tranq	14	54	1689	3	_tranq
trans	5	49	3304	3	_trans
tread	6	48	2170	3	trea_d
trend	6	48	1745	3	_trend
triad	6	52	1772	3	tria_d
troland	8	3	754	3	troland
truant	6	3	1578	3	truant
tyrant	9	3	1533	3	tyrant
unhand	10	4	1038	3	unhand
upland	9	3	886	3	upland
urban	7	20	1386	3	urban_
urbane	8	22	1138	3	urbane
veranda	11	5	632	3	veranda
verdant	11	3	1329	3	verdant
versant	10	3	1383	3	versant
viand	9	5	1107	3	_viand
wand	8	58	3388	3	__wand
warrant	10	6	1424	3	warrant
weasand	11	3	550	3	weasand
weazand	20	4	361	3	weazand
wessand	11	4	483	3	wessand
wetland	11	3	535	3	wetland
wrang	9	47	1611	3	_wrang
yearend	11	28	570	3	yearend
zebrano	18	4	385	3	zebrano

Search took 6 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	309	5.486	20546.1
3	Display Results	309	309	0.093	3322.6
	(SQL Overall)	178691	309	5.969	29936.5