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

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

306 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
spicery	14	49	901	(None)
spicer	10	47	1931	1	spicer_
spicers	11	38	1555	1	spicers
spicey	13	44	1423	1	spice_y
spidery	13	30	820	1	spidery
pinery	11	52	1429	2	_pinery
shivery	16	31	702	2	shivery
slicer	8	41	1760	2	slicer_
slicers	9	41	1492	2	slicers
snickery	17	29	554	2	snickery
sorcery	12	3	703	2	sorcery
spacer	10	49	1779	2	spacer_
spacers	11	38	1387	2	spacers
spacey	13	62	1253	2	space_y
sphery	14	31	888	2	sp_hery
spice	9	55	2881	2	spice__
spiced	11	52	1831	2	spice_d
spices	10	43	2603	2	spice_s
spicier	11	51	1246	2	spicier_
spicily	14	3	865	2	spicily
spicy	12	54	1771	2	spic__y
spider	9	45	1680	2	spider_
spiders	10	39	1441	2	spiders
spier	7	57	2803	2	spi_er_
spiers	8	44	2174	2	spi_ers
spiker	12	43	1566	2	spiker_
spikers	13	53	1199	2	spikers
spikey	15	54	1133	2	spike_y
spinnery	13	41	659	2	spinnery
spiry	10	50	1735	2	spi__ry
splicer	11	47	1052	2	splicer_
splicers	12	33	811	2	splicers
apery	10	65	1790	3	ap__ery
apiary	11	39	1038	3	api_ary
apices	10	49	1626	3	apice_s
aspirer	9	6	790	3	aspirer_
aspirers	10	6	649	3	aspirers
bribery	14	42	649	3	bribery
briery	11	45	1077	3	bri_ery
chicer	13	45	1360	3	chicer_
chicory	17	3	599	3	chicory
cicely	13	3	883	3	_cicely
cicero	10	4	850	3	_cicero
deicer	9	41	1441	3	deicer_
deicers	10	36	1273	3	deicers
dicer	8	54	2642	3	_dicer_
dicers	9	47	2074	3	_dicers
dicey	11	48	1933	3	_dice_y
epicarp	13	7	607	3	epicarp
epicene	11	4	859	3	epicene
epicure	11	3	682	3	epicure
epiderm	12	3	619	3	epiderm
epimer	10	10	915	3	epimer_
epimere	11	8	698	3	epimere
epimers	11	10	949	3	epimers
fiery	11	47	1479	3	_fi_ery
finery	12	45	1289	3	_finery
flickery	20	36	510	3	flickery
grocery	13	33	676	3	grocery
joinery	17	36	659	3	joinery
juicer	15	3	628	3	juicer_
juicers	16	3	615	3	juicers
livery	12	49	1090	3	_livery
mercery	14	39	762	3	mercery
misery	11	41	1354	3	_misery
nicely	11	3	949	3	_nicely
nicer	7	46	1829	3	_nicer_
nicety	11	3	843	3	_nicety
nitery	9	44	1217	3	_nitery
pacer	9	61	3161	3	_pacer_
pacers	10	51	2454	3	_pacers
pacey	12	67	2028	3	_pace_y
papery	13	48	1274	3	_papery
peery	10	57	1944	3	_p_eery
picara	10	3	1190	3	_picara
picaro	10	3	1132	3	_picaro
pice	8	46	4109	3	_pice__
picker	14	44	2217	3	_picker_
pickers	15	37	1809	3	_pickers
picky	16	54	1694	3	_pic_ky
piecer	10	52	1308	3	_piecer_
piecers	11	41	1225	3	_piecers
pier	6	60	3529	3	_pi_er_
piers	7	59	2633	3	_pi_ers
piety	10	58	1730	3	_pi_ety
piggery	14	26	619	3	_piggery
piker	11	56	2284	3	_piker_
pikers	12	47	1739	3	_pikers
pincer	10	40	1917	3	_pincer_
pincers	11	39	1650	3	_pincers
piney	10	57	2750	3	_pine_y
piper	9	65	2319	3	_piper_
pipers	10	43	1866	3	_pipers
piscary	14	3	742	3	_piscary
popery	13	45	1170	3	_popery
pricer	10	39	1829	3	pricer_
pricers	11	39	1506	3	pricers
pricey	13	44	1263	3	price_y
puckery	18	30	626	3	_puckery
quivery	22	26	546	3	quivery
ricer	7	47	2661	3	_ricer_
ricers	8	41	2099	3	_ricers
saice	7	54	2405	3	saice__
saices	8	42	2180	3	saice_s
sailer	6	35	2610	3	sailer_
sailers	7	38	2232	3	sailers
saucer	8	43	1410	3	saucer_
saucers	9	37	1213	3	saucers
scary	10	52	2259	3	s__cary
scenery	12	3	656	3	scenery
scry	9	60	1776	3	s__c_ry
sealery	10	40	1105	3	sealery
secern	8	10	1022	3	s_ecern
seiner	6	46	2248	3	seiner_
seiners	7	42	1927	3	seiners
seiser	6	53	1834	3	seiser_
seisers	7	38	1639	3	seisers
seizer	15	41	1457	3	seizer_
seizers	16	41	1250	3	seizers
shicker	16	39	1482	3	shicker_
shickers	17	30	1282	3	shickers
shier	8	54	2894	3	shi_er_
shiers	9	49	2175	3	shi_ers
shimmery	18	26	525	3	shimmery
shiner	9	38	2087	3	shiner_
shiners	10	40	1594	3	shiners
shinnery	14	30	567	3	shinnery
shiver	12	45	1737	3	shiver_
shivers	13	37	1483	3	shivers
showery	16	43	724	3	showery
sice	6	55	4559	3	s_ice__
sices	7	56	3727	3	s_ice_s
sicker	12	40	2390	3	s_icker_
sickerly	17	3	403	3	s_ickerly
sickly	15	31	1048	3	s_ickly
siker	9	53	2603	3	s_iker_
silvery	13	32	809	3	silvery
sincere	9	3	1055	3	sincere
sinewy	12	66	751	3	s_inewy
sipper	10	39	2099	3	sipper_
sippers	11	31	1775	3	sippers
siver	8	57	2861	3	s_iver_
sivers	9	53	2415	3	s_ivers
sizer	14	55	2181	3	s_izer_
sizers	15	52	1581	3	s_izers
skier	9	51	1959	3	ski_er_
skiers	10	47	1370	3	ski_ers
skiey	12	50	1289	3	ski_e_y
skittery	15	31	510	3	skittery
skiver	13	46	1210	3	skiver_
skivers	14	40	970	3	skivers
slavery	13	40	789	3	slavery
slice	7	49	2582	3	slice__
sliced	9	44	1631	3	slice_d
slices	8	40	2285	3	slice_s
slicker	13	33	1453	3	slicker_
slickers	14	31	1255	3	slickers
slickly	16	3	585	3	slickly
slider	7	39	1836	3	slider_
sliders	8	35	1522	3	sliders
slier	5	48	2724	3	sli_er_
slippery	15	27	586	3	slippery
slithery	14	35	670	3	slithery
sliver	9	41	1659	3	sliver_
slivers	10	41	1525	3	slivers
smiler	8	39	1668	3	smiler_
smilers	9	41	1385	3	smilers
smiley	11	40	1230	3	smile_y
smiter	8	36	1641	3	smiter_
smiters	9	34	1436	3	smiters
smithery	16	32	570	3	smithery
sneery	9	36	1041	3	s_neery
snicker	13	30	1267	3	snicker_
snickers	14	30	1096	3	snickers
snidely	11	3	681	3	snidely
snider	7	44	1391	3	snider_
sniper	8	44	1364	3	sniper_
snipers	9	33	1177	3	snipers
soccer	10	3	854	3	soccer_
soccers	11	3	839	3	soccers
society	12	3	608	3	society
space	9	53	2567	3	space__
spaced	11	45	1725	3	space_d
spaces	10	47	2263	3	space_s
spacier	11	40	1163	3	spacier_
spacy	12	54	1562	3	spac__y
spader	9	43	1713	3	spader_
spaders	10	42	1447	3	spaders
sparely	12	34	1067	3	sparely
sparer	8	45	2496	3	sparer_
sparers	9	45	1961	3	sparers
sparry	11	51	1130	3	sp_arry
specify	17	6	499	3	specify
specter	11	31	1173	3	specter_
specters	12	28	1106	3	specters
spectra	11	27	583	3	spectra
spectre	11	29	777	3	spectre
speedy	12	184	1079	3	sp_eedy
speer	7	46	2390	3	sp_eer_
speers	8	50	1995	3	sp_eers
spencer	11	36	1097	3	spencer_
spencers	12	26	919	3	spencers
sperm	9	32	1602	3	sp__erm
spewer	11	51	1215	3	spewer_
spewers	12	42	1066	3	spewers
sphere	11	33	1366	3	sp_here
spic	8	52	2743	3	spic___
spica	9	47	1794	3	spic__a
spicae	10	43	1370	3	spic_ae
spicas	10	47	1582	3	spic_as
spicate	11	32	1419	3	spicate
spiceries	13	4	931	3	spiceries
spiciest	12	27	1160	3	spiciest
spicing	12	39	1453	3	spicing
spick	13	45	1907	3	spic__k
spicks	14	48	1499	3	spic_ks
spics	9	41	2324	3	spic__s
spicula	11	25	929	3	spicula
spicule	11	26	993	3	spicule
spied	8	54	2771	3	spi_e_d
spiel	7	46	2391	3	spi_e_l
spieler	9	31	1123	3	spieler_
spielers	10	31	965	3	spielers
spiels	8	53	1795	3	spi_els
spiered	10	44	1246	3	spi_ered
spies	7	60	3762	3	spi_e_s
spiffy	17	32	622	3	spi_ffy
spike	11	49	2284	3	spike__
spiked	13	49	1555	3	spike_d
spikes	12	45	2071	3	spike_s
spikier	13	36	998	3	spikier_
spikily	16	3	587	3	spikily
spiky	14	60	1411	3	spi__ky
spile	7	52	3008	3	spile__
spiled	9	46	2199	3	spile_d
spiles	8	42	2791	3	spile_s
spiller	9	29	1433	3	spiller_
spillers	10	33	1170	3	spillers
spindly	13	25	738	3	spindly
spine	7	65	3442	3	spine__
spined	9	54	2394	3	spine_d
spinel	8	53	1733	3	spine_l
spinels	9	45	1244	3	spinels
spines	8	51	3203	3	spine_s
spinet	8	56	2975	3	spine_t
spinets	9	47	1481	3	spinets
spinier	9	37	1516	3	spinier_
spinner	9	39	1226	3	spinner_
spinners	10	38	1086	3	spinners
spinney	12	43	892	3	spinney
spinny	11	45	1018	3	spi_nny
spinor	8	3	994	3	spinor_
spinors	9	3	942	3	spinors
spiny	10	49	2130	3	spi__ny
spire	7	58	2869	3	spi__re
spirea	8	40	1563	3	spire_a
spireas	9	44	1251	3	spireas
spired	9	49	2186	3	spire_d
spirem	10	42	1416	3	spire_m
spireme	11	47	836	3	spireme
spirems	11	49	956	3	spirems
spires	8	46	2811	3	spire_s
spirier	9	32	1407	3	spirier_
spirt	7	50	3295	3	spi__rt
spite	7	54	3066	3	spite__
spited	9	48	2044	3	spite_d
spites	8	41	2733	3	spite_s
spitter	9	40	1518	3	spitter_
spitters	10	41	1338	3	spitters
spivvy	17	3	321	3	spi_vvy
spleeny	12	3	456	3	spleeny
splice	10	49	1510	3	splice__
spliced	12	43	1059	3	splice_d
splices	11	39	1438	3	splice_s
splintery	14	26	479	3	splintery
spoiler	9	33	1068	3	spoiler_
spoilers	10	23	863	3	spoilers
spoofery	16	35	431	3	spoofery
spookery	17	26	414	3	spookery
sprier	8	41	1906	3	sprier_
sprucely	15	4	312	3	sprucely
sprucer	11	31	768	3	sprucer_
spry	9	68	1912	3	sp___ry
spryer	11	41	853	3	spryer_
spurrey	12	30	781	3	spurrey
spurry	11	42	912	3	sp_urry
sputtery	13	36	647	3	sputtery
sticker	13	35	1588	3	sticker_
stickers	14	29	1303	3	stickers
sticky	15	47	1134	3	stic_ky
stitchery	17	17	407	3	stitchery
stiver	9	39	1573	3	stiver_
stivers	10	36	1354	3	stivers
succory	14	4	464	3	succory
suiter	6	41	2181	3	suiter_
suiters	7	36	1888	3	suiters
summery	14	32	941	3	summery
supinely	13	7	629	3	supinely
surgery	11	31	921	3	surgery
tracery	12	39	979	3	tracery
trickery	17	29	734	3	trickery
viceroy	15	4	493	3	_viceroy
vinery	12	49	1260	3	_vinery
voicer	11	39	1054	3	voicer_
voicers	12	34	899	3	voicers
winery	12	50	1428	3	_winery

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	134027	0.483	369960.7
2	DLD Change Limit	134027	306	6.690	20033.9
3	Display Results	306	306	0.093	3290.3
	(SQL Overall)	178691	306	7.266	24592.8