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

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

338 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
echard	12	4	922	(None)
chard	11	61	2474	1	_chard
echards	13	3	796	1	echards
becharm	16	3	684	2	becharm
card	7	102	4587	2	_c_ard
chad	10	55	2550	2	_cha_d
char	9	51	3215	2	_char_
chards	12	51	1973	2	_chards
chare	10	52	3198	2	_chare
chared	12	54	2369	2	_chared
chark	14	42	2271	2	_chark
charm	12	61	2466	2	_charm
charr	10	48	2178	2	_charr
chars	10	59	3664	2	_chars
chart	10	50	3828	2	_chart
chary	13	50	2313	2	_chary
chord	11	59	1726	2	_chord
eched	11	69	1922	2	ech_ed
echoed	12	52	1116	2	echoed
eschar	11	3	653	2	eschar_
eschars	12	3	718	2	eschars
hard	8	54	4350	2	__hard
orchard	13	4	693	2	orchard
pochard	15	3	736	2	pochard
rechart	12	3	1434	2	rechart
shard	9	61	2596	2	_shard
aboard	9	3	1261	3	aboard
acari	7	50	2028	3	ac_ari
acarid	9	50	1707	3	ac_arid
accord	11	7	884	3	accord
ached	11	92	2783	3	ach_ed
afeard	10	5	826	3	afeard
award	9	71	1804	3	_award
bard	7	56	4886	3	__bard
bayard	12	44	1166	3	bayard
beard	8	60	2496	3	_beard
bechalk	18	4	581	3	bechalk
becharmed	19	4	466	3	becharmed
becharms	17	4	534	3	becharms
becoward	16	4	476	3	becoward
bedward	14	9	747	3	bedward
beeyard	13	3	552	3	beeyard
board	8	55	2300	3	_board
boyard	12	54	1128	3	boyard
briard	9	43	1129	3	briard
cad	6	74	5637	3	_c_a_d
caid	7	78	3754	3	_c_aid
caird	8	57	1723	3	_caird
canard	9	3	1476	3	canard
car	5	91	6556	3	_c_ar_
carb	8	51	4316	3	_c_arb
cards	8	51	3793	3	_c_ards
care	6	69	6837	3	_c_are
cared	8	60	5009	3	_c_ared
cark	10	55	3927	3	_c_ark
carl	6	51	4478	3	_c_arl
carn	6	62	4543	3	_c_arn
carp	8	51	3981	3	_c_arp
carr	6	54	3470	3	_c_arr
cars	6	73	6476	3	_c_ars
cart	6	65	7034	3	_c_art
cedar	8	40	1432	3	cedar_
cedarn	9	40	844	3	cedarn
cedars	9	33	1283	3	cedars
cedary	12	41	960	3	cedary
chadri	12	3	814	3	_chadri
chads	11	61	2223	3	_chads
chafe	13	51	1735	3	_chafe
chafed	15	48	1391	3	_chafed
chaff	16	50	1628	3	_chaff
chai	9	59	2990	3	_cha_i
chain	10	57	2367	3	_chain
chair	10	55	1963	3	_chair
chaired	13	42	1124	3	_chaired
chairs	11	49	1618	3	_chairs
chais	10	75	3031	3	_chais
chakra	15	43	753	3	_chakra
chalk	14	48	1460	3	_chalk
cham	11	55	3231	3	_cha_m
champ	14	50	1796	3	_champ
chams	12	60	2850	3	_chams
chang	11	54	1856	3	_chang
chant	10	59	3269	3	_chant
chao	9	57	2731	3	_cha_o
chaos	10	56	2286	3	_chaos
chap	11	49	2849	3	_cha_p
chape	12	52	2114	3	_chape
chaps	12	53	2606	3	_chaps
chapt	12	58	2764	3	_chapt
charade	13	12	991	3	_charade
charas	11	42	2361	3	_charas
chares	11	56	3180	3	_chares
charge	12	51	1421	3	_charge
charged	14	46	1402	3	_charged
charka	15	40	1170	3	_charka
charked	17	48	1401	3	_charked
charks	15	52	1970	3	_charks
charmed	15	47	1425	3	_charmed
charms	13	52	1884	3	_charms
charred	13	46	1449	3	_charred
charro	11	42	1296	3	_charro
charrs	11	52	1919	3	_charrs
charry	14	50	1211	3	_charry
charted	13	51	1685	3	_charted
charts	11	58	2309	3	_charts
chase	10	51	2712	3	_chase
chased	12	50	1929	3	_chased
chasm	12	55	1879	3	_chasm
chat	9	55	4613	3	_cha_t
chats	10	57	3009	3	_chats
chaw	12	62	2463	3	_cha_w
chawed	15	52	1460	3	_chawed
chaws	13	50	2246	3	_chaws
chay	12	49	2487	3	_cha_y
chays	13	53	1974	3	_chays
chert	10	52	3210	3	_chert
chid	10	66	2641	3	_ch_id
child	11	45	1622	3	_child
chirk	14	45	1618	3	_chirk
chirm	12	53	1706	3	_chirm
chiro	10	53	2034	3	_chiro
chirp	12	47	1716	3	_chirp
chirr	10	50	1590	3	_chirr
chiru	10	53	1715	3	_chiru
chords	12	52	1463	3	_chords
chore	10	51	2676	3	_chore
chored	12	53	2188	3	_chored
churl	10	59	1388	3	_churl
churn	10	51	1310	3	_churn
churr	10	45	1285	3	_churr
clad	7	62	2582	3	_cla_d
claro	7	50	1869	3	_claro
clary	10	57	1961	3	_clary
clochard	16	4	429	3	clochard
cord	7	67	4092	3	_c_ord
coward	12	4	1167	3	coward
curd	7	76	3498	3	_c_urd
czar	15	60	1313	3	_czar_
czars	16	48	1291	3	_czars
debeard	11	3	735	3	debeard
decare	9	39	1915	3	dec_are
deciare	10	7	1066	3	deciare
deckhand	19	4	310	3	deckhand
declare	10	4	1123	3	declare
declared	12	4	875	3	declared
diehard	12	3	705	3	diehard
dotard	8	3	905	3	dotard
ear	3	68	6788	3	e__ar_
eared	6	51	3950	3	e__ared
earl	4	58	3814	3	e__arl
earn	4	67	3755	3	e__arn
ears	4	63	5659	3	e__ars
ecarte	8	43	1350	3	ec_arte
eche	9	75	2028	3	ech__e
eches	10	63	2216	3	ech_es
eching	12	63	1556	3	eching
echini	11	47	1043	3	echini
echo	9	66	1595	3	ech__o
echoer	11	40	1110	3	echoer
echoers	12	45	969	3	echoers
echoes	11	47	1552	3	echoes
echoey	14	39	785	3	echoey
echoic	13	3	904	3	echoic
echos	10	52	1646	3	ech_os
echt	9	57	2290	3	ech__t
eclair	8	3	681	3	eclair
eclairs	9	3	596	3	eclairs
eclat	7	5	2360	3	ecla_t
eclats	8	3	1303	3	eclats
ecru	6	58	1953	3	ec__ru
egad	6	42	1541	3	e_ga_d
eggar	7	45	888	3	eggar_
eggars	8	39	897	3	eggars
eland	6	58	2039	3	e_land
embar	9	40	1160	3	embar_
embark	14	45	852	3	embark
embars	10	38	1288	3	embars
enchain	12	4	887	3	enchain
enchant	12	3	1313	3	enchant
enchase	12	3	947	3	enchase
enchased	14	3	739	3	enchased
engird	8	12	697	3	engird
enhalo	9	8	757	3	enhalo
epha	9	3	1005	3	epha__
ephah	13	3	706	3	epha_h
ephahs	14	3	550	3	ephahs
ephas	10	3	1154	3	epha_s
ephod	11	3	912	3	eph_od
ephor	10	3	1001	3	ephor_
ephori	11	3	960	3	ephori
ephors	11	3	1140	3	ephors
errand	7	5	879	3	errand
escar	7	40	1199	3	escar_
escarp	10	44	900	3	escarp
escars	8	39	1313	3	escars
eskar	9	45	745	3	eskar_
eskars	10	35	759	3	eskars
etchant	12	4	982	3	etchant
etched	12	36	1370	3	etch_ed
etcher	11	39	1294	3	etcher_
etchers	12	34	1129	3	etchers
ethane	9	46	1324	3	ethane
ether	8	45	1877	3	ether_
ethers	9	45	1841	3	ethers
eucharis	13	4	744	3	eucharis
euchre	11	13	766	3	euch_re
euchred	13	10	616	3	euchred
exhale	16	3	687	3	exhale
exhaled	18	3	528	3	exhaled
exhort	16	4	1080	3	exhort
expand	16	23	657	3	expand
fard	8	56	3906	3	__fard
guard	7	44	1554	3	_guard
had	7	76	5877	3	__ha_d
haed	8	63	3858	3	__haed
hand	8	68	3371	3	__hand
hards	9	64	3565	3	__hards
hardy	12	56	2206	3	__hardy
hare	7	62	5573	3	__hare
hared	9	57	4218	3	__hared
hark	11	52	3739	3	__hark
harl	7	57	4000	3	__harl
harm	9	56	3780	3	__harm
harp	9	61	3429	3	__harp
hart	7	68	6577	3	__hart
hazard	19	3	840	3	hazard
heard	9	52	2275	3	_heard
hectare	12	3	847	3	hectare
herd	8	49	3306	3	__herd
hoard	9	49	1831	3	_hoard
holard	10	4	1057	3	holard
ichor	10	3	948	3	ichor_
ichors	11	3	1042	3	ichors
inward	10	3	1033	3	inward
izzard	15	13	524	3	izzard
jehad	16	3	768	3	jeha_d
jeopard	17	4	411	3	jeopard
jihad	16	3	591	3	jiha_d
keycard	17	4	366	3	keycard
lahar	8	31	1426	3	lahar_
lahars	9	40	1316	3	lahars
lard	5	67	4200	3	__lard
leched	12	37	1600	3	lech_ed
lecher	11	34	1585	3	lecher_
lechered	14	3	752	3	lechered
lechers	12	33	1396	3	lechers
lechery	15	25	764	3	lechery
leeward	11	3	578	3	leeward
leopard	10	4	529	3	leopard
leotard	8	4	619	3	leotard
liard	6	54	1859	3	_liard
lizard	16	36	923	3	lizard
lyard	9	51	1321	3	_lyard
mazard	18	3	876	3	mazard
nard	5	66	3445	3	__nard
nectar	8	3	885	3	nectar_
nectars	9	3	846	3	nectars
nectary	12	4	622	3	nectary
ocher	10	45	1610	3	ocher_
ochered	13	26	1028	3	ochered
ochers	11	39	1530	3	ochers
ochery	14	31	944	3	ochery
ochre	10	34	1159	3	och_re
ochred	12	32	800	3	ochred
ochry	13	34	693	3	och_ry
octad	8	15	1065	3	octa_d
onward	10	3	905	3	onward
orchards	14	4	591	3	orchards
overhard	15	23	879	3	overhard
pard	7	64	4132	3	__pard
peccary	16	3	628	3	peccary
pechan	13	5	1154	3	pecha_n
pechans	14	8	1050	3	pechans
peched	14	49	1534	3	pech_ed
petard	9	50	1380	3	petard
pilchard	16	4	455	3	pilchard
pochards	16	4	685	3	pochards
reboard	10	3	1076	3	reboard
recharge	14	7	661	3	recharge
recharged	16	5	633	3	recharged
recharted	15	5	756	3	recharted
recharts	13	3	766	3	recharts
reclad	9	3	1187	3	recla_d
record	9	61	1743	3	rec_ord
regard	8	52	1577	3	regard
reheard	11	30	902	3	reheard
retard	7	50	1893	3	retard
reward	10	60	1764	3	reward
reynard	11	3	512	3	reynard
ritard	7	48	1208	3	ritard
sard	5	53	4424	3	__sard
scad	7	57	2577	3	sc_a_d
scald	8	48	1812	3	sc_ald
scar	6	64	3420	3	sc_ar_
scare	7	53	3446	3	sc_are
scared	9	52	2729	3	sc_ared
scarf	10	54	2714	3	sc_arf
scarp	9	57	2410	3	sc_arp
scars	7	54	3353	3	sc_ars
scart	7	61	3977	3	sc_art
scary	10	52	2259	3	sc_ary
schav	13	3	831	3	scha_v
schavs	14	3	649	3	schavs
schorl	11	7	981	3	schorl
schrod	12	4	788	3	schrod
seaward	11	4	818	3	seaward
secpar	10	3	793	3	secpar_
secpars	11	3	841	3	secpars
sectary	12	3	827	3	sectary
semihard	14	4	468	3	semihard
shad	8	62	3091	3	_sha_d
shaird	10	28	870	3	_shaird
shards	10	43	1917	3	_shards
share	8	64	3708	3	_share
shared	10	58	2906	3	_shared
shark	12	62	2502	3	_shark
sharn	8	48	2370	3	_sharn
sharp	10	49	2253	3	_sharp
sherd	9	63	2115	3	_sherd
sward	9	42	2146	3	_sward
tabard	9	3	1333	3	tabard
teched	12	40	1443	3	tech_ed
tharm	10	59	1664	3	_tharm
third	9	59	1249	3	_third
toward	10	3	1106	3	toward
unchary	15	3	726	3	unchary
unhand	10	4	1038	3	unhand
unheard	11	3	694	3	unheard
uphoard	13	4	457	3	uphoard
upward	12	14	716	3	upward
vaward	13	49	872	3	vaward
visard	10	39	1012	3	visard
vizard	19	45	885	3	vizard
ward	8	65	4225	3	__ward
wharf	14	3	1582	3	_wharf
wizard	19	37	771	3	wizard
yard	8	56	3325	3	__yard
yclad	11	24	638	3	ycla_d

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.373	479064.3
2	DLD Change Limit	112716	338	5.940	18975.8
3	Display Results	338	338	0.106	3188.7
	(SQL Overall)	178691	338	6.419	27837.8