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

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

381 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
extern	13	4	847	(None)
externe	14	3	857	1	externe
externs	14	3	823	1	externs
astern	6	48	1581	2	astern
dexter	14	38	1089	2	dexter_
eastern	7	44	1253	2	eastern
eaten	5	53	2305	2	eate_n
eater	5	46	3984	2	eater_
eaters	6	55	3595	2	eaters
eatery	9	53	1635	2	eatery
enter	5	47	2638	2	enter_
entera	6	42	1683	2	entera
enteron	7	3	1334	2	enteron
enters	6	44	2564	2	enters
ester	5	47	2771	2	ester_
esters	6	46	2773	2	esters
eterne	6	3	1172	2	e_terne
exert	12	46	2414	2	ex_ert
expert	15	5	1535	2	expert
exsert	13	4	1436	2	exsert
extend	14	26	752	2	extend
extent	13	27	1491	2	extent
external	15	7	722	2	external
externes	15	3	983	2	externes
extort	13	5	1397	2	extort
extra	12	3	900	2	ext_ra
intern	6	40	1654	2	intern
lectern	9	3	703	2	lectern
oxter	12	34	1409	2	oxter_
oxters	13	48	1327	2	oxters
stern	5	53	1912	2	_stern
tern	4	61	3480	2	__tern
western	10	29	1110	2	western
yestern	10	33	864	2	yestern
after	8	57	1979	3	after_
afters	9	47	1707	3	afters
alter	5	48	2850	3	alter_
alters	6	49	2422	3	alters
apter	7	61	2020	3	apter_
artery	9	9	1145	3	artery
aster	5	54	3489	3	aster_
asters	6	56	3160	3	asters
attorn	6	3	1079	3	attorn
axmen	14	51	1227	3	axme_n
beaten	8	46	1706	3	beate_n
beater	8	47	2939	3	beater_
beaters	9	49	2504	3	beaters
belter	8	47	2096	3	belter_
belters	9	38	1941	3	belters
better	8	47	2370	3	better_
betters	9	44	2209	3	betters
biter	7	50	3003	3	biter_
biters	8	39	2524	3	biters
bittern	9	48	1068	3	bittern
casern	8	47	1331	3	casern
cater	7	48	4072	3	cater_
cateran	9	3	1377	3	cateran
caters	8	53	3650	3	caters
cavern	11	53	1245	3	cavern
center	8	44	2141	3	center_
centers	9	44	2060	3	centers
cistern	9	33	1070	3	cistern
citer	7	48	2733	3	citer_
citers	8	50	2298	3	citers
cithern	12	48	991	3	cithern
cittern	9	33	914	3	cittern
cuter	7	47	2823	3	cuter_
dater	6	53	3231	3	dater_
daters	7	48	2737	3	daters
decern	9	13	1095	3	decern
defter	10	42	1592	3	defter_
deter	6	50	2804	3	deter_
deters	7	47	2468	3	deters
deuteron	9	4	600	3	deuteron
dextran	15	8	616	3	dextran
dextrin	15	8	754	3	dextrin
dextro	14	3	612	3	dext_ro
doter	6	54	2862	3	doter_
doters	7	44	2391	3	doters
eager	6	55	2697	3	eager_
eagers	7	45	2368	3	eagers
earn	4	67	3755	3	e__arn
easter	6	50	2798	3	easter_
easters	7	51	2568	3	easters
edger	7	52	1595	3	edger_
edgers	8	44	1392	3	edgers
eery	7	61	2962	3	e__ery
eger	5	59	2357	3	e_ger_
egers	6	51	2037	3	e_gers
egger	7	44	1441	3	egger_
eggers	8	46	1258	3	eggers
eider	6	46	2474	3	eider_
eiders	7	43	2136	3	eiders
either	9	45	1742	3	either_
elater	6	47	2420	3	elater_
elaterin	8	4	990	3	elaterin
elaters	7	44	2019	3	elaters
elder	6	40	2002	3	elder_
elders	7	48	1730	3	elders
elver	8	52	1624	3	elver_
elvers	9	38	1498	3	elvers
ember	9	55	1680	3	ember_
embers	10	41	1618	3	embers
emeer	7	48	1536	3	emeer_
emeers	8	33	1418	3	emeers
emery	10	48	1433	3	e_mery
emetin	8	6	1346	3	emetin
emmer	9	43	1446	3	emmer_
emmers	10	40	1322	3	emmers
emoter	8	54	1519	3	emoter_
emoters	9	47	1287	3	emoters
empery	13	4	868	3	empery
ender	6	43	2586	3	ender_
enders	7	43	2405	3	enders
enserf	9	3	1076	3	enserf
enteral	7	35	1644	3	enteral
entered	8	27	1888	3	entered
enterer	7	20	1563	3	enterer
enteric	9	3	1421	3	enteric
entering	9	19	2005	3	entering
enterons	8	3	1415	3	enterons
entire	6	16	1770	3	entire
entree	6	18	1788	3	entree
entry	8	24	1426	3	ent_ry
ern	3	57	3836	3	___ern
esker	9	44	1298	3	esker_
eskers	10	53	1222	3	eskers
esteem	8	3	881	3	esteem
estrin	6	3	1592	3	estrin
eternal	7	29	1089	3	e_ternal
ether	8	45	1877	3	ether_
ethers	9	45	1841	3	ethers
even	7	52	2227	3	e_ve_n
ever	7	70	2769	3	e_ver_
evert	8	49	2951	3	e_vert
every	11	52	1545	3	e_very
ewer	7	75	2398	3	e_wer_
ewers	8	60	1882	3	e_wers
exacter	16	3	740	3	exacter_
exacters	17	3	677	3	exacters
exalter	14	3	756	3	exalter_
exalters	15	3	665	3	exalters
examen	15	3	828	3	examen
exceed	16	3	617	3	exceed
excel	14	3	774	3	exce_l
excels	15	3	666	3	excels
except	17	9	765	3	except
excerpt	18	4	594	3	excerpt
excess	15	4	605	3	excess
exciter	16	3	775	3	exciter_
exciters	17	3	632	3	exciters
exec	13	53	1394	3	ex_e_c
execs	14	53	972	3	ex_ecs
exed	12	54	2059	3	ex_e_d
exedra	14	3	450	3	exedra
exerts	13	37	1229	3	ex_erts
exes	11	65	3081	3	ex_e_s
exeunt	13	3	870	3	ex_eunt
exhedra	18	4	330	3	exhedra
exhort	16	4	1080	3	exhort
exiler	13	47	1218	3	exiler_
exilers	14	41	973	3	exilers
exited	14	47	1252	3	exite_d
exoderm	17	5	489	3	exoderm
exogen	14	3	651	3	exogen
exon	11	71	1680	3	ex__on
exoteric	17	4	680	3	exoteric
expect	17	5	890	3	expect
expel	14	4	823	3	expe_l
expels	15	4	717	3	expels
expend	16	24	750	3	expend
experts	16	5	906	3	experts
expire	15	3	802	3	expire
expiry	18	3	465	3	expiry
export	15	4	1218	3	export
exsect	15	5	850	3	exsect
exserts	14	6	701	3	exserts
extant	13	27	1475	3	extant
extends	15	22	711	3	extends
extents	14	26	1017	3	extents
exterior	15	4	737	3	exterior
extermine	18	4	828	3	extermine
externals	16	6	662	3	extern~~als~~
extol	12	4	789	3	ext_ol
extoll	13	3	486	3	extoll
extols	13	3	768	3	extols
extorts	14	4	775	3	extorts
extras	13	3	1022	3	extras
extrema	16	7	501	3	extrema
extreme	16	4	565	3	extreme
exurb	14	5	770	3	ex_urb
eyen	7	62	2366	3	e_ye_n
eyer	7	61	2728	3	e_yer_
eyers	8	65	2133	3	e_yers
feater	9	52	2405	3	feater_
fern	7	61	2932	3	__fern
fester	9	47	2351	3	fester_
festers	10	41	2139	3	festers
fetter	9	41	2038	3	fetter_
fetters	10	35	1790	3	fetters
gater	6	45	3365	3	gater_
gaters	7	47	2864	3	gaters
getter	7	41	1761	3	getter_
getters	8	42	1610	3	getters
gittern	8	33	750	3	gittern
govern	10	3	682	3	govern
hater	8	50	3475	3	hater_
haters	9	49	3040	3	haters
heater	9	48	2830	3	heater_
heaters	10	42	2522	3	heaters
hefter	12	43	1392	3	hefter_
hefters	13	43	1200	3	hefters
hern	7	61	3489	3	__hern
hetero	9	3	1263	3	hetero
hexer	15	51	1668	3	hex_er_
hexers	16	56	1275	3	hex_ers
inter	5	50	2849	3	inter_
interne	7	32	1815	3	interne
interns	7	31	1677	3	interns
inters	6	43	2805	3	inters
inturn	6	34	1156	3	inturn
jester	13	43	1915	3	jester_
jesters	14	41	1819	3	jesters
kelter	10	32	1438	3	kelter_
kelters	11	38	1375	3	kelters
kern	8	53	2621	3	__kern
kiter	9	55	2321	3	kiter_
kiters	10	52	1859	3	kiters
lantern	7	3	1001	3	lantern
lateen	6	40	1486	3	lateen
laten	5	43	2834	3	late_n
later	5	48	4392	3	later_
leathern	11	39	891	3	leathern
lecterns	10	3	594	3	lecterns
lefter	9	36	1343	3	lefter_
lenten	6	3	1288	3	lente_n
letter	6	37	2258	3	letter_
letters	7	38	1985	3	letters
liter	5	47	3634	3	liter_
liters	6	54	2988	3	liters
lucern	8	4	610	3	lucern
lutein	6	3	1126	3	lutein
luthern	10	3	765	3	luthern
mater	7	44	3886	3	mater_
maters	8	50	3239	3	maters
meeter	8	36	1650	3	meeter_
meeters	9	47	1454	3	meeters
melter	8	35	2011	3	melter_
melters	9	39	1831	3	melters
meter	7	51	3032	3	meter_
meters	8	56	2583	3	meters
miter	7	57	3479	3	miter_
miters	8	43	2878	3	miters
modern	9	3	952	3	modern
muter	7	45	2554	3	muter_
neaten	6	42	1454	3	neate_n
neater	6	44	2431	3	neater_
nester	6	41	2418	3	nester_
nesters	7	44	2279	3	nesters
netter	6	37	2202	3	netter_
netters	7	36	1858	3	netters
neuter	6	37	1379	3	neuter_
neuters	7	42	1227	3	neuters
niter	5	50	2897	3	niter_
niters	6	46	2421	3	niters
nitery	9	44	1217	3	nitery
noter	5	50	2564	3	noter_
noters	6	40	2100	3	noters
oaten	5	52	2240	3	oate_n
oater	5	54	3373	3	oater_
oaters	6	50	2979	3	oaters
often	8	46	1141	3	ofte_n
ofter	8	41	1687	3	ofter_
otter	5	44	2397	3	otter_
otters	6	40	2151	3	otters
outearn	7	3	1068	3	outearn
outer	5	56	3330	3	outer_
outers	6	42	3017	3	outers
oxen	11	62	1859	3	ox_e_n
pastern	9	44	1506	3	pastern
paten	7	48	2734	3	pate_n
pater	7	47	4072	3	pater_
paters	8	49	3583	3	paters
pattern	9	37	1205	3	pattern
pecten	10	27	1110	3	pecte_n
pelter	8	33	2162	3	pelter_
pelters	9	37	2031	3	pelters
perter	8	44	2228	3	perter_
pester	8	48	2759	3	pester_
pesters	9	38	2709	3	pesters
peter	7	44	2759	3	peter_
peters	8	66	2459	3	peters
petter	8	39	2477	3	petter_
petters	9	37	2236	3	petters
pewter	11	40	1367	3	pewter_
pewters	12	41	1335	3	pewters
postern	9	36	1561	3	postern
poteen	8	35	1426	3	poteen
pterin	8	10	1415	3	_pterin
quern	14	36	1040	3	_quern
rater	5	49	4328	3	rater_
raters	6	39	3658	3	raters
renter	6	45	2741	3	renter_
renters	7	42	2481	3	renters
rester	6	38	3243	3	rester_
resters	7	41	3040	3	resters
retorn	6	109	2343	3	retorn
return	6	232	2252	3	return
saltern	7	40	1065	3	saltern
sateen	6	38	1501	3	sateen
seater	6	45	3416	3	seater_
seaters	7	40	2894	3	seaters
secern	8	10	1022	3	secern
setter	6	40	2372	3	setter_
setters	7	38	2206	3	setters
sexier	13	3	1068	3	sexier_
sextain	14	25	710	3	sextain
sextan	13	38	964	3	sext_an
sextet	13	9	1687	3	sexte_t
sextets	14	9	714	3	sextets
sexton	13	36	1079	3	sext_on
sixteen	14	3	411	3	sixteen
stein	5	46	2054	3	_stein
stere	5	53	2854	3	_stere
sterna	6	37	1276	3	_sterna
sterns	6	46	1676	3	_sterns
tarn	4	68	4272	3	__tarn
tater	5	41	3861	3	tater_
taters	6	49	3220	3	taters
tavern	9	42	893	3	tavern
teen	4	59	3820	3	__teen
teeter	6	54	2031	3	teeter_
teeters	7	40	1830	3	teeters
ten	3	58	5611	3	__te_n
tenter	6	46	2393	3	tenter_
tenters	7	39	2110	3	tenters
term	6	62	3315	3	__term
terne	5	64	2615	3	__terne
terns	5	52	2687	3	__terns
tester	6	42	2715	3	tester_
testers	7	41	2454	3	testers
tetter	6	43	2245	3	tetter_
tetters	7	43	2047	3	tetters
texture	14	9	708	3	texture
titer	5	54	3061	3	titer_
titers	6	45	2641	3	titers
torn	4	60	4425	3	__torn
toter	5	59	3213	3	toter_
toters	6	50	2636	3	toters
turn	4	63	3039	3	__turn
untorn	6	30	1234	3	untorn
uptorn	8	26	809	3	uptorn
upturn	8	28	624	3	upturn
uteri	5	10	1298	3	_uteri
utter	5	42	1876	3	utter_
utters	6	38	1712	3	utters
venter	9	42	1872	3	venter_
venters	10	37	1773	3	venters
veteran	10	3	935	3	veteran
vetter	9	34	1764	3	vetter_
vetters	10	40	1632	3	vetters
vexer	15	55	1352	3	vex_er_
vexers	16	52	1040	3	vex_ers
voter	8	51	2105	3	voter_
voters	9	50	1744	3	voters
water	8	47	3331	3	water_
waters	9	50	3063	3	waters
watery	12	39	1449	3	watery
welter	9	34	1738	3	welter_
welters	10	35	1606	3	welters
wester	9	42	2289	3	wester_
westerns	11	32	896	3	westerns
westers	10	52	2196	3	westers
wetter	9	39	1944	3	wetter_
wetters	10	38	1775	3	wetters
wivern	12	40	928	3	wivern
wyvern	15	36	392	3	wyvern
yester	9	34	1798	3	yester_
zester	15	36	1779	3	zester_
zesters	16	35	1729	3	zesters
zithern	19	44	702	3	zithern

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.376	475242.0
2	DLD Change Limit	112716	381	4.716	23900.8
3	Display Results	381	381	0.126	3023.8
	(SQL Overall)	178691	381	5.218	34245.1