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

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

267 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
externs	14	3	823	(None)
extern	13	4	847	1	extern_
externe	14	3	857	1	externe
externes	15	3	983	1	externes
eaters	6	55	3595	2	eater_s
enterons	8	3	1415	2	enterons
enters	6	44	2564	2	enter_s
esters	6	46	2773	2	ester_s
eterne	6	3	1172	2	e_terne
exerts	13	37	1229	2	ex_erts
experts	16	5	906	2	experts
exserts	14	6	701	2	exserts
extend	14	26	752	2	exte_nd
extends	15	22	711	2	extends
extent	13	27	1491	2	exte_nt
extents	14	26	1017	2	extents
external	15	7	722	2	external
externals	16	6	662	2	externals
extorts	14	4	775	2	extorts
extras	13	3	1022	2	ext_ras
interns	7	31	1677	2	interns
lecterns	10	3	594	2	lecterns
oxters	13	48	1327	2	oxter_s
sterns	6	46	1676	2	_sterns
terns	5	52	2687	2	__terns
westerns	11	32	896	2	westerns
afters	9	47	1707	3	after_s
alters	6	49	2422	3	alter_s
astern	6	48	1581	3	astern_
asters	6	56	3160	3	aster_s
attorns	7	3	844	3	attorns
beaters	9	49	2504	3	beater_s
belters	9	38	1941	3	belter_s
betters	9	44	2209	3	better_s
biters	8	39	2524	3	biter_s
bitterns	10	42	895	3	bitterns
caserns	9	47	1122	3	caserns
caterans	10	3	1322	3	caterans
caters	8	53	3650	3	cater_s
caverns	12	45	1025	3	caverns
centers	9	44	2060	3	center_s
cisterns	10	36	958	3	cisterns
citers	8	50	2298	3	citer_s
citherns	13	33	887	3	citherns
citterns	10	31	812	3	citterns
daters	7	48	2737	3	dater_s
decerns	10	11	905	3	decerns
deters	7	47	2468	3	deter_s
deuterons	10	4	678	3	deuterons
dexter	14	38	1089	3	dexter__
dexterous	17	4	555	3	dexterous
dextrans	16	9	598	3	dextrans
dextrins	16	11	782	3	dextrins
doters	7	44	2391	3	doter_s
eagers	7	45	2368	3	eager_s
earns	5	59	2756	3	e__arns
eastern	7	44	1253	3	eastern_
easters	7	51	2568	3	easter_s
eaten	5	53	2305	3	eate_n_
eater	5	46	3984	3	eater__
eateries	8	3	2432	3	eateries
eatery	9	53	1635	3	eater_y
edgers	8	44	1392	3	edger_s
egers	6	51	2037	3	e_ger_s
eggers	8	46	1258	3	egger_s
eiders	7	43	2136	3	eider_s
elaterins	9	4	1003	3	elaterins
elaters	7	44	2019	3	elater_s
elders	7	48	1730	3	elder_s
elvers	9	38	1498	3	elver_s
embers	10	41	1618	3	ember_s
emeers	8	33	1418	3	emeer_s
emetins	9	8	1265	3	emetins
emmers	10	40	1322	3	emmer_s
emoters	9	47	1287	3	emoter_s
enders	7	43	2405	3	ender_s
enserfs	10	3	548	3	enserfs
enter	5	47	2638	3	enter__
entera	6	42	1683	3	enter_a
enteral	7	35	1645	3	enteral
entered	8	27	1888	3	entered
enterer	7	20	1563	3	enterer
enterers	8	22	1415	3	enterers
enteric	9	3	1421	3	enteric
enterics	10	3	1286	3	enterics
entering	9	19	2005	3	entering
enteron	7	3	1334	3	enteron
entires	7	15	1778	3	entires
entrees	7	18	1377	3	entrees
erns	4	54	2823	3	___erns
eskers	10	53	1222	3	esker_s
esteems	9	3	524	3	esteems
ester	5	47	2771	3	ester__
esterase	8	4	948	3	esterase
estrins	7	3	1585	3	estrins
estrus	6	19	1211	3	est_rus
eternal	7	29	1089	3	e_ternal
eternals	8	23	895	3	e_ternals
eternise	8	11	966	3	e_ternise
ethers	9	45	1841	3	ether_s
evens	8	48	1710	3	e_ve_ns
everts	9	45	1489	3	e_verts
ewers	8	60	1882	3	e_wer_s
exacters	17	3	677	3	exacter_s
exalters	15	3	665	3	exalter_s
examens	16	3	719	3	examens
exceeds	17	3	384	3	exceeds
excels	15	3	666	3	exce_ls
excepts	18	8	520	3	excepts
excerpt	18	4	594	3	excerpt
excerpts	19	4	374	3	excerpts
excess	15	4	605	3	exce_ss
exciters	17	3	632	3	exciter_s
execs	14	53	972	3	ex_e_cs
exert	12	46	2414	3	ex_er_t
exes	11	65	3081	3	ex_e__s
exeunt	13	3	870	3	ex_eunt
exhorts	17	4	631	3	exhorts
exilers	14	41	973	3	exiler_s
exoderms	18	6	449	3	exoderms
exogens	15	3	688	3	exogens
exons	12	58	1334	3	ex__ons
exoteric	17	4	680	3	exoteric
expects	18	6	688	3	expects
expels	15	4	717	3	expe_ls
expend	16	24	750	3	expe_nd
expends	17	21	708	3	expends
expense	16	12	787	3	expe_nse
expert	15	5	1535	3	exper_t
expires	16	3	868	3	expires
exports	16	4	798	3	exports
express	16	3	749	3	express
exsects	16	5	557	3	exsects
exsert	13	4	1436	3	exser_t
extant	13	27	1475	3	ext_ant
extensor	15	4	391	3	exte_nsor
exterior	15	4	739	3	exterior
exteriors	16	4	734	3	exteriors
extermine	18	4	828	3	extermine
extermines	19	4	778	3	extermines
externship	22	5	363	3	externs~~hip~~
extolls	14	4	460	3	extolls
extols	13	3	768	3	ext_ols
extort	13	5	1397	3	extor_t
extra	12	3	900	3	ext_r_a
extrema	16	7	501	3	extrema
extreme	16	4	565	3	extreme
extremes	17	5	605	3	extremes
exurbs	15	3	442	3	ex_urbs
eyers	8	65	2133	3	e_yer_s
ferns	8	52	2008	3	__ferns
festers	10	41	2139	3	fester_s
fetters	10	35	1790	3	fetter_s
gaters	7	47	2864	3	gater_s
getters	8	42	1610	3	getter_s
gitterns	9	32	657	3	gitterns
governs	11	3	610	3	governs
haters	9	49	3040	3	hater_s
heaters	10	42	2522	3	heater_s
hefters	13	43	1200	3	hefter_s
herns	8	48	2558	3	__herns
heteros	10	3	1268	3	heteros
hexers	16	56	1275	3	hex_er_s
icterus	9	3	608	3	icterus
intern	6	40	1654	3	intern_
interne	7	32	1815	3	interne
internes	8	27	2123	3	internes
inters	6	43	2805	3	inter_s
inturns	7	32	1013	3	inturns
jesters	14	41	1819	3	jester_s
kelters	11	38	1375	3	kelter_s
kerns	9	47	1956	3	__kerns
kiters	10	52	1859	3	kiter_s
lanterns	8	3	830	3	lanterns
lateens	7	42	1055	3	lateens
latens	6	46	2021	3	late_ns
lectern	9	3	703	3	lectern_
letters	7	38	1985	3	letter_s
liters	6	54	2988	3	liter_s
lucerns	9	3	575	3	lucerns
luteins	7	3	1010	3	luteins
lutherns	11	3	629	3	lutherns
maters	8	50	3239	3	mater_s
meeters	9	47	1454	3	meeter_s
melters	9	39	1831	3	melter_s
meters	8	56	2583	3	meter_s
miters	8	43	2878	3	miter_s
moderns	10	3	796	3	moderns
neatens	7	33	1040	3	neate_ns
nesters	7	44	2279	3	nester_s
netters	7	36	1858	3	netter_s
neuters	7	42	1227	3	neuter_s
niters	6	46	2421	3	niter_s
noters	6	40	2100	3	noter_s
oaters	6	50	2979	3	oater_s
otters	6	40	2151	3	otter_s
outearns	8	3	840	3	outearns
outers	6	42	3017	3	outer_s
oxter	12	34	1409	3	oxter__
pasterns	10	41	1262	3	pasterns
patens	8	48	2086	3	pate_ns
paters	8	49	3584	3	pater_s
patterns	10	43	994	3	patterns
pectens	11	18	920	3	pecte_ns
pelters	9	37	2031	3	pelter_s
pesters	9	38	2709	3	pester_s
peters	8	66	2459	3	peter_s
petters	9	37	2236	3	petter_s
pewters	12	41	1335	3	pewter_s
posterns	10	27	1372	3	posterns
poteens	9	29	1088	3	poteens
pterins	9	8	1299	3	_pterins
querns	15	30	794	3	_querns
raters	6	39	3658	3	rater_s
renters	7	42	2482	3	renter_s
resters	7	41	3040	3	rester_s
returns	7	97	1259	3	returns
salterns	8	38	890	3	salterns
sateens	7	37	1075	3	sateens
seaters	7	40	2894	3	seater_s
secerns	9	8	773	3	secerns
setters	7	38	2206	3	setter_s
sextains	15	24	681	3	sextains
sextans	14	34	927	3	sext_ans
sextets	14	9	714	3	sexte_ts
sextons	14	37	1041	3	sext_ons
sixteens	15	4	294	3	sixteens
steins	6	48	1834	3	_steins
steres	6	39	2953	3	_steres
stern	5	53	1912	3	_stern_
sterna	6	37	1276	3	_sterna
tarns	5	64	3395	3	__tarns
taters	6	49	3220	3	tater_s
taverns	10	31	780	3	taverns
teens	5	62	2748	3	__teens
teeters	7	40	1830	3	teeter_s
tens	4	56	4741	3	__te_ns
tenters	7	39	2111	3	tenter_s
terms	7	55	2347	3	__terms
tern	4	61	3480	3	__tern_
terne	5	64	2615	3	__terne
ternes	6	54	2290	3	__ternes
testers	7	41	2454	3	tester_s
tetters	7	43	2047	3	tetter_s
textures	15	9	752	3	textures
titers	6	45	2641	3	titer_s
toters	6	50	2636	3	toter_s
turns	5	56	2324	3	__turns
upturns	9	26	497	3	upturns
uterus	6	3	920	3	_uterus
utters	6	38	1712	3	utter_s
venters	10	37	1773	3	venter_s
veterans	11	4	885	3	veterans
vetters	10	40	1632	3	vetter_s
vexers	16	52	1040	3	vex_er_s
voters	9	50	1744	3	voter_s
waters	9	50	3064	3	water_s
welters	10	35	1606	3	welter_s
western	10	29	1110	3	western_
westers	10	52	2196	3	wester_s
wetters	10	38	1775	3	wetter_s
wiverns	13	36	696	3	wiverns
wyverns	16	36	301	3	wyverns
xerus	12	3	1333	3	_x_erus
yestern	10	33	864	3	yestern_
zesters	16	35	1729	3	zester_s
zitherns	20	37	613	3	zitherns

Search took 8 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	134027	0.406	440125.6
2	DLD Change Limit	134027	267	6.860	19537.5
3	Display Results	267	267	0.110	2427.3
	(SQL Overall)	178691	267	7.376	24226.0