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

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

405 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
siesta	6	3	950	(None)
fiesta	9	3	812	1	fiesta
siestas	7	3	881	1	siestas
cesta	7	54	1948	2	_cesta
cuesta	8	3	851	2	cuesta
egesta	7	42	865	2	egesta
fiestas	10	3	843	2	fiestas
pieta	7	54	2175	2	pie_ta
septa	7	55	1808	2	s_epta
seta	4	56	3731	2	s_e_ta
shelta	9	31	1179	2	shelta
shiest	9	58	2152	2	shiest_
sienna	6	4	719	2	sienna
sierra	6	3	731	2	sierra
silesia	7	3	908	2	silesia
sistra	6	3	933	2	si_stra
sliest	6	66	2195	2	sliest_
testa	5	48	2204	2	_testa
vesta	8	66	1830	2	_vesta
vista	8	54	1660	2	vi_sta
aceta	7	40	1735	3	ace_ta
airest	6	38	2526	3	airest_
arietta	7	8	890	3	arietta
arista	6	4	1529	3	arista
ashiest	10	3	1395	3	ashiest_
best	6	63	5532	3	_best_
bests	7	59	3261	3	_bests
beta	6	62	3413	3	_be_ta
betta	7	49	1684	3	_betta
biota	7	45	1682	3	bi_ota
biretta	9	4	724	3	biretta
blest	7	64	3172	3	blest_
busiest	9	37	1630	3	busiest_
celesta	9	4	764	3	celesta
cestas	8	50	1854	3	_cestas
cesti	7	52	1742	3	_cesti
chest	10	49	2614	3	chest_
chests	11	49	1626	3	chests
chesty	14	46	1050	3	chesty
cist	6	72	4496	3	ci_st_
cists	7	66	2453	3	ci_sts
cosiest	9	38	1985	3	cosiest_
costa	7	55	2373	3	_costa
crest	7	46	3269	3	crest_
crestal	9	3	1213	3	crestal
crests	8	52	1870	3	crests
crista	8	3	1180	3	crista
cuestas	9	5	793	3	cuestas
deist	6	46	3359	3	deist_
deists	7	49	1643	3	deists
delta	6	61	1777	3	_delta
dicta	8	49	1563	3	di_cta
didst	7	46	1961	3	didst_
dies	5	56	5352	3	dies__
diesel	7	44	1040	3	diesel
dieses	7	52	1869	3	dieses
diesis	7	40	1349	3	diesis
diester	8	30	1368	3	diester
diet	5	73	5753	3	die_t_
diets	6	60	2664	3	die_ts
digest	8	40	1962	3	digest_
digests	9	36	1061	3	digests
direst	7	50	2424	3	direst_
distal	7	36	1577	3	di_stal
dita	5	60	3252	3	di__ta
divest	10	68	2007	3	divest_
divests	11	45	1093	3	divests
doest	6	58	2952	3	doest_
drest	6	55	3034	3	drest_
driest	7	47	2275	3	driest_
easiest	7	23	1877	3	easiest_
egest	6	52	2234	3	egest_
egests	7	44	1125	3	egests
ejecta	15	33	739	3	ejecta
eta	3	58	3419	3	__e_ta
feist	8	62	3007	3	feist_
feists	9	49	1531	3	feists
feisty	12	44	929	3	feisty
fest	7	49	4944	3	_fest_
festal	9	42	1356	3	_festal
fests	8	58	2804	3	_fests
feta	7	65	2890	3	_fe_ta
finest	9	43	2173	3	finest_
first	8	62	2612	3	first_
firsts	9	51	1092	3	firsts
fist	7	62	4842	3	fi_st_
fists	8	55	2754	3	fi_sts
fliest	9	47	1843	3	fliest_
frusta	9	3	745	3	frusta
geest	6	48	2961	3	geest_
geests	7	59	1216	3	geests
geisha	10	3	520	3	geisha
gest	5	61	4913	3	_gest_
geste	6	59	2069	3	_geste
gests	6	60	2881	3	_gests
geta	5	66	2744	3	_ge_ta
gies	5	56	4142	3	gies__
gist	5	60	4676	3	gi_st_
gists	6	60	2619	3	gi_sts
guest	6	52	2592	3	guest_
guests	7	43	1120	3	guests
heist	8	70	3091	3	heist_
heists	9	68	1463	3	heists
hest	7	59	5077	3	_hest_
hests	8	58	2993	3	_hests
hies	7	48	4283	3	hies__
hist	7	65	5154	3	hi_st_
hists	8	63	2837	3	hi_sts
hosta	8	59	1783	3	_hosta
iciest	8	29	1474	3	iciest_
ingesta	8	35	786	3	ingesta
instal	6	7	1219	3	_instal
instar	6	3	1001	3	_instar
iota	4	51	2783	3	_i_ota
isba	6	13	1088	3	_i_sba
jest	11	67	3850	3	_jest_
jests	12	59	2245	3	_jests
kiester	11	32	997	3	kiester
kist	8	65	4079	3	ki_st_
kists	9	58	2211	3	ki_sts
lepta	7	57	1439	3	_lepta
lest	4	69	5632	3	_lest_
lies	4	64	5419	3	lies__
likest	10	49	1438	3	likest_
likuta	10	3	421	3	likuta
list	4	70	5534	3	li_st_
lists	5	66	2869	3	li_sts
livest	9	53	1573	3	livest_
menta	7	44	2442	3	_menta
mesa	6	70	2548	3	_mes_a
meta	6	59	3241	3	_me_ta
miasma	10	9	756	3	miasma
midst	8	59	2255	3	midst_
midsts	9	55	1005	3	midsts
miseat	8	29	2570	3	miseat
mist	6	61	5453	3	mi_st_
mists	7	66	3390	3	mi_sts
misty	10	61	2045	3	mi_sty
neist	5	46	2844	3	neist_
nest	4	55	4873	3	_nest_
nests	5	57	2800	3	_nests
nicest	8	23	1566	3	nicest_
nosiest	7	34	1567	3	nosiest_
olestra	7	4	617	3	olestra
omenta	8	34	1172	3	omenta
pasta	7	66	2453	3	_pasta
peseta	8	3	1057	3	_peseta
pest	6	55	5529	3	_pest_
pesto	7	57	2372	3	_pesto
pests	7	59	3327	3	_pests
pesty	10	64	2171	3	_pesty
pies	6	69	4960	3	pies__
pietas	8	45	1650	3	pie_tas
piety	10	58	1730	3	pie_ty
pigsty	12	3	593	3	pigsty
pinata	8	38	1722	3	pinata
pineta	8	58	1556	3	pineta
pinta	7	57	2705	3	pi_nta
piste	7	58	2460	3	pi_ste
pita	6	54	3643	3	pi__ta
pitta	7	50	1869	3	pi_tta
podesta	10	3	676	3	podesta
presa	7	43	1904	3	pres_a
prest	7	57	3635	3	prest_
presto	8	42	1620	3	presto
prests	8	40	2126	3	prests
priest	8	41	2542	3	priest_
priests	9	38	1086	3	priests
quest	14	41	2132	3	quest_
quests	15	33	1035	3	quests
reata	5	42	2539	3	_reata
recta	7	42	2026	3	_recta
reest	5	49	3809	3	reest_
reests	6	46	1889	3	reests
resat	5	51	3968	3	_resat
rest	4	64	5984	3	_rest_
rests	5	49	3587	3	_rests
riata	5	46	1802	3	ri_ata
rifest	9	31	1458	3	rifest_
ripest	8	43	1794	3	ripest_
ristra	6	3	1071	3	ri_stra
rosiest	7	39	1921	3	rosiest_
safest	9	50	1660	3	safest_
sagest	7	49	2026	3	sagest_
sagiest	8	26	1798	3	sagiest_
salsa	5	67	1892	3	sals_a
sancta	8	3	983	3	sancta
sanest	6	44	2669	3	sanest_
sapota	8	3	1021	3	sapota
sayest	9	42	1774	3	sayest_
sayst	8	53	2200	3	sayst_
scena	7	48	1578	3	sce_na
scent	7	58	3162	3	scent_
scents	8	53	1702	3	scents
scrota	8	3	1019	3	scrota
scuta	7	58	1575	3	s_cuta
sea	3	61	6129	3	s_e__a
seat	4	75	7556	3	s_eat_
seats	5	48	4434	3	s_eats
sect	6	74	4362	3	s_ect_
sects	7	56	2289	3	s_ects
sees	4	53	6105	3	sees__
seesaw	9	3	597	3	seesaw
seis	4	55	4239	3	seis__
seise	5	47	2785	3	seis_e
seised	7	42	1812	3	seised
seiser	6	53	1834	3	seiser
seises	6	40	2671	3	seises
seisin	6	37	1512	3	seisin
seism	7	50	1902	3	seis_m
seismal	9	3	730	3	seismal
seisms	8	49	1214	3	seisms
seisor	6	37	1233	3	seisor
seitan	6	26	1323	3	s_eitan
selva	8	30	1427	3	s_elva
senna	5	46	1798	3	s_enna
sensa	5	41	1747	3	s_ensa
sent	4	69	6301	3	s_ent_
sente	5	64	3287	3	s_ente
senti	5	62	2670	3	s_enti
sepia	7	53	1867	3	s_epia
sept	6	58	4436	3	s_ept_
septal	8	45	1338	3	s_eptal
septs	7	54	2060	3	s_epts
sera	4	61	4139	3	s_e_ra
serest	6	48	3161	3	serest_
sestet	6	8	2620	3	s_estet
sestina	7	27	1197	3	s_estina
set	3	66	8125	3	s_e_t_
setae	5	60	2622	3	s_e_tae
setal	5	64	3090	3	s_e_tal
sets	4	55	4950	3	s_e_ts
sett	4	59	4905	3	s_e_tt
setts	5	51	2432	3	s_etts
sexiest	14	21	1222	3	sexiest_
sext	11	73	3809	3	s_ext_
sextan	13	38	964	3	s_extan
sexto	12	44	1545	3	s_exto
sexts	12	51	1838	3	s_exts
shea	7	60	3157	3	she__a
sheath	12	4	1289	3	sheath
sheet	8	48	3696	3	sheet_
sheets	9	39	1850	3	sheets
sheila	9	6	984	3	sheila
sheitan	10	3	657	3	sheitan
sheltas	10	27	967	3	sheltas
shelty	12	40	1155	3	shelty
shent	8	59	3350	3	shent_
sherpa	11	3	809	3	sherpa
shes	7	57	3435	3	shes__
shies	8	61	3655	3	shies__
shiksa	13	9	465	3	shiks_a
shist	8	48	2961	3	shist_
shists	9	65	1511	3	shists
shyest	12	55	1183	3	shyest_
sibs	6	59	3354	3	sibs__
sices	7	56	3727	3	sices__
sickest	13	18	1379	3	sickest_
sics	6	52	3409	3	sics__
sides	6	58	3836	3	sides__
sidestep	11	4	424	3	sidestep
siege	6	67	1844	3	sie_ge
sieged	8	52	1271	3	sieged
sieges	7	38	1683	3	sieges
sienite	7	3	1271	3	sienite
siennas	7	3	612	3	siennas
sierran	7	3	719	3	sierran
sierras	7	3	786	3	sierras
sieur	5	9	1189	3	sie_ur
sieurs	6	5	904	3	sieurs
sieve	8	49	1884	3	sie_ve
sieved	10	46	1144	3	sieved
sieves	9	32	1600	3	sieves
sifaka	13	5	355	3	sifaka
sift	7	107	4066	3	si_ft_
sifts	8	49	1892	3	si_fts
sight	9	46	2929	3	sight_
sights	10	38	1801	3	sights
sigla	6	45	1520	3	si_gla
sigma	8	45	1383	3	si_gma
signa	6	61	1470	3	si_gna
sika	8	60	2132	3	si__ka
sikes	9	62	3608	3	sikes__
silent	6	41	2584	3	silent_
silents	7	35	1449	3	silents
silesias	8	4	852	3	silesias
silica	8	3	1124	3	silica
silt	4	65	5819	3	si_lt_
silts	5	53	3082	3	si_lts
silty	8	47	2163	3	si_lty
silva	8	27	1402	3	si_lva
sima	6	47	3078	3	si__ma
simitar	9	3	673	3	simitar
sims	6	57	3717	3	sims__
sines	5	59	5482	3	sines__
sins	4	67	5527	3	sins__
sipes	7	60	3695	3	sipes__
sips	6	57	4010	3	sips__
sires	5	59	4537	3	sires__
sirra	5	44	1632	3	si_rra
sirs	4	43	3833	3	sirs__
sis	3	73	6054	3	si_s__
sisal	5	42	1773	3	si_sal
sises	5	52	3383	3	si_ses
sisses	6	45	2060	3	sisses
sissy	8	58	1207	3	si_ssy
sister	6	44	2158	3	si_ster
sit	3	58	7775	3	si__t_
sitar	5	48	2054	3	si__tar
site	4	70	5241	3	si__te
sites	5	60	4543	3	sites__
sith	7	54	3515	3	si__th
sits	4	50	5020	3	si__ts
sixes	12	45	2636	3	sixes__
sixte	12	62	1658	3	si_xte
sixth	15	55	1223	3	si_xth
sixty	15	49	1273	3	si_xty
sizes	14	67	2776	3	sizes__
siziest	16	3	1147	3	siziest_
skeet	9	54	2918	3	skeet_
skeets	10	45	1325	3	skeets
skies	9	50	2683	3	skies__
sleet	5	56	3913	3	sleet_
sleets	6	43	1887	3	sleets
sleety	9	41	1265	3	sleety
slept	7	57	2810	3	slept_
sleuth	9	3	723	3	sleuth
slyest	9	38	1136	3	slyest_
smegma	11	3	411	3	smegma
smelt	7	47	2678	3	smelt_
smelts	8	54	1277	3	smelts
snidest	8	3	1091	3	snidest_
softa	8	64	1518	3	s_ofta
somata	8	3	1238	3	somata
sonata	6	3	1322	3	sonata
sorest	6	50	2800	3	sorest_
sorta	5	71	2541	3	s_orta
spectra	11	27	583	3	spectra
spelt	7	54	3019	3	spelt_
spelts	8	46	1464	3	spelts
speltz	17	40	1012	3	speltz
spent	7	55	3283	3	spent_
spies	7	60	3762	3	spies__
spriest	9	27	1864	3	spriest_
sputa	7	46	1296	3	s_puta
stela	5	40	1904	3	ste_la
stella	6	36	1297	3	stella
stemma	10	32	813	3	stemma
stent	5	56	3451	3	stent_
stents	6	50	1945	3	stents
sterna	6	37	1276	3	sterna
stet	4	59	4732	3	ste_t_
stets	5	54	2391	3	ste_ts
sties	5	51	3298	3	sties__
strata	6	36	1628	3	strata
stretta	7	3	729	3	stretta
subsea	8	26	1019	3	subsea
sues	4	62	4765	3	sues__
suet	4	67	5482	3	sue_t_
suets	5	51	2610	3	sue_ts
suety	8	53	1849	3	sue_ty
surest	6	50	2676	3	surest_
sutta	5	40	1533	3	s_utta
svelte	9	31	975	3	svelte
sweat	8	56	2840	3	sweat_
sweats	9	48	1461	3	sweats
sweaty	12	37	1005	3	sweaty
sweet	8	53	3052	3	sweet_
sweets	9	42	1443	3	sweets
swept	10	57	2060	3	swept_
tecta	7	42	1552	3	_tecta
tesla	5	56	1260	3	_tesla
test	4	86	5162	3	_test_
testae	6	42	1625	3	_testae
tests	5	65	3019	3	_tests
testy	8	54	1906	3	_testy
theta	8	34	1457	3	the_ta
ties	4	52	4831	3	ties__
vest	7	57	4360	3	_vest_
vestal	9	46	1557	3	_vestal
vestas	9	59	1668	3	_vestas
vests	8	53	2598	3	_vests
vies	7	52	3862	3	vies__
vilest	9	4	1684	3	vilest_
visa	7	63	2387	3	vi_s_a
vistas	9	45	1327	3	vi_stas
vita	7	58	2852	3	vi__ta
vitta	8	50	1517	3	vi_tta
vizsla	18	3	370	3	vizsla
weest	8	50	2677	3	weest_
west	7	57	4808	3	_west_
wests	8	57	2700	3	_wests
widest	10	45	1700	3	widest_
wisest	9	50	1644	3	wisest_
wisha	11	49	1085	3	wi_sha
wist	7	80	4929	3	wi_st_
wists	8	67	2852	3	wi_sts
wrest	8	49	2543	3	wrest_
wrests	9	53	1308	3	wrests
wriest	9	44	1971	3	wriest_
yenta	8	39	1704	3	_yenta
zest	13	60	3570	3	_zest_
zests	14	54	1974	3	_zests
zesty	17	65	1216	3	_zesty
zeta	13	51	2164	3	_ze_ta

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	112716	0.280	638182.1
2	DLD Change Limit	112716	405	6.703	16815.8
3	Display Results	405	405	0.126	3214.3
	(SQL Overall)	178691	405	7.109	25135.9