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

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

302 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
spancel	11	4	736	(None)
spancels	12	4	527	1	spancels
spaniel	9	4	892	1	spaniel
cancel	10	53	1668	2	_cancel
chancel	14	40	1177	2	chancel
panel	7	60	2362	2	_pan_el
parcel	10	39	1547	2	_parcel
pencel	10	38	1291	2	_pencel
seance	8	37	1669	2	seance_
seances	9	30	1534	2	seances
space	9	53	2567	2	spa_ce_
spaced	11	45	1725	2	spa_ced
spacer	10	49	1779	2	spa_cer
spaces	10	47	2263	2	spa_ces
spacey	13	62	1253	2	spa_cey
spanceled	14	4	369	2	spanceled
spandex	17	3	583	2	spandex
spandrel	11	4	406	2	spandrel
spangle	10	3	840	2	spangle
spaniels	10	4	596	2	spaniels
spanked	14	31	1173	2	spanked
spanker	13	36	1235	2	spanker
spanned	10	41	1122	2	spanned
spanner	9	43	1256	2	spanner
spence	10	38	1379	2	spence_
spencer	11	36	1097	2	spencer
spences	11	34	1392	2	spences
spinel	8	53	1733	2	spin_el
stance	8	43	1691	2	stance_
stances	9	37	1596	2	stances
angel	6	50	1956	3	__angel
apace	9	47	1838	3	apa_ce_
askance	13	4	592	3	askance_
cancels	11	41	1331	3	_cancels
cancer	10	42	2092	3	_cancer
cannel	8	42	1640	3	_cannel
carcel	10	50	1867	3	_carcel
chance	13	46	1709	3	chance_
chanced	15	41	1321	3	chanced
chancels	15	43	908	3	chancels
chancer	14	42	1563	3	chancer
chances	14	52	1809	3	chances
channel	12	39	1048	3	channel
dance	8	52	2313	3	_dance_
danced	10	53	1525	3	_danced
dancer	9	48	1761	3	_dancer
dances	9	51	2065	3	_dances
empanel	11	4	596	3	empan_el
espanol	9	4	378	3	espan_ol
evangel	11	3	430	3	evangel
fiance	11	3	1074	3	fiance_
fiancee	12	3	895	3	fiancee
fiances	12	3	1067	3	fiances
flannel	10	3	542	3	flannel
glance	9	43	1231	3	glance_
glanced	11	43	923	3	glanced
glancer	10	37	1007	3	glancer
glances	10	41	1314	3	glances
hance	10	54	2415	3	_hance_
hances	11	56	2128	3	_hances
hansel	9	52	1437	3	_hansel
impanel	11	3	709	3	impan_el
lance	7	51	2672	3	_lance_
lanced	9	37	1772	3	_lanced
lancer	8	43	1997	3	_lancer
lances	8	48	2410	3	_lances
lancet	8	42	2357	3	_lancet
mangel	9	40	1753	3	_mangel
mantel	8	43	1797	3	_mantel
marcel	10	37	1485	3	_marcel
nance	7	47	2184	3	_nance_
nances	8	36	1864	3	_nances
nuance	8	5	904	3	nuance_
nuanced	10	3	620	3	nuanced
nuances	9	3	852	3	nuances
pace	8	63	4577	3	_pa_ce_
paced	10	69	3168	3	_pa_ced
pacer	9	61	3161	3	_pa_cer
paces	9	67	4111	3	_pa_ces
pacey	12	67	2028	3	_pa_cey
panacea	11	3	778	3	_panacea
pander	9	37	2552	3	_pander
pane	6	49	5029	3	_pan_e_
paned	8	54	3718	3	_pan_ed
panels	8	47	1652	3	_pan_els
panes	7	61	4869	3	_pan_es
panful	11	7	974	3	_panful
panged	10	47	2233	3	_panged
pangen	9	41	1591	3	_pangen
panicle	11	12	998	3	_panicle
panier	8	44	2550	3	_panier
panne	7	66	2365	3	_panne_
panned	9	41	2343	3	_panned
panner	8	42	2476	3	_panner
pannes	8	55	2285	3	_pannes
panted	9	50	2482	3	_panted
panzer	17	42	1323	3	_panzer
parcels	11	37	1266	3	_parcels
parrel	8	45	1598	3	_parrel
pascal	10	8	1237	3	_pascal
passel	8	51	1700	3	_passel
pastel	8	59	1871	3	_pastel
pence	9	49	2445	3	_pence_
pencels	11	36	1005	3	_pencels
pencil	10	37	1297	3	_pencil
pincer	10	40	1917	3	_pincer
ponce	9	52	2251	3	_ponce_
ponced	11	43	1481	3	_ponced
ponces	10	47	2084	3	_ponces
prance	10	43	1857	3	prance_
pranced	12	37	1404	3	pranced
prancer	11	36	1338	3	prancer
prances	11	36	1877	3	prances
rance	7	50	2851	3	_rance_
rances	8	46	2544	3	_rances
repanel	9	3	996	3	repan_el
saice	7	54	2405	3	s_aice_
saices	8	42	2180	3	s_aices
samiel	8	3	1333	3	s_amiel
sancta	8	3	983	3	s_ancta
sandal	7	33	1728	3	s_andal
sanded	8	49	2061	3	s_anded
sander	7	48	2853	3	s_ander
sane	4	59	5434	3	s_an_e_
saned	6	56	3627	3	s_an_ed
sanely	9	31	1461	3	s_an_ely
saner	5	43	3432	3	s_an_er
sanes	5	56	4907	3	s_an_es
sanger	7	45	2456	3	s_anger
sanicle	9	12	1026	3	s_anicle
sanies	6	30	3195	3	s_anies
sansei	6	34	1190	3	s_ansei
santol	6	45	1524	3	s_antol
satchel	12	33	1030	3	s_atchel
sauce	7	51	2165	3	s_auce_
sauced	9	39	1330	3	s_auced
saucer	8	43	1410	3	s_aucer
sauces	8	49	1950	3	s_auces
saurel	6	5	1199	3	s_aurel
scalpel	11	37	771	3	scalpel
scandal	10	3	867	3	scandal
scanned	10	41	1089	3	scanned
scanner	9	44	1181	3	scanner
scanted	10	41	1439	3	scanted
scanter	9	42	1518	3	scanter
scarce	10	40	1363	3	scarce_
scarcely	15	3	431	3	scarcely
scarcer	11	39	1137	3	scarcer
sconce	10	47	1172	3	sconce_
sconced	12	35	917	3	sconced
sconces	11	38	1145	3	sconces
scrannel	10	4	403	3	scrannel
shanked	15	32	1212	3	shanked
shantey	13	42	1004	3	shantey
simnel	8	5	702	3	simn_el
since	7	50	2417	3	s_ince_
skanked	11	33	810	3	skanked
skanker	10	26	848	3	skanker
slander	8	40	1544	3	slander
slanged	9	41	1285	3	slanged
slanted	8	35	1474	3	slanted
sonance	9	3	1031	3	sonance_
sonances	10	3	1026	3	sonances
spacers	11	38	1387	3	spa_cers
spacial	11	3	876	3	spacial
spacier	11	40	1163	3	spacier
spackle	15	36	957	3	spa_ckle
spacy	12	54	1562	3	spa_c_y
spade	8	44	2332	3	spa_de_
spaded	10	38	1675	3	spa_ded
spader	9	43	1713	3	spa_der
spades	9	42	2258	3	spa_des
spadices	13	3	609	3	spadices
spae	6	50	3432	3	spa__e_
spaed	8	55	2227	3	spa__ed
spaes	7	60	2997	3	spa__es
spahee	11	3	1344	3	spa_hee
spahees	12	3	826	3	spahees
spail	7	49	2155	3	spa__il
spake	11	43	2274	3	spa_ke_
spale	7	49	2921	3	spa_le_
spales	8	47	2810	3	spa_les
spall	7	49	1930	3	spa__ll
spalled	10	31	1313	3	spalled
spaller	9	27	1347	3	spaller
spammed	14	34	852	3	spammed
spammer	13	34	1043	3	spammer
span	6	52	3466	3	span___
spanceling	15	4	394	3	spancel~~ing~~
spancelled	15	4	300	3	spancelled
spandrels	12	4	325	3	spandrels
spandril	11	4	409	3	spandril
spang	8	49	1973	3	span__g
spangled	12	3	615	3	spangled
spangles	11	3	889	3	spangles
spangly	13	3	647	3	spangly
spank	11	59	1957	3	span__k
spankers	14	36	986	3	spankers
spanks	12	45	1412	3	span_ks
spanless	10	24	736	3	spanless
spanners	10	37	1077	3	spanners
spans	7	45	2873	3	span__s
spansule	10	4	362	3	spansule
spare	7	51	3556	3	spa_re_
spared	9	54	2749	3	spa_red
sparely	12	34	1067	3	spa_rely
sparer	8	45	2496	3	spa_rer
spares	8	48	3455	3	spa_res
sparge	9	42	1605	3	sparge_
sparged	11	35	1276	3	sparged
sparger	10	36	1308	3	sparger
sparges	10	40	1634	3	sparges
sparked	14	35	1314	3	sparked
sparker	13	39	1436	3	sparker
sparkle	13	37	1021	3	sparkle
sparred	10	45	1286	3	sparred
sparse	8	45	1634	3	sparse_
sparsely	13	3	512	3	sparsely
sparser	9	43	1148	3	sparser
spasmed	12	29	699	3	spasmed
spate	7	47	3158	3	spa_te_
spates	8	50	2817	3	spa_tes
spathal	12	3	626	3	spathal
spathe	11	51	1569	3	spathe_
spathed	13	40	1318	3	spathed
spathes	12	51	1653	3	spathes
spatial	9	3	1032	3	spatial
spatted	10	40	1414	3	spatted
spatter	9	40	1652	3	spatter
spatzle	18	3	458	3	spatzle
spavie	11	36	1138	3	spavie_
spavies	12	30	1295	3	spavies
spaviet	12	30	1193	3	spaviet
spawned	13	31	680	3	spawned
spawner	12	34	736	3	spawner
spayed	12	42	1361	3	spa_yed
spazzes	17	3	526	3	spazzes
speaned	10	34	1152	3	spean_ed
specced	14	26	670	3	specced
speel	7	44	2076	3	sp__eel
spencers	12	26	919	3	spencers
spender	10	37	1369	3	spender
spense	8	39	1243	3	spense_
spenses	9	29	1357	3	spenses
spice	9	55	2881	3	sp_ice_
spiced	11	52	1831	3	sp_iced
spicer	10	47	1931	3	sp_icer
spices	10	43	2603	3	sp_ices
spicey	13	44	1423	3	sp_icey
spiegel	10	3	455	3	spiegel
spiel	7	46	2391	3	sp__iel
spinal	8	49	1531	3	spin_al
spindle	10	32	1009	3	spindle
spine	7	65	3442	3	spin_e_
spined	9	54	2394	3	spin_ed
spinels	9	45	1244	3	spin_els
spines	8	51	3203	3	spin_es
spinet	8	56	2975	3	spin_et
spinier	9	37	1516	3	spinier
spinner	9	39	1226	3	spinner
spinney	12	43	892	3	spinney
spinule	9	29	999	3	spinule
splice	10	49	1510	3	splice_
spliced	12	43	1059	3	spliced
splicer	11	47	1052	3	splicer
splices	11	39	1438	3	splices
spondee	10	3	1059	3	spondee
sponge	9	3	966	3	sponge_
sponged	11	3	795	3	sponged
sponger	10	3	852	3	sponger
sponges	10	3	1104	3	sponges
sponsal	9	4	634	3	sponsal
spruce	10	39	1087	3	spruce_
spruced	12	30	753	3	spruced
sprucely	15	4	312	3	sprucely
sprucer	11	31	768	3	sprucer
spruces	11	38	1050	3	spruces
spunked	14	30	778	3	spunked
stammel	11	60	753	3	stammel
stanch	11	38	1237	3	stanc_h
stanched	14	20	890	3	stanched
stancher	13	19	881	3	stancher
stanches	13	23	1279	3	stanches
stanchly	16	4	444	3	stanchly
standee	8	35	1451	3	standee
stander	8	43	1616	3	stander
stane	5	59	3300	3	stan_e_
staned	7	48	2464	3	stan_ed
stanes	6	49	3340	3	stan_es
stanged	9	41	1384	3	stanged
stanol	6	3	1072	3	stan_ol
stencil	9	4	689	3	stencil
subpanel	12	4	607	3	subpan_el
swanked	15	35	954	3	swanked
swanker	14	36	948	3	swanker
swanned	11	35	817	3	swanned
synced	12	26	696	3	s_ynced
trance	8	47	1876	3	trance_
tranced	10	44	1417	3	tranced
trances	9	39	1964	3	trances
usance	8	5	801	3	usance_
usances	9	6	737	3	usances

Search took 7 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.423	422437.4
2	DLD Change Limit	134027	302	6.186	21666.2
3	Display Results	302	302	0.110	2745.5
	(SQL Overall)	178691	302	6.719	26594.9