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

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

329 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
specced	14	26	670	(None)
specked	16	32	901	1	specked
peaced	11	58	1891	2	_peaced
peched	14	49	1534	2	_peched
pecked	15	50	1910	2	_pecked
sicced	11	48	965	2	s_icced
spaced	11	45	1725	2	sp_aced
speaned	10	34	1152	2	speaned
speared	10	43	1442	2	speared
specie	10	4	1222	2	specie_
species	11	3	1413	2	species
speckled	17	25	583	2	speckled
specter	11	31	1173	2	specter
speed	8	55	2662	2	spe__ed
speeded	11	33	1042	2	speeded
speeled	10	37	1245	2	speeled
speered	10	36	1481	2	speered
speiled	10	44	1212	2	speiled
speired	10	38	1110	2	speired
spelled	10	37	1474	2	spelled
spence	10	38	1379	2	spence_
spencer	11	36	1097	2	spencer
spences	11	34	1392	2	spences
spewed	12	55	1233	2	spe_wed
spiced	11	52	1831	2	sp_iced
spliced	12	43	1059	2	spliced
spruced	12	30	753	2	spruced
amerced	12	5	652	3	amerced
aspersed	11	42	830	3	aspersed
becked	15	54	1776	3	_becked
checked	19	37	1002	3	checked
coerced	12	3	858	3	coerced
decked	14	52	1762	3	_decked
deiced	10	42	1448	3	_deiced
deuced	10	41	1212	3	_deuced
eched	11	69	1922	3	__eched
ejected	17	29	765	3	ejected
elected	10	28	1261	3	elected
erected	10	32	1399	3	erected
expected	20	3	674	3	expected
fenced	12	44	1271	3	_fenced
flecked	17	35	807	3	flecked
fleeced	13	35	815	3	fleeced
flocced	15	36	548	3	flocced
gecked	14	69	1193	3	_gecked
inspected	14	4	540	3	inspected
kecked	12	51	1317	3	_kecked
leched	12	37	1600	3	_leched
leeched	13	36	950	3	leeched
necked	13	47	1507	3	_necked
opened	9	43	1186	3	ope_ned
paced	10	69	3168	3	_p_aced
packed	15	48	2260	3	_packed
peace	9	50	2608	3	_peace_
peaces	10	63	2408	3	_peaces
peached	15	43	1588	3	_peached
peaked	13	61	1740	3	_peaked
pealed	9	53	2281	3	_pealed
pecker	14	46	1536	3	_pecker
pecten	10	27	1110	3	_pecten
peed	7	62	3918	3	_pe__ed
peeked	13	43	1458	3	_peeked
peeled	9	41	1971	3	_peeled
peened	9	43	1816	3	_peened
peeped	11	39	1539	3	_peeped
peered	9	38	1949	3	_peered
peeved	12	41	1289	3	_peeved
pegged	11	48	1191	3	_pegged
peined	9	49	1884	3	_peined
peised	9	48	1768	3	_peised
pelted	9	46	1776	3	_pelted
pence	9	49	2445	3	_pence_
pencel	10	38	1292	3	_pencel
pended	10	38	1901	3	_pended
penned	9	42	1761	3	_penned
pepped	10	31	1340	3	_pepped
perched	15	47	1324	3	_perched
perked	13	46	1769	3	_perked
permed	11	52	1735	3	_permed
petted	9	41	2152	3	_petted
picked	15	44	2131	3	_picked
pieced	11	39	1210	3	_pieced
pierced	12	34	759	3	pierced
placed	11	43	1800	3	_placed
pocked	15	48	1898	3	_pocked
ponced	11	43	1481	3	_ponced
priced	11	50	1888	3	_priced
psyched	18	4	391	3	psyched
recce	9	5	1456	3	_recce_
recces	10	6	1491	3	_recces
recked	13	48	2180	3	_recked
respected	14	3	849	3	respected
sacked	13	55	2521	3	s_acked
sacred	9	49	1710	3	s_acred
sauced	9	39	1330	3	s_auced
scended	11	32	987	3	scended
scented	10	28	1188	3	scented
sconced	12	35	917	3	sconced
seabed	9	50	1769	3	s_eabed
sealed	7	43	2836	3	s_ealed
seamed	9	48	2388	3	s_eamed
seared	7	52	3284	3	s_eared
seated	7	51	3106	3	s_eated
secco	9	3	1242	3	s_ecc_o
seccos	10	3	992	3	s_eccos
secede	9	33	1199	3	s_e_cede
seceded	11	31	920	3	s_eceded
second	9	4	1115	3	s_econd
secret	8	3	2506	3	s_ecret
secund	9	3	710	3	s_ecund
secured	10	5	972	3	s_ecured
seduced	11	8	675	3	seduced
seed	5	55	4948	3	s_e__ed
seedbed	11	24	661	3	seedbed
seeded	8	45	2046	3	s_eeded
seeled	7	39	2209	3	s_eeled
seemed	9	51	1761	3	s_eemed
seeped	9	43	1752	3	s_eeped
seethed	11	34	1019	3	seethed
segued	8	3	851	3	s_egued
seined	7	40	2306	3	s_eined
seised	7	42	1812	3	s_eised
seized	16	43	1365	3	s_eized
selected	11	5	978	3	selected
selfed	10	3	1091	3	s_elfed
sended	8	51	2123	3	s_ended
sensed	7	39	1816	3	s_ensed
sepaled	10	5	1059	3	sepaled
sered	6	57	3729	3	s_e_red
serged	8	41	1877	3	s_erged
served	10	46	1681	3	s_erved
sewed	9	53	2516	3	s_e_wed
sexed	13	66	1854	3	s_e_xed
shacked	17	40	1539	3	shacked
sheafed	14	38	897	3	sheafed
sheared	11	45	1601	3	sheared
sheaved	14	34	1163	3	sheaved
shedded	13	41	906	3	shedded
sheened	11	35	1170	3	sheened
sheered	11	35	1546	3	sheered
sheeted	11	38	1304	3	sheeted
shelled	11	38	1509	3	shelled
shelved	14	37	993	3	shelved
shewed	13	47	1618	3	she_wed
shocked	17	46	1181	3	shocked
shucked	17	38	983	3	shucked
sicked	13	45	2440	3	s_icked
sieged	8	52	1271	3	sie_ged
sieved	10	46	1144	3	sie_ved
silenced	11	3	628	3	silenced
skeed	10	50	1898	3	ske__ed
skeined	12	3	677	3	skeined
skelped	14	3	520	3	skelped
sketched	18	3	539	3	sketched
skewed	14	56	1023	3	ske_wed
slacked	14	38	1545	3	slacked
sleaved	11	36	1113	3	sleaved
sledded	10	37	887	3	sledded
sledged	10	36	1033	3	sledged
sleeked	12	35	1088	3	sleeked
sleeted	8	31	1322	3	sleeted
sleeved	11	41	991	3	sleeved
slewed	10	48	1552	3	sle_wed
sliced	9	44	1631	3	s_liced
slicked	14	44	1384	3	slicked
sluiced	10	4	605	3	sluiced
smacked	16	37	1099	3	smacked
smeared	10	45	1062	3	smeared
smeeked	14	28	722	3	smeeked
smelled	10	35	1186	3	smelled
smelted	10	39	909	3	smelted
smerked	14	32	728	3	smerked
smocked	16	39	822	3	smocked
snacked	14	40	1311	3	snacked
sneaked	12	32	969	3	sneaked
sneaped	10	33	881	3	sneaped
snedded	10	37	739	3	snedded
sneered	8	31	1397	3	sneered
sneezed	17	28	779	3	sneezed
snelled	8	33	1305	3	snelled
snicked	14	38	1163	3	snicked
soccer	10	3	854	3	s_occer
socked	13	47	2150	3	s_ocked
solaced	10	29	1106	3	solaced
sourced	10	3	845	3	sourced
space	9	53	2567	3	sp_ace_
spacer	10	49	1779	3	sp_acer
spaces	10	47	2263	3	sp_aces
spacey	13	62	1253	3	sp_acey
spacier	11	40	1163	3	spacier
spackled	17	29	780	3	spackled
spaded	10	38	1675	3	sp_aded
spaed	8	55	2227	3	sp__aed
spalled	10	31	1313	3	spalled
spammed	14	34	852	3	spammed
spancel	11	4	736	3	spancel
spanked	14	31	1173	3	spanked
spanned	10	41	1122	3	spanned
spared	9	54	2749	3	sp_ared
sparged	11	35	1276	3	sparged
sparked	14	35	1314	3	sparked
sparred	10	45	1286	3	sparred
spasmed	12	29	699	3	spasmed
spathed	13	40	1318	3	spathed
spatted	10	40	1414	3	spatted
spawned	13	31	680	3	spawned
spayed	12	42	1361	3	sp_ayed
speaker	13	33	1121	3	speaker
spearer	9	39	1366	3	spearer
spec	8	58	2197	3	spe_c__
speccing	15	30	664	3	speccing
special	11	3	1030	3	special
speciated	14	20	754	3	speciated
specified	17	4	625	3	specified
specify	17	6	499	3	specify
specimen	14	4	442	3	specimen
speck	13	51	1565	3	spe_c_k
speckle	15	29	755	3	speckle
speckles	16	26	813	3	speckles
specks	14	43	1270	3	spe_cks
specs	9	69	1667	3	spe_c_s
spectacled	17	4	254	3	spectacled
spectated	14	23	659	3	spectated
specters	12	28	1106	3	specters
spectra	11	27	583	3	spectra
spectre	11	29	777	3	spectre
spectres	12	26	868	3	spectres
specula	11	18	742	3	specula
sped	7	60	3149	3	sp___ed
speech	13	4	756	3	speec_h
speeches	15	3	741	3	speeches
speeder	10	38	1107	3	speeder
speedo	9	40	1199	3	spe__edo
speeds	9	43	1605	3	spe__eds
speedy	12	184	1079	3	spe__edy
speel	7	44	2076	3	spe__el
speer	7	46	2390	3	spe__er
speise	8	46	1425	3	speise_
speises	9	38	1393	3	speises
speller	9	54	1515	3	speller
spelter	9	41	1370	3	spelter
spencers	12	26	919	3	spencers
spend	8	56	1933	3	spe__nd
spender	10	37	1369	3	spender
spense	8	39	1243	3	spense_
spenses	9	29	1357	3	spenses
spewer	11	51	1215	3	spe_wer
sphered	13	35	1231	3	sphered
spicae	10	43	1370	3	spicae_
spicated	13	30	990	3	spicated
spice	9	55	2881	3	sp_ice_
spicer	10	47	1931	3	sp_icer
spices	10	43	2603	3	sp_ices
spicey	13	44	1423	3	sp_icey
spicier	11	51	1246	3	spicier
spied	8	54	2771	3	sp__ied
spieled	10	48	1188	3	spieled
spiered	10	44	1246	3	spiered
spiffed	16	25	710	3	spiffed
spiked	13	49	1555	3	sp_iked
spiled	9	46	2199	3	sp_iled
spilled	10	36	1362	3	spilled
spined	9	54	2394	3	sp_ined
spired	9	49	2186	3	sp_ired
spirted	10	39	1307	3	spirted
spited	9	48	2044	3	sp_ited
spitted	10	39	1270	3	spitted
splayed	13	35	781	3	splayed
splice	10	49	1510	3	splice_
splicer	11	47	1052	3	splicer
splices	11	39	1438	3	splices
splined	10	50	1311	3	splined
spoiled	10	48	1135	3	spoiled
spoked	13	44	1389	3	sp_oked
sponged	11	3	795	3	sponged
spoofed	13	39	910	3	spoofed
spooked	14	45	1047	3	spooked
spooled	10	46	1352	3	spooled
spooned	10	34	1244	3	spooned
spoored	10	44	1129	3	spoored
spored	9	48	2179	3	sp_ored
sported	10	40	1543	3	sported
spotted	10	37	1314	3	spotted
spoused	10	34	965	3	spoused
spouted	10	34	1226	3	spouted
sprayed	13	39	890	3	sprayed
spruce	10	39	1087	3	spruce_
sprucer	11	31	768	3	sprucer
spruces	11	38	1050	3	spruces
spudded	12	23	590	3	spudded
spued	8	49	1847	3	sp__ued
spumed	11	47	1154	3	sp_umed
spunked	14	30	778	3	spunked
spurned	10	33	926	3	spurned
spurred	10	36	1062	3	spurred
spurted	10	31	1197	3	spurted
stacked	14	34	1612	3	stacked
steaded	9	28	1167	3	steaded
steamed	10	37	1214	3	steamed
steed	6	60	2494	3	ste__ed
steeked	12	40	1047	3	steeked
steeled	8	35	1322	3	steeled
steeped	10	34	1228	3	steeped
steered	8	36	1525	3	steered
steeved	11	36	1013	3	steeved
stemmed	12	27	815	3	stemmed
stepped	12	32	1005	3	stepped
stetted	8	26	1040	3	stetted
stewed	10	48	1424	3	ste_wed
sticked	14	41	1463	3	sticked
stocked	14	43	1287	3	stocked
stuccoed	13	5	285	3	stuccoed
succeed	12	3	598	3	succeed
sucked	13	41	2049	3	s_ucked
sueded	8	40	1463	3	sue_ded
supercede	14	7	848	3	supercede
supered	10	3	1612	3	supe_red
suspected	14	4	438	3	suspected
swacked	17	31	1052	3	swacked
sweated	11	34	1154	3	sweated
swelled	11	32	1170	3	swelled
swerved	14	5	570	3	swerved
synced	12	26	696	3	s_ynced
synched	16	27	721	3	synched
teched	12	40	1443	3	_teched
ticced	11	43	844	3	_ticced
tierced	10	34	705	3	tierced
upended	11	26	732	3	upended
wrecked	17	41	833	3	wrecked

Search took 10 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.420	425454.8
2	DLD Change Limit	134027	329	8.673	15453.4
3	Display Results	329	329	0.106	3103.8
	(SQL Overall)	178691	329	9.199	19425.0