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

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

426 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
eggars	8	39	897	(None)
beggars	11	37	822	1	beggars
eggar	7	45	888	1	eggar_
eggers	8	46	1258	1	eggers
seggars	9	37	778	1	seggars
agars	6	61	2064	2	_agars
aggers	8	58	1779	2	aggers
beggar	10	32	822	2	beggar_
beggary	14	31	615	2	beggary
cigars	9	9	1072	2	cigars
eagers	7	45	2368	2	eagers
ears	4	63	5659	2	e__ars
edgers	8	44	1392	2	edgers
egads	7	46	1092	2	e_gads
egers	6	51	2037	2	e_gers
egger	7	44	1441	2	egger_
eggs	6	65	1615	2	egg__s
embars	10	38	1288	2	embars
escars	8	39	1313	2	escars
eskars	10	35	759	2	eskars
gars	5	57	5074	2	__gars
gears	6	46	2869	2	_gears
gnars	6	67	1885	2	_gnars
guars	6	50	2105	2	_guars
keggers	13	35	704	2	keggers
muggars	11	31	664	2	muggars
regears	8	30	1246	2	regears
reggaes	9	4	888	2	reggaes
saggars	9	36	1068	2	saggars
seggar	8	35	781	2	seggar_
sugars	7	3	1242	2	sugars
afars	8	57	1651	3	_afars
agar	5	87	2641	3	_agar_
agas	5	59	3884	3	_aga_s
agers	6	50	2785	3	_agers
aggada	9	5	522	3	aggada
aggadas	10	5	500	3	aggadas
agger	7	64	2089	3	agger_
aggies	8	35	1551	3	aggies
aggro	7	3	801	3	agg_ro
aggros	8	3	655	3	aggros
aghas	9	70	1487	3	agha_s
aglare	7	3	1243	3	aglare
agmas	8	59	1987	3	agma_s
agoras	7	6	1334	3	agoras
alegars	8	3	893	3	alegars
algas	6	56	2493	3	alga_s
algors	7	3	1255	3	algors
altars	6	45	1815	3	altars
anears	6	37	1718	3	anears
angary	10	3	1132	3	angary
angas	6	58	2799	3	anga_s
angers	7	52	2254	3	angers
argals	7	55	1771	3	argals
ars	3	76	7093	3	___ars
attars	6	45	1531	3	attars
augers	7	38	1870	3	augers
augurs	7	39	996	3	augurs
avgas	9	69	1213	3	avga_s
bagass	9	3	893	3	bagass
baggers	11	39	1569	3	baggers
bars	6	65	6409	3	__bars
bazars	17	46	1311	3	bazars
bears	7	57	3904	3	_bears
beggared	13	3	475	3	beggared
beggaries	13	5	623	3	beggaries
beggarly	15	29	339	3	beggarly
beglads	11	12	726	3	beglads
belgas	9	3	1171	3	belga_s
bezoars	18	3	679	3	bezoars
blears	8	51	1645	3	blears
boars	7	52	2960	3	_boars
bogans	9	57	1481	3	bogans
bogart	9	6	1719	3	bogart
bogarts	10	4	774	3	bogarts
boyars	11	56	1198	3	boyars
briars	8	48	1482	3	briars
buggers	11	43	1566	3	buggers
cagers	9	56	2419	3	cagers
cars	6	73	6476	3	__cars
cedars	9	33	1283	3	cedars
cellars	9	37	1369	3	cellars
chars	10	59	3664	3	_chars
cigar	8	9	1180	3	cigar_
clears	8	41	1656	3	clears
cougars	10	3	844	3	cougars
cymars	13	59	915	3	cymars
czars	16	48	1291	3	_czars
daggas	9	3	797	3	dagga_s
daggers	10	37	1491	3	daggers
damars	9	38	1500	3	damars
dears	6	57	3688	3	_dears
debars	9	42	1804	3	debars
degas	7	51	1916	3	dega_s
denars	7	46	2143	3	denars
deodars	9	3	762	3	deodars
desugars	10	4	337	3	desugars
dewars	10	51	1707	3	dewars
diggers	10	44	1339	3	diggers
dinars	7	54	1756	3	dinars
dogears	9	3	751	3	dogears
doggers	10	44	1343	3	doggers
drears	7	46	1425	3	drears
eager	6	55	2697	3	eager_
eagles	7	38	1916	3	eagles
eagre	6	43	1532	3	eag_re
eagres	7	40	1457	3	eagres
ear	3	68	6788	3	e__ar_
earl	4	58	3814	3	e__arl
earls	5	61	2751	3	e__arls
earn	4	67	3755	3	e__arn
earns	5	59	2756	3	e__arns
eaters	6	55	3595	3	eaters
eats	4	70	5487	3	e__ats
echard	12	4	922	3	echard
echards	13	3	796	3	echards
eclairs	9	3	596	3	eclairs
eclats	8	3	1303	3	eclats
edger	7	52	1595	3	edger_
edges	7	57	1874	3	edg_es
egad	6	42	1541	3	e_ga_d
egal	5	51	1943	3	e_ga_l
eger	5	59	2357	3	e_ger_
egests	7	44	1125	3	egests
egg	5	69	1867	3	egg___
eggcup	12	4	183	3	eggcup
eggcups	13	4	120	3	eggcups
egged	8	51	1439	3	egg_ed
eggheads	14	4	292	3	eggheads
egging	9	32	1098	3	egging
eggless	9	3	566	3	eggless
eggnog	9	4	197	3	eggnog
eggnogs	10	4	192	3	eggnogs
eggy	9	66	1185	3	egg__y
egis	5	65	2065	3	e_g_is
egises	7	3	1249	3	egises
egos	5	58	2165	3	e_g_os
egress	7	33	1043	3	egress
egrets	7	27	1224	3	egrets
eiders	7	43	2136	3	eiders
eights	10	36	1898	3	eights
elans	5	55	2775	3	e_lans
elders	7	48	1730	3	elders
elvers	9	38	1498	3	elvers
embar	9	40	1160	3	embar_
embark	14	45	852	3	embark
embarks	15	33	735	3	embarks
embays	13	140	833	3	embays
embers	10	41	1618	3	embers
emeers	8	33	1418	3	emeers
emirs	7	61	1616	3	e_mirs
emmers	10	40	1322	3	emmers
endears	8	37	1005	3	endears
enders	7	43	2405	3	enders
engage	8	28	1210	3	engage
engagers	10	24	655	3	engagers
engages	9	29	1249	3	engages
engird	8	12	697	3	engird
engirds	9	9	505	3	engirds
engirt	7	11	1261	3	engirt
engram	9	3	1065	3	engram
engrams	10	3	807	3	engrams
engs	5	61	2139	3	eng__s
enters	6	44	2564	3	enters
ephahs	14	3	550	3	ephahs
ephas	10	3	1154	3	epha_s
ephors	11	3	1140	3	ephors
equals	15	3	870	3	equals
eras	4	54	4150	3	e_ra_s
ergate	7	3	1514	3	ergate
ergates	8	3	1449	3	ergates
ergots	7	45	1237	3	ergots
ergs	5	55	2381	3	erg__s
errors	6	33	1131	3	errors
errs	4	56	2253	3	e__rrs
ers	3	60	4628	3	e___rs
escar	7	40	1199	3	escar_
escarp	10	44	900	3	escarp
escarps	11	39	737	3	escarps
eschars	12	3	718	3	eschars
eskar	9	45	745	3	eskar_
eskers	10	53	1222	3	eskers
essays	9	6	565	3	essays
esters	6	46	2773	3	esters
etas	4	64	3227	3	e_ta_s
ethers	9	45	1841	3	ethers
etnas	5	47	1393	3	etna_s
ewers	8	60	1882	3	e_wers
exams	14	19	908	3	e_xams
expats	15	3	768	3	expats
extras	13	3	1022	3	extras
eyas	7	64	2743	3	e_ya_s
eyass	8	44	1078	3	e_yass
eyebars	12	4	533	3	eyebars
eyers	8	65	2133	3	e_yers
eyras	8	47	1592	3	eyra_s
fears	8	48	2939	3	_fears
feuars	9	3	865	3	feuars
fiars	8	67	2083	3	_fiars
foggers	12	41	1201	3	foggers
friars	9	38	1209	3	friars
gabs	7	67	4042	3	__gabs
gads	6	78	4338	3	__gads
gaes	5	63	4803	3	__gaes
gagers	8	40	2133	3	gagers
gages	7	45	2997	3	_gages
gaggers	10	34	1366	3	gaggers
gags	6	64	4106	3	__gags
gals	5	79	4650	3	__gals
gams	7	66	4888	3	__gams
gaps	7	60	4297	3	__gaps
gar	4	72	5990	3	__gar_
garb	7	53	3267	3	__garb
garbs	8	63	2141	3	__garbs
gas	4	88	7025	3	__ga_s
gats	5	67	5344	3	__gats
gaurs	6	63	1799	3	_gaurs
gays	8	73	3802	3	__gays
gazars	16	48	1155	3	gazars
gear	5	59	3497	3	_gear_
geegaws	12	4	234	3	geegaws
gerahs	10	3	941	3	gerahs
getas	6	54	2148	3	geta_s
gewgaws	15	4	164	3	gewgaws
ghats	9	58	1861	3	_ghats
gigas	7	54	1558	3	giga_s
glads	7	56	2061	3	_glads
glairs	7	52	1133	3	_glairs
glams	8	58	2293	3	_glams
glans	6	51	2583	3	_glans
glare	6	52	2296	3	_glare
glares	7	55	1887	3	_glares
glary	9	60	1854	3	_glary
glass	6	55	1813	3	_glass
gnar	5	60	2138	3	_gnar_
gnarl	6	51	1557	3	_gnarl
gnarls	7	42	1077	3	_gnarls
gnarr	6	48	1069	3	_gnarr
gnarrs	7	40	766	3	_gnarrs
gnats	6	52	1771	3	_gnats
gnaws	9	63	1114	3	_gnaws
goads	7	70	2285	3	_goads
goals	6	55	2129	3	_goals
goas	5	52	3994	3	_goa_s
goats	6	55	2730	3	_goats
goers	6	55	2025	3	_goers
grabs	8	57	1969	3	_grabs
grads	7	56	2575	3	_grads
grams	8	53	2731	3	_grams
grans	6	48	3254	3	_grans
grass	6	61	2520	3	_grass
grays	9	56	2133	3	_grays
guans	6	44	1944	3	_guans
guar	5	69	2329	3	_guar_
guard	7	44	1554	3	_guard
guards	8	46	1157	3	_guards
haars	8	56	2047	3	_haars
haggard	13	37	718	3	haggard
haggards	14	36	676	3	haggards
hangars	11	43	1349	3	hangars
hears	8	67	3737	3	_hears
hedgers	12	43	1026	3	hedgers
hegari	10	3	952	3	hegari
hegaris	11	3	1043	3	hegaris
hegiras	11	3	610	3	hegiras
hoars	8	59	2555	3	_hoars
hogans	10	59	1431	3	hogans
hoggers	12	45	1248	3	hoggers
huggers	12	42	1159	3	huggers
iggs	6	66	1267	3	igg__s
invars	9	3	1000	3	invars
izars	14	51	1293	3	_izars
jagers	14	44	1572	3	jagers
jaggary	19	30	486	3	jaggary
jaggers	16	40	1289	3	jaggers
jagras	14	3	846	3	jagras
jaguars	15	3	523	3	jaguars
jars	11	73	3835	3	__jars
jiggers	16	40	1018	3	jiggers
joggers	16	41	1069	3	joggers
jowars	16	36	965	3	jowars
kabars	12	45	1395	3	kabars
kbars	11	46	1260	3	_kbars
kebars	12	41	1249	3	kebars
kegger	12	38	808	3	kegger_
keglers	12	27	777	3	keglers
knars	9	44	1611	3	_knars
kyars	12	48	1396	3	_kyars
lagans	7	57	1778	3	lagans
lagers	7	48	2614	3	lagers
laggard	10	34	762	3	laggard
laggards	11	30	705	3	laggards
laggers	9	42	1624	3	laggers
lahars	9	40	1316	3	lahars
lars	4	69	5657	3	__lars
lazars	15	38	1239	3	lazars
lears	5	59	3873	3	_lears
ledgers	9	49	1218	3	ledgers
legals	7	34	1273	3	legals
legers	7	45	1831	3	legers
leggins	9	25	947	3	leggins
lekvars	14	3	269	3	lekvars
liars	5	47	2316	3	_liars
lidars	7	3	1078	3	lidars
ligans	7	68	1773	3	ligans
ligers	7	50	2204	3	ligers
logans	7	63	1906	3	logans
loggats	9	28	645	3	loggats
loggers	9	46	1613	3	loggers
lugers	7	46	1702	3	lugers
luggers	9	37	1348	3	luggers
lunars	6	50	1281	3	lunars
maars	7	46	2163	3	_maars
makars	12	46	1263	3	makars
malars	8	50	2068	3	malars
mars	6	62	6187	3	__mars
medlars	10	25	944	3	medlars
megabars	13	4	440	3	megabars
megara	9	3	1009	3	megara
megass	9	21	944	3	megass
mergers	10	38	1342	3	mergers
molars	8	55	1732	3	molars
muggar	10	31	644	3	muggar_
muggers	11	36	1193	3	muggers
muggurs	11	31	510	3	muggurs
mylars	11	43	1044	3	mylars
naggers	9	38	1265	3	naggers
navars	9	28	1057	3	navars
nears	5	55	2942	3	_nears
nectars	9	3	846	3	nectars
niggard	10	4	494	3	niggard
niggards	11	4	412	3	niggards
niggers	9	31	1132	3	niggers
oars	4	68	4603	3	__oars
ogams	8	41	1268	3	_ogams
oghams	12	4	585	3	oghams
oglers	7	43	1318	3	oglers
organs	7	9	1291	3	organs
ottars	6	41	1222	3	ottars
pagans	9	57	1792	3	pagans
pagers	9	44	2325	3	pagers
pars	6	75	6079	3	__pars
pears	7	51	3861	3	_pears
pedlars	10	32	1021	3	pedlars
polars	8	44	1935	3	polars
preggers	12	23	683	3	preggers
radars	7	13	1467	3	radars
ragas	6	53	2606	3	raga_s
realgars	9	3	453	3	realgars
rears	5	47	3965	3	_rears
rebars	8	40	1983	3	rebars
redears	8	28	1445	3	redears
regard	8	52	1577	3	regard
regards	9	41	1256	3	regards
regear	7	35	1274	3	regear_
reggae	8	5	895	3	regga_e
regulars	9	3	625	3	regulars
rehears	10	33	1277	3	rehears
retears	7	28	1492	3	retears
rewears	10	29	1104	3	rewears
riggers	9	36	1384	3	riggers
rigors	7	28	1371	3	rigors
roars	5	56	2224	3	_roars
rogers	7	45	1791	3	rogers
ruggers	9	46	1231	3	ruggers
sagas	6	60	2588	3	saga_s
saggar	8	40	1085	3	saggar_
saggard	10	35	895	3	saggard
saggards	11	39	749	3	saggards
saggers	9	40	1708	3	saggers
sangars	8	31	1625	3	sangars
scars	7	54	3353	3	_scars
sears	5	47	4491	3	_sears
secpars	11	3	841	3	secpars
sergers	8	38	1563	3	sergers
sewars	9	40	1863	3	sewars
shears	9	38	2090	3	shears
simars	8	49	1693	3	simars
sitars	6	54	1759	3	sitars
sizars	15	48	1262	3	sizars
smears	8	47	1443	3	smears
soars	5	47	3251	3	_soars
sofars	9	47	1278	3	sofars
sonars	6	48	1897	3	sonars
sowars	9	43	1801	3	sowars
spars	7	54	3154	3	_spars
spears	8	40	1947	3	spears
stars	5	58	3657	3	_stars
sugar	6	3	1291	3	sugar_
sugary	10	3	901	3	sugary
swears	9	41	1407	3	swears
taggers	9	35	1419	3	taggers
talars	6	60	2168	3	talars
tars	4	67	6395	3	__tars
tatars	6	46	1979	3	tatars
tears	5	54	3646	3	_tears
teggs	7	47	1074	3	tegg__s
teguas	7	6	801	3	tegua_s
tigers	7	56	1651	3	tigers
togas	6	78	2300	3	toga_s
tolars	6	48	1794	3	tolars
tsars	5	67	1711	3	_tsars
tuggers	9	37	1144	3	tuggers
tzars	14	49	1427	3	_tzars
unbars	8	21	1303	3	unbars
urgers	7	33	1362	3	urgers
vagary	13	3	733	3	vagary
vars	7	57	4207	3	__vars
vegans	10	39	1085	3	vegans
veggies	12	3	755	3	veggies
velars	9	39	1372	3	velars
vergers	11	44	1263	3	vergers
vicars	11	7	1226	3	vicars
vigas	9	48	1788	3	viga_s
vigors	10	29	1148	3	vigors
vulgars	11	30	653	3	vulgars
wagers	10	51	2220	3	wagers
waggers	12	46	1308	3	waggers
wars	7	86	5980	3	__wars
wears	8	60	3030	3	_wears
wigans	10	45	1170	3	wigans
yagers	10	51	1453	3	yagers
years	8	45	2767	3	_years
yeggs	10	60	816	3	yegg__s
yogas	9	66	1560	3	yoga_s
yugas	9	50	1206	3	yuga_s

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.373	479064.3
2	DLD Change Limit	112716	426	4.766	23650.0
3	Display Results	426	426	0.140	3042.9
	(SQL Overall)	178691	426	5.279	33849.4