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

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

287 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
speltz	17	40	1012	(None)
spelt	7	54	3019	1	spelt_
spelts	8	46	1464	1	spelts
pelt	6	76	5108	2	_pelt_
pelts	7	61	2881	2	_pelts
shelta	9	31	1179	2	shelta
shelty	12	40	1155	2	shelty
smelt	7	47	2678	2	smelt_
smelts	8	54	1277	2	smelts
spell	7	50	2030	2	spel_l
spells	8	46	1768	2	spells
spelter	9	41	1370	2	spelter
speltzes	19	4	400	2	speltzes
spent	7	55	3283	2	spent_
spilt	7	55	3222	2	spilt_
spilth	11	46	973	2	spilth
spitz	16	60	1797	2	sp_itz
spritz	17	47	1442	2	spritz
svelte	9	31	975	2	svelte
aspect	10	6	1282	3	aspect_
aspects	11	4	674	3	aspects
belt	6	57	5403	3	_belt_
belts	7	59	3116	3	_belts
celt	6	56	4671	3	_celt_
celts	7	53	2578	3	_celts
delt	5	78	5527	3	_delt_
delta	6	61	1777	3	_delta
delts	6	57	3179	3	_delts
dwelt	9	43	1652	3	dwelt_
felt	7	51	4693	3	_felt_
felts	8	53	2454	3	_felts
gelt	5	64	4801	3	_gelt_
gelts	6	59	2461	3	_gelts
hertz	17	49	1904	3	_hertz
kelt	8	53	4319	3	_kelt_
kelts	9	52	2263	3	_kelts
knelt	9	46	1768	3	knelt_
melt	6	57	5289	3	_melt_
melts	7	49	3010	3	_melts
melty	10	49	1836	3	_melty
nertz	14	51	1745	3	_nertz
peat	6	59	6793	3	_peat_
peats	7	61	4019	3	_peats
peaty	10	57	2569	3	_peaty
pele	6	55	3955	3	_pel_e
peles	7	57	3808	3	_peles
pelf	9	70	3145	3	_pel_f
pelfs	10	50	1629	3	_pelfs
pelite	8	43	2300	3	_pelite
pelon	7	44	2321	3	_pelon
pelota	8	6	1283	3	_pelota
pelted	9	46	1776	3	_pelted
pelter	8	33	2162	3	_pelter
peltry	11	28	865	3	_peltry
pent	6	65	5907	3	_pent_
pert	6	67	5932	3	_pert_
pest	6	55	5529	3	_pest_
pesto	7	57	2372	3	_pesto
pests	7	59	3327	3	_pests
pesty	10	64	2171	3	_pesty
pet	5	64	7730	3	_pe_t_
pets	6	62	4833	3	_pe_ts
petti	7	51	1945	3	_petti
petto	7	60	2104	3	_petto
petty	10	53	2029	3	_petty
plotz	16	46	1700	3	_plotz
putz	15	83	2632	3	_p_utz
respelt	9	3	1214	3	respelt_
salt	4	57	5852	3	s_alt_
salts	5	54	3188	3	s_alts
salty	8	55	2438	3	s_alty
sault	5	58	3496	3	sault_
saults	6	58	1617	3	saults
scent	7	58	3162	3	scent_
scents	8	53	1702	3	scents
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
seel	4	50	4298	3	seel__
seeled	7	39	2209	3	seeled
seels	5	56	3282	3	seel_s
seely	8	45	2263	3	seel_y
sel	3	82	5332	3	s_el__
selah	8	3	1961	3	s_elah
self	7	51	3829	3	s_el_f
selfs	8	52	2024	3	s_elfs
sell	4	58	4061	3	s_el_l
selle	5	44	2831	3	s_elle
sells	5	51	3443	3	s_ells
sels	4	63	4598	3	s_el_s
seltzer	16	3	521	3	s_eltzer
selva	8	30	1427	3	s_elva
sent	4	69	6301	3	s_ent_
sente	5	64	3288	3	s_ente
senti	5	62	2670	3	s_enti
sept	6	58	4436	3	s_ept_
septa	7	55	1808	3	s_epta
septs	7	54	2060	3	s_epts
set	3	66	8125	3	s_e_t_
seta	4	56	3731	3	s_e_ta
sets	4	55	4950	3	s_e_ts
sett	4	59	4905	3	s_e_tt
setts	5	51	2432	3	s_etts
sext	11	73	3809	3	s_ext_
sexto	12	44	1545	3	s_exto
sexts	12	51	1838	3	s_exts
shalt	8	55	3449	3	shalt_
sheath	12	4	1289	3	sheath
sheet	8	48	3696	3	sheet_
sheets	9	39	1850	3	sheets
shegetz	20	4	427	3	shegetz
shelf	11	52	2111	3	shel_f
shell	8	44	2412	3	shel_l
shells	9	43	1952	3	shells
shelly	12	44	1447	3	shelly
sheltas	10	27	967	3	sheltas
shelter	10	32	1496	3	shelter
sheltie	10	10	991	3	sheltie
shelve	12	40	1276	3	shelve
shelvy	15	37	786	3	shelvy
shent	8	59	3350	3	shent_
shmaltz	21	4	465	3	shmaltz
siesta	6	3	950	3	siesta
silt	4	65	5819	3	s_ilt_
silts	5	53	3082	3	s_ilts
silty	8	47	2163	3	s_ilty
skeet	9	54	2918	3	skeet_
skeets	10	45	1325	3	skeets
skell	9	49	1583	3	skel_l
skells	10	50	1378	3	skells
skelm	11	42	1129	3	skel_m
skelms	12	36	802	3	skelms
skelp	11	42	1142	3	skel_p
skelps	12	40	792	3	skelps
skelter	11	36	1000	3	skelter
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
smalt	7	47	2933	3	smalt_
smalti	8	41	1119	3	smalti
smalto	8	44	1028	3	smalto
smalts	8	52	1489	3	smalts
smell	7	49	1623	3	smel_l
smells	8	39	1474	3	smells
smelly	11	41	1036	3	smelly
smelted	10	39	909	3	smelted
smelter	9	33	1191	3	smelter
smolt	7	48	2416	3	smolt_
smolts	8	44	1188	3	smolts
snell	5	45	1730	3	snel_l
snells	6	46	1420	3	snells
spait	7	56	3160	3	spait_
spaits	8	50	1747	3	spaits
spale	7	49	2921	3	spal_e
spales	8	47	2810	3	spales
spall	7	49	1930	3	spal_l
spalls	8	42	1734	3	spalls
spat	6	65	4852	3	sp_at_
spate	7	47	3158	3	sp_ate
spats	7	50	3138	3	sp_ats
spaz	15	56	2616	3	sp__az
spazz	15	58	1113	3	sp_azz
speak	11	46	1867	3	spe_ak
speaks	12	51	1458	3	speaks
spean	7	46	2051	3	spe_an
speans	8	54	1714	3	speans
spear	7	58	2106	3	spe_ar
spears	8	40	1947	3	spears
spec	8	58	2197	3	spe__c
specie	10	4	1222	3	specie
speck	13	51	1565	3	spe_ck
specks	14	43	1270	3	specks
specs	9	69	1667	3	spe_cs
specter	11	31	1173	3	specter
spectra	11	27	583	3	spectra
spectre	11	29	777	3	spectre
sped	7	60	3149	3	spe__d
speech	13	4	756	3	speech
speed	8	55	2662	3	spe_ed
speedo	9	40	1199	3	speedo
speeds	9	43	1605	3	speeds
speedy	12	184	1079	3	speedy
speel	7	44	2076	3	spe_el
speeled	10	37	1245	3	speeled
speels	8	51	1639	3	speels
speer	7	46	2390	3	spe_er
speers	8	50	1995	3	speers
speil	7	56	1864	3	spe_il
speiled	10	44	1212	3	speiled
speils	8	41	1622	3	speils
speir	7	53	1536	3	spe_ir
speirs	8	50	1323	3	speirs
speise	8	46	1425	3	speise
speiss	8	43	1164	3	speiss
spelean	9	3	712	3	spelean
spelled	10	37	1474	3	spelled
speller	9	54	1515	3	speller
spelters	10	39	1224	3	spelters
spelunk	13	4	320	3	spelunk
spence	10	38	1379	3	spence
spend	8	56	1933	3	spe_nd
spends	9	47	1447	3	spends
spendy	12	49	1114	3	spendy
spense	8	39	1243	3	spense
sperm	9	32	1602	3	spe_rm
sperms	10	25	1260	3	sperms
spew	9	54	2187	3	spe__w
spewed	12	55	1233	3	spewed
spewer	11	51	1215	3	spewer
spews	10	50	1592	3	spe_ws
spiel	7	46	2391	3	spiel__
spieled	10	48	1188	3	spieled
spieler	9	31	1123	3	spieler
spiels	8	53	1795	3	spiel_s
spile	7	52	3008	3	spil_e
spiled	9	46	2199	3	spiled
spiles	8	42	2791	3	spiles
spill	7	48	2116	3	spil_l
spills	8	47	1746	3	spills
spilths	12	35	602	3	spilths
spinto	8	4	1066	3	spinto
spirt	7	50	3295	3	spirt_
spirts	8	53	1713	3	spirts
spit	6	55	4508	3	sp_it_
spite	7	54	3066	3	sp_ite
spits	7	44	2955	3	sp_its
splat	7	61	2934	3	sp_lat
splats	8	48	1730	3	splats
splay	10	58	1604	3	sp_lay
spleen	8	3	1026	3	spleen
splent	8	47	2019	3	splent
splents	9	39	1213	3	splents
split	7	57	2901	3	sp_lit
splits	8	54	1641	3	splits
spoilt	8	50	1659	3	spoilt_
sport	7	59	3598	3	sport_
sports	8	46	1918	3	sports
sporty	11	51	1249	3	sporty
spot	6	55	4069	3	sp_ot_
spots	7	44	2411	3	sp_ots
spotty	11	44	858	3	spotty
spout	7	50	2963	3	spout_
spouts	8	51	1511	3	spouts
sprat	7	66	3597	3	sprat_
sprats	8	58	1993	3	sprats
sprent	8	45	2238	3	sprent_
sprit	7	67	3640	3	sprit_
sprite	8	44	2177	3	sprite
sprits	8	51	2253	3	sprits
spurt	7	72	2798	3	spurt_
spurts	8	48	1497	3	spurts
sputa	7	46	1296	3	sp_uta
stealth	10	9	645	3	stealth
stela	5	40	1904	3	stel_a
stelae	6	37	1648	3	stelae
stelai	6	39	1256	3	stelai
stelar	6	40	1386	3	stelar
stele	5	50	2684	3	stel_e
steles	6	37	2566	3	steles
stelic	8	3	1308	3	stelic
stella	6	36	1297	3	stella
stent	5	56	3451	3	stent_
stents	6	50	1945	3	stents
stet	4	59	4732	3	ste_t_
stets	5	54	2391	3	ste_ts
stilt	5	48	3198	3	stilt_
stilts	6	79	1531	3	stilts
suet	4	67	5482	3	sue_t_
suets	5	51	2610	3	sue_ts
suety	8	53	1849	3	sue_ty
svelter	10	35	967	3	svelter
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
swell	8	48	1598	3	swel_l
swells	9	39	1398	3	swells
swelter	10	37	1117	3	swelter
sweltry	13	3	341	3	sweltry
swept	10	57	2060	3	swept_
waltz	17	6	1547	3	_waltz
welt	7	55	4786	3	_welt_
welts	8	52	2519	3	_welts

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.373	479064.3
2	DLD Change Limit	112716	287	4.860	23192.6
3	Display Results	287	287	0.096	2989.6
	(SQL Overall)	178691	287	5.329	33531.8