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

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

356 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
expats	15	3	768	(None)
expat	14	3	1381	1	expat_
eats	4	70	5487	2	e__ats
eclats	8	3	1303	2	eclats
epacts	10	50	1039	2	e_pacts
exacts	15	35	961	2	exacts
exalts	13	32	831	2	exalts
exams	14	19	908	2	ex_ams
exerts	13	37	1229	2	exerts
exists	13	47	1091	2	exists
exits	12	55	1591	2	ex_its
expand	16	23	657	2	expand
expands	17	19	573	2	expands
expanse	16	14	560	2	expanse
expects	18	6	688	2	expects
expels	15	4	717	2	expels
experts	16	5	906	2	experts
expiate	16	9	1059	2	expiate
expiates	17	8	1021	2	expiates
explants	17	3	702	2	explants
exports	16	4	798	2	exports
expos	14	4	920	2	exp_os
exults	13	25	763	2	exults
pats	6	64	6085	2	__pats
sexpots	16	3	629	2	sexpots
spats	7	50	3138	2	_spats
adapts	9	10	781	3	adapts
appals	10	48	1294	3	appals
arhats	9	3	1297	3	arhats
bats	6	69	6233	3	__bats
beats	7	60	4224	3	_beats
bedpans	12	3	717	3	bedpans
blats	7	51	3250	3	_blats
bleats	8	55	1861	3	bleats
bloats	8	52	1576	3	bloats
boats	7	56	3515	3	_boats
brats	7	53	3601	3	_brats
bypass	13	4	504	3	bypass
bypast	13	11	737	3	bypast
bypath	16	4	535	3	bypath
bypaths	17	4	319	3	bypaths
carats	8	59	2902	3	carats
cats	6	63	5634	3	__cats
chats	10	57	3009	3	_chats
cheats	11	45	1954	3	cheats
cleats	8	49	1931	3	cleats
coapts	10	46	1401	3	coapts
coats	7	56	3500	3	_coats
copals	10	50	1894	3	copals
copays	13	49	1127	3	copays
cowpats	14	3	771	3	cowpats
defats	10	51	1455	3	defats
defeats	11	35	1123	3	defeats
departs	10	43	1068	3	departs
depots	9	47	1634	3	depots
derats	7	46	2506	3	derats
despots	10	31	968	3	despots
doats	6	52	2488	3	_doats
dopants	10	3	843	3	dopants
dopas	8	50	1906	3	dopa_s
drats	6	66	2837	3	_drats
ducats	9	50	1176	3	ducats
ears	4	63	5659	3	e__ars
east	4	66	5910	3	e__ast
easts	5	75	3032	3	e_asts
eat	3	69	8905	3	e__at_
eath	7	57	3566	3	e__ath
ebbets	10	37	683	3	ebbets
eclat	7	5	2360	3	eclat_
edicts	9	49	1170	3	edicts
edits	6	58	1903	3	e_dits
educts	9	43	989	3	educts
efts	7	65	1948	3	e__fts
egads	7	46	1092	3	e_gads
egests	7	44	1125	3	egests
eggars	8	39	897	3	eggars
egrets	7	27	1224	3	egrets
eights	10	36	1898	3	eights
ejects	15	40	995	3	ejects
elans	5	55	2775	3	e_lans
elate	5	53	3588	3	e_late
elates	6	50	3236	3	e_lates
elects	8	33	1500	3	elects
elints	6	58	1642	3	elints
eluants	7	3	758	3	eluants
eluate	6	23	1543	3	eluate
eluates	7	20	1468	3	eluates
embars	10	38	1288	3	embars
embays	13	140	833	3	embays
emits	7	54	2147	3	e_mits
emmets	10	34	915	3	emmets
empale	10	26	1126	3	empale
empales	11	24	1143	3	empales
empathy	17	4	348	3	empathy
empty	12	4	776	3	emp_ty
enacts	8	40	1297	3	enacts
enate	5	44	2814	3	e_nate
enates	6	40	2642	3	e_nates
epact	9	49	2153	3	e_pact
epees	7	52	1983	3	e_pees
ephahs	14	3	550	3	ephahs
ephas	10	3	1154	3	e_phas
epics	9	50	1428	3	e_pics
epos	6	67	2373	3	e_p_os
equals	15	3	869	3	equals
equate	15	20	1246	3	equate
equates	16	20	1232	3	equates
eras	4	54	4150	3	e_ra_s
erects	8	41	1618	3	erects
ergate	7	3	1514	3	ergate
ergates	8	3	1449	3	ergates
ergots	7	45	1237	3	ergots
errants	7	4	1064	3	errants
errata	6	3	901	3	errata
erratas	7	3	686	3	erratas
ersatz	15	3	665	3	ersatz
eructs	8	36	1079	3	eructs
erupts	8	34	890	3	erupts
escars	8	39	1313	3	escars
escots	8	42	1174	3	escots
eskars	10	35	759	3	eskars
esparto	9	4	423	3	esparto
espartos	10	4	433	3	espartos
espials	9	3	709	3	espials
espies	8	37	1680	3	espies
esprits	9	3	839	3	esprits
essays	9	6	565	3	essays
estate	6	47	1976	3	estate
estates	7	45	2018	3	estates
etapes	8	54	1529	3	etapes
etas	4	64	3227	3	e_ta_s
etnas	5	47	1393	3	etna_s
events	9	48	1407	3	events
everts	9	45	1489	3	everts
evicts	11	36	855	3	evicts
exact	14	35	1693	3	ex_act
exacta	15	33	739	3	exacta
exactas	16	33	643	3	exactas
exalt	12	30	1853	3	ex_alt
exam	13	25	1462	3	ex_a_m
exapted	17	3	607	3	exapted
excels	15	3	666	3	excels
excepts	18	8	520	3	excepts
excess	15	4	605	3	excess
excite	15	3	1088	3	excite
excites	16	3	1063	3	excites
execs	14	53	972	3	ex_ecs
exempts	18	4	402	3	exempts
exert	12	46	2414	3	exert_
exes	11	65	3081	3	ex__es
exhale	16	3	687	3	exhale
exhales	17	3	714	3	exhales
exhaust	17	4	424	3	exhaust
exhausts	18	4	296	3	exhausts
exhorts	17	4	631	3	exhorts
exiles	13	48	1640	3	exiles
exines	13	57	1580	3	exines
exist	12	46	1894	3	exist_
exit	11	44	2867	3	ex_it_
exodos	14	3	594	3	exodos
exodus	14	3	465	3	exodus
exons	12	58	1334	3	ex_ons
expanses	17	15	617	3	expanses
expect	17	5	890	3	expect
expel	14	4	823	3	exp_el
expend	16	24	750	3	expend
expends	17	21	708	3	expends
expense	16	12	787	3	expense
expert	15	5	1535	3	expert
expiated	18	16	852	3	expiated
expiator	17	4	704	3	expiator
expiators	18	4	680	3	expiators
expire	15	3	802	3	expire
expires	16	3	868	3	expires
expiry	18	3	465	3	expiry
explain	16	6	704	3	explain
explains	17	6	644	3	explains
explant	16	3	1013	3	explant
exploits	17	4	597	3	exploits
expo	13	4	918	3	exp__o
export	15	4	1218	3	export
exposals	17	4	404	3	exposals
expose	15	4	952	3	expose
exposes	16	3	996	3	exposes
exposits	17	4	724	3	exposits
express	16	3	749	3	express
expulse	16	7	451	3	expulse
exsects	16	5	557	3	exsects
exserts	14	6	701	3	exserts
extant	13	27	1475	3	extant
extents	14	26	1017	3	extents
extols	13	3	768	3	extols
extorts	14	4	775	3	extorts
extracts	17	4	762	3	extracts
extras	13	3	1022	3	extras
exudate	15	3	709	3	exudate
exudates	16	3	662	3	exudates
exudes	14	37	1036	3	exudes
exult	12	28	1412	3	exult_
exurbs	15	3	442	3	exurbs
eyas	7	64	2743	3	e_ya_s
eyass	8	44	1078	3	e_yass
eyras	8	47	1592	3	eyra_s
fats	7	62	5250	3	__fats
feats	8	64	3275	3	_feats
fiats	8	53	2448	3	_fiats
flats	8	64	2974	3	_flats
floats	9	68	1625	3	floats
frats	8	68	2967	3	_frats
gats	5	67	5344	3	__gats
ghats	9	58	1861	3	_ghats
gloats	7	45	1542	3	gloats
gnats	6	52	1771	3	_gnats
goats	6	55	2730	3	_goats
greats	7	63	1839	3	greats
groats	7	48	1665	3	groats
hats	7	68	5825	3	__hats
heats	8	58	3840	3	_heats
hepcats	14	3	647	3	hepcats
hexads	17	46	819	3	hex_ads
ikats	9	53	1115	3	_ikats
impacts	13	26	650	3	impacts
imparts	11	29	853	3	imparts
inputs	8	3	770	3	inputs
ixias	12	48	837	3	ixia_s
japans	15	3	982	3	japans
jurats	13	42	1320	3	jurats
kapas	11	60	2173	3	kapa_s
karats	10	64	2049	3	karats
kats	8	59	4433	3	__kats
keypads	17	4	334	3	keypads
keypals	16	3	435	3	keypals
khats	12	53	1601	3	_khats
korats	10	54	1606	3	korats
kyats	12	50	1244	3	_kyats
lats	4	59	6270	3	__lats
lovats	9	3	907	3	lovats
manats	8	46	2346	3	manats
mats	6	54	6029	3	__mats
meats	7	50	3405	3	_meats
moats	7	58	2764	3	_moats
napas	7	59	2435	3	napa_s
neats	5	59	3190	3	_neats
nipas	7	71	1667	3	nipa_s
nopals	8	49	1402	3	nopals
oats	4	65	5421	3	__oats
opahs	10	54	1198	3	_opahs
opals	7	57	1835	3	_opals
opts	6	81	2474	3	_op_ts
oxcarts	16	3	431	3	oxcarts
pacs	8	58	4218	3	__pacs
pacts	9	51	2580	3	__pacts
pads	7	67	4295	3	__pads
pals	6	69	5135	3	__pals
pams	8	56	4176	3	__pams
pans	6	58	5573	3	__pans
pants	7	65	3692	3	__pants
papas	9	49	2749	3	papa_s
papaws	13	41	911	3	papaws
paps	8	64	4345	3	__paps
pars	6	75	6079	3	__pars
parts	7	77	4337	3	__parts
pas	5	87	7574	3	__pa_s
pass	6	52	3995	3	__pass
past	6	59	5901	3	__past
pasts	7	59	3650	3	__pasts
pat	5	80	8946	3	__pat_
pate	6	53	5046	3	__pate
pates	7	60	4789	3	__pates
path	9	91	3491	3	__path
paths	10	55	2138	3	__paths
patsy	10	57	1720	3	__patsy
paty	9	52	3456	3	__paty
paws	9	60	3818	3	__paws
pays	9	59	4022	3	__pays
peats	7	61	4019	3	_peats
pets	6	62	4833	3	__pets
pipals	10	42	1364	3	pipals
pipets	10	57	1477	3	pipets
pipits	10	47	1306	3	pipits
pits	6	63	4874	3	__pits
plats	7	55	3137	3	_plats
pleats	8	52	1859	3	pleats
pots	6	64	5236	3	__pots
prats	7	63	3339	3	_prats
pupas	9	52	1928	3	pupa_s
pupate	10	42	1312	3	pupate
pupates	11	33	1143	3	pupates
puts	6	56	4175	3	__puts
qanats	15	41	1281	3	qanats
qats	13	53	3134	3	__qats
rabats	8	31	1622	3	rabats
rats	4	62	6037	3	__rats
recoats	9	26	1664	3	recoats
reheats	10	45	1352	3	reheats
repass	8	41	1470	3	repass
repast	8	35	2063	3	repast
repasts	9	36	1193	3	repasts
repays	11	38	1397	3	repays
repeats	9	43	1605	3	repeats
repots	8	56	2100	3	repots
reseats	7	43	1958	3	reseats
respots	9	29	1276	3	respots
scats	7	59	3060	3	_scats
seats	5	48	4434	3	_seats
secpars	11	3	841	3	secpars
sepals	8	52	1737	3	sepals
septs	7	54	2060	3	sep_ts
sexists	14	26	767	3	sexists
sexpot	15	3	954	3	sexpot_
sextans	14	34	926	3	sextans
sextants	15	28	738	3	sextants
sextets	14	9	714	3	sextets
sexts	12	51	1838	3	sex__ts
shoats	9	41	1708	3	shoats
skats	9	46	2154	3	_skats
slats	5	54	3690	3	_slats
spaes	7	60	2997	3	_spaes
spaits	8	50	1747	3	_spaits
spams	9	49	2219	3	_spams
spans	7	45	2873	3	_spans
spars	7	54	3154	3	_spars
spas	6	70	3672	3	_spa_s
spat	6	65	4852	3	_spat_
spate	7	47	3158	3	_spate
spates	8	50	2817	3	_spates
spays	10	55	2051	3	_spays
spits	7	44	2955	3	_spits
splats	8	48	1730	3	splats
spots	7	44	2411	3	_spots
sprats	8	58	1993	3	sprats
squats	15	37	1296	3	squats
stats	5	59	3336	3	_stats
stoats	6	51	1748	3	stoats
swats	8	57	2686	3	_swats
sweats	9	48	1461	3	sweats
tapas	7	46	2771	3	tapa_s
tats	4	68	5813	3	__tats
teapots	9	3	905	3	teapots
teats	5	56	3681	3	_teats
tempts	10	43	945	3	temp_ts
teopans	9	3	920	3	teopans
tepals	8	54	1504	3	tepals
tepas	7	65	2168	3	tepa_s
texas	12	65	1493	3	tex_a_s
texts	12	55	1504	3	tex__ts
tipcats	11	3	710	3	tipcats
treats	6	48	2169	3	treats
twats	8	66	1660	3	_twats
unhats	9	11	1062	3	unhats
upas	6	83	2238	3	_upa_s
vats	7	68	4174	3	__vats
wats	7	75	5588	3	__wats
whats	11	77	1899	3	_whats
wheats	12	50	1322	3	wheats
xysts	15	55	812	3	_xysts

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.143	1249587.4
2	DLD Change Limit	112716	356	5.500	20493.8
3	Display Results	356	356	0.110	3236.4
	(SQL Overall)	178691	356	5.753	31060.5