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

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

394 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
expat	14	3	1381	(None)
expats	15	3	768	1	expats
eat	3	69	8905	2	e__at
eclat	7	5	2360	2	eclat
epact	9	49	2153	2	e_pact
exact	14	35	1693	2	exact
exalt	12	30	1853	2	exalt
exam	13	25	1462	2	ex_am
exert	12	46	2414	2	exert
exist	12	46	1894	2	exist
exit	11	44	2867	2	ex_it
expand	16	23	657	2	expand
expect	17	5	890	2	expect
expel	14	4	823	2	expel
expert	15	5	1535	2	expert
expiate	16	9	1059	2	expiate
explant	16	3	1013	2	explant
expo	13	4	918	2	exp_o
export	15	4	1218	2	export
expos	14	4	920	2	expos
extant	13	27	1475	2	extant
exult	12	28	1412	2	exult
pat	5	80	8946	2	__pat
sexpot	15	3	954	2	sexpot
spat	6	65	4852	2	_spat
adapt	8	12	1855	3	adapt
apart	7	43	3067	3	_apart
appal	9	53	1522	3	appal
apt	5	73	5254	3	_ap_t
arhat	8	3	2709	3	arhat
at	2	123	9340	3	___at
axal	11	65	2049	3	ax_al
axial	12	45	1519	3	axial
axman	14	48	1318	3	axman
bat	5	109	8895	3	__bat
beat	6	61	6830	3	_beat
bedpan	11	3	758	3	bedpan
begat	8	66	2972	3	begat
blat	6	65	5095	3	_blat
bleat	7	57	3700	3	bleat
bloat	7	52	2992	3	bloat
boat	6	63	6031	3	_boat
brat	6	60	5554	3	_brat
bypast	13	11	737	3	bypast
bypath	16	4	535	3	bypath
caput	9	8	2397	3	caput
carat	7	50	4879	3	carat
cat	5	82	8234	3	__cat
chapt	12	58	2764	3	chapt
chat	9	55	4613	3	_chat
cheat	10	57	3245	3	cheat
clapt	9	80	2717	3	clapt
cleat	7	63	3506	3	cleat
coapt	9	61	3152	3	coapt
coat	6	75	5834	3	_coat
copal	9	56	2178	3	copal
copay	12	65	1631	3	copay
cowpat	13	3	1203	3	cowpat
defat	9	54	2669	3	defat
defeat	10	38	1716	3	defeat
depart	9	47	2056	3	depart
depot	8	57	2792	3	depot
derat	6	50	4408	3	derat
despot	9	34	1329	3	despot
dipt	7	73	3932	3	dip_t
doat	5	69	4767	3	_doat
dopa	7	72	2090	3	dopa_
dopant	9	3	1613	3	dopant
dopas	8	50	1906	3	dopas
drat	5	62	4783	3	_drat
ducat	8	62	2590	3	ducat
ear	3	68	6788	3	e__ar
east	4	66	5910	3	e_ast
eath	7	57	3566	3	e__ath
eats	4	70	5487	3	e__ats
eau	3	74	5094	3	e__au
ebbet	9	35	1729	3	ebbet
echt	9	57	2290	3	e_cht
eclats	8	3	1303	3	eclats
edict	8	47	2228	3	edict
edit	5	49	3486	3	e_dit
educt	8	50	1710	3	educt
eft	6	60	3882	3	e__ft
egad	6	42	1541	3	e_gad
egal	5	51	1943	3	e_gal
egest	6	52	2234	3	egest
eggar	7	45	888	3	eggar
egret	6	33	2731	3	egret
eight	9	49	2805	3	eight
eject	14	50	1604	3	eject
elan	4	67	3424	3	e_lan
elate	5	53	3588	3	e_late
elect	7	43	2703	3	elect
elint	5	54	3647	3	elint
eluant	6	3	1509	3	eluant
eluate	6	23	1543	3	eluate
embar	9	40	1159	3	embar
embay	12	34	1059	3	embay
emit	6	54	3841	3	e_mit
emmet	9	42	2138	3	emmet
empale	10	26	1126	3	empale
empathy	17	4	348	3	empathy
empty	12	4	776	3	empty
enact	7	35	2536	3	enact
enate	5	44	2814	3	e_nate
enrapt	8	3	1301	3	enrapt
epacts	10	50	1039	3	e_pacts
epee	6	46	2850	3	e_pee
epha	9	3	1005	3	e_pha
ephah	13	3	706	3	ephah
ephas	10	3	1154	3	ephas
epic	8	69	2130	3	e_pic
epos	6	67	2373	3	e_pos
equal	14	4	982	3	equal
equate	15	20	1246	3	equate
era	3	57	4150	3	e_ra_
eras	4	54	4150	3	e_ras
erect	7	41	2933	3	erect
ergate	7	3	1514	3	ergate
ergot	6	54	2289	3	ergot
errant	6	6	1873	3	errant
errata	6	3	901	3	errata
ersatz	15	3	665	3	ersatz
erst	4	74	3643	3	e_rst
eruct	7	40	2235	3	eruct
erupt	7	42	2006	3	erupt
escar	7	40	1199	3	escar
escot	7	53	2008	3	escot
eskar	9	45	745	3	eskar
esparto	9	4	423	3	esparto
espial	8	3	954	3	espial
esprit	8	3	1284	3	esprit
espy	9	6	937	3	esp_y
essay	8	6	762	3	essay
estate	6	47	1976	3	estate
et	2	69	6419	3	e___t
eta	3	58	3419	3	e_ta_
etape	7	44	1370	3	etape
etas	4	64	3227	3	e_tas
etna	4	64	1526	3	etna_
etnas	5	47	1393	3	etnas
event	8	59	2444	3	event
evert	8	49	2951	3	evert
evict	10	44	1714	3	evict
ex	9	88	3564	3	ex___
exacta	15	33	739	3	exacta
exacts	15	35	961	3	exacts
exalts	13	32	831	3	exalts
exams	14	19	908	3	exams
exapted	17	3	607	3	exapted
excel	14	3	774	3	excel
except	17	9	765	3	except
excite	15	3	1088	3	excite
exec	13	53	1394	3	ex_ec
execs	14	53	972	3	execs
exed	12	54	2059	3	ex_ed
exempt	17	3	745	3	exempt
exerts	13	37	1229	3	exerts
exes	11	65	3081	3	ex_es
exeunt	13	3	870	3	exeunt
exhale	16	3	687	3	exhale
exhaust	17	4	424	3	exhaust
exhort	16	4	1080	3	exhort
exile	12	61	1765	3	exile
exine	12	55	1849	3	exine
exing	13	60	1681	3	exing
exists	13	47	1091	3	exists
exits	12	55	1591	3	exits
exon	11	71	1680	3	ex_on
exons	12	58	1334	3	exons
expands	17	19	573	3	expands
expanse	16	14	560	3	expanse
expects	18	6	688	3	expects
expels	15	4	717	3	expels
expend	16	24	750	3	expend
experts	16	5	906	3	experts
expiated	18	16	852	3	expiated
expiates	17	8	1021	3	expiates
expiator	17	4	704	3	expiator
expire	15	3	802	3	expire
expiry	18	3	465	3	expiry
explain	16	6	704	3	explain
explants	17	3	702	3	explants
exploit	16	4	862	3	exploit
exports	16	4	798	3	exports
exposal	16	4	531	3	exposal
expose	15	4	952	3	expose
exposit	16	4	968	3	exposit
exsect	15	5	850	3	exsect
exsert	13	4	1436	3	exsert
extent	13	27	1491	3	extent
extol	12	4	789	3	extol
extort	13	5	1397	3	extort
extra	12	3	900	3	extra
extract	16	3	1101	3	extract
extras	13	3	1022	3	extras
exudate	15	3	709	3	exudate
exude	13	40	1029	3	exude
exults	13	25	763	3	exults
exurb	14	5	770	3	exurb
eyas	7	64	2743	3	e_yas
eyra	7	62	1755	3	eyra_
eyras	8	47	1592	3	eyras
fat	6	81	7808	3	__fat
feat	7	64	5822	3	_feat
fiat	7	66	4664	3	_fiat
flat	7	71	4782	3	_flat
float	8	59	2857	3	float
frat	7	56	4854	3	_frat
gat	4	68	8051	3	__gat
ghat	8	64	3528	3	_ghat
gloat	6	54	2768	3	gloat
gnat	5	60	3443	3	_gnat
goat	5	62	5083	3	_goat
grat	5	56	5128	3	_grat
great	6	60	3424	3	great
groat	6	55	3197	3	groat
hapax	17	3	932	3	hapax
hat	6	72	8996	3	__hat
heat	7	70	6142	3	_heat
hepcat	13	6	1182	3	hepcat
hereat	9	35	2741	3	hereat
hexad	16	49	1062	3	hex_ad
ikat	8	76	2664	3	_ikat
impact	12	23	1044	3	impact
impart	10	27	1513	3	impart
inapt	7	35	2269	3	inapt
input	7	3	1465	3	input
ixia	11	57	1320	3	ixia_
ixias	12	48	836	3	ixias
japan	14	4	1123	3	japan
jurat	12	48	2932	3	jurat
kapa	10	60	2129	3	kapa_
kapas	11	60	2173	3	kapas
kaput	11	7	1706	3	kaput
karat	9	68	3759	3	karat
kat	7	74	6829	3	__kat
kempt	13	43	1846	3	kemp_t
kept	10	62	3294	3	kep_t
keypad	16	3	382	3	keypad
keypal	15	3	489	3	keypal
khat	11	67	3072	3	_khat
korat	9	49	3443	3	korat
kyat	11	60	2552	3	_kyat
lat	3	75	9340	3	__lat
leapt	7	50	2747	3	leap_t
lept	6	64	4088	3	lep_t
lepta	7	57	1439	3	lepta
lipa	6	84	2592	3	lipa_
lovat	8	3	2104	3	lovat
manat	7	60	3998	3	manat
mat	5	80	8393	3	__mat
meat	6	63	5960	3	_meat
moat	6	63	5203	3	_moat
napa	6	69	2726	3	napa_
napas	7	59	2435	3	napas
neat	4	63	5678	3	_neat
next	11	66	3108	3	nex__t
nipa	6	94	2163	3	nipa_
nipas	7	71	1667	3	nipas
nopal	7	55	1710	3	nopal
oat	3	98	8826	3	__oat
opah	9	62	1840	3	_opah
opal	6	69	2352	3	_opal
opt	5	75	4554	3	_op_t
oxcart	15	3	952	3	oxcart
pa	4	104	5648	3	__pa_
pac	7	90	5408	3	__pac
pact	8	66	4872	3	__pact
pad	6	80	5732	3	__pad
pah	8	88	5359	3	__pah
pal	5	67	6167	3	__pal
pam	7	78	5839	3	__pam
pan	5	84	6644	3	__pan
pant	6	60	6125	3	__pant
pap	7	67	5840	3	__pap
papa	8	58	2714	3	papa_
papal	9	58	2067	3	papal
papas	9	49	2749	3	papas
papaw	12	51	1249	3	papaw
par	5	74	6702	3	__par
part	6	59	6746	3	__part
pas	5	87	7574	3	__pas
past	6	59	5901	3	__past
pate	6	53	5046	3	__pate
path	9	91	3491	3	__path
pats	6	64	6085	3	__pats
paty	9	52	3456	3	__paty
paw	8	76	5117	3	__paw
pax	12	73	4685	3	__pax
pay	8	84	6118	3	__pay
peat	6	59	6793	3	_peat
pet	5	64	7730	3	__pet
phat	9	58	3786	3	_phat
phpht	15	3	806	3	phpht
pht	8	60	3052	3	__pht
pipal	9	51	1835	3	pipal
pipet	9	55	3332	3	pipet
pipit	9	52	2487	3	pipit
pit	5	64	7192	3	__pit
plat	6	60	4887	3	_plat
pleat	7	47	3447	3	pleat
pot	5	80	7843	3	__pot
prat	6	59	5204	3	_prat
pst	5	79	3251	3	__pst
pupa	8	54	2281	3	pupa_
pupae	9	65	1564	3	pupae
pupal	9	76	1687	3	pupal
pupas	9	52	1928	3	pupas
pupate	10	42	1312	3	pupate
put	5	57	5907	3	__put
qanat	14	44	2684	3	qanat
qat	12	52	5333	3	__qat
rabat	7	28	3222	3	rabat
rapt	6	72	4531	3	rap_t
rat	3	78	9274	3	__rat
recoat	8	40	2427	3	recoat
reheat	9	44	2394	3	reheat
repast	8	35	2063	3	repast
repay	10	48	1845	3	repay
repeat	8	51	2721	3	repeat
repot	7	51	3262	3	repot
resat	5	51	3968	3	resat
reseat	6	41	3149	3	reseat
respot	8	31	1763	3	respot
sat	3	62	8848	3	__sat
scat	6	58	4837	3	_scat
seat	4	75	7556	3	_seat
secpar	10	3	792	3	secpar
sepal	7	77	2300	3	sepal
sept	6	58	4436	3	sep_t
septa	7	55	1808	3	septa
sexist	13	30	1348	3	sexist
sexpots	16	3	629	3	sexpots
sext	11	73	3809	3	sex__t
sextan	13	38	964	3	sextan
sextant	14	29	1196	3	sextant
sextet	13	9	1687	3	sextet
sexual	13	3	841	3	sexual
shat	7	64	5659	3	_shat
shoat	8	56	3394	3	shoat
skat	8	70	3789	3	_skat
slat	4	69	5902	3	_slat
spa	5	57	3081	3	_spa_
spae	6	50	3432	3	_spae
spait	7	56	3160	3	_spait
spam	8	59	3004	3	_spam
span	6	52	3466	3	_span
spar	6	54	3330	3	_spar
spas	6	70	3672	3	_spas
spate	7	47	3158	3	_spate
spats	7	50	3138	3	_spats
spay	9	66	3166	3	_spay
spaz	15	56	2616	3	_spaz
spit	6	55	4508	3	_spit
splat	7	61	2934	3	splat
spot	6	55	4068	3	_spot
sprat	7	66	3597	3	sprat
squat	14	37	2014	3	squat
stat	4	73	5269	3	_stat
stoat	5	71	3595	3	stoat
swat	7	72	4444	3	_swat
sweat	8	56	2840	3	sweat
tapa	6	51	2914	3	tapa_
tapas	7	46	2771	3	tapas
tat	3	76	9029	3	__tat
teapot	8	4	1676	3	teapot
teat	4	59	6363	3	_teat
tempt	9	51	2484	3	temp_t
teopan	8	3	935	3	teopan
tepa	6	60	2168	3	tepa_
tepal	7	63	1958	3	tepal
tepas	7	65	2168	3	tepas
texas	12	65	1493	3	tex_as
text	11	60	3393	3	tex__t
that	7	56	3932	3	_that
tipcat	10	3	1265	3	tipcat
topaz	16	3	1532	3	topaz
trapt	7	64	3339	3	trapt
treat	5	62	4035	3	treat
twat	7	58	3151	3	_twat
typal	10	53	1115	3	typal
ulpan	7	3	1012	3	ulpan
unapt	7	104	2159	3	unapt
unhat	8	11	1926	3	unhat
upas	6	83	2238	3	_upas
vat	6	78	6345	3	__vat
vext	14	69	2776	3	vex__t
wat	6	73	7892	3	__wat
wept	9	56	3505	3	wep_t
what	10	54	3407	3	_what
wheat	11	49	2457	3	wheat
wrapt	10	51	2318	3	wrapt
xyst	14	47	1407	3	_xyst

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	83667	0.266	671770.7
2	DLD Change Limit	83667	394	5.140	16277.6
3	Display Results	394	394	0.110	3581.8
	(SQL Overall)	178691	394	5.516	32395.0