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

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

337 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
secpars	11	3	841	(None)
secpar	10	3	792	1	secpar_
escars	8	39	1313	2	esc_ars
eschars	12	3	717	2	eschars
nectars	9	3	846	2	nectars
scars	7	54	3353	2	s_c_ars
sears	5	47	4491	2	se__ars
sectary	12	3	827	2	sectary
sectors	9	31	1645	2	sectors
seculars	10	21	939	2	seculars
seggars	9	37	778	2	seggars
sepals	8	52	1737	2	se_pals
sewars	9	40	1863	2	se_wars
spars	7	54	3154	2	s__pars
bears	7	57	3904	3	be__ars
becaps	12	38	1140	3	bec_aps
becharm	16	3	684	3	becharm
becharms	17	4	534	3	becharms
bedpans	12	3	717	3	bedpans
beepers	11	36	1238	3	beepers
beggars	11	37	822	3	beggars
bezoars	18	3	679	3	bezoars
cars	6	73	6476	3	__c_ars
cedars	9	33	1283	3	ce_dars
cellars	9	37	1369	3	cellars
chars	10	59	3664	3	__chars
czars	16	48	1291	3	__czars
dears	6	57	3688	3	de__ars
debars	9	42	1804	3	de_bars
decafs	12	40	1088	3	dec_afs
decals	9	37	1771	3	dec_als
decare	9	39	1915	3	dec_are
decares	10	28	1853	3	dec_ares
decays	12	46	1291	3	dec_ays
deciare	10	7	1066	3	deciare
deciares	11	5	1063	3	deciares
deckers	14	44	1383	3	deckers
declare	10	4	1122	3	declare
declares	11	6	1131	3	declares
declass	10	3	873	3	declass
declaws	13	3	625	3	declaws
decors	9	40	1777	3	dec_ors
denars	7	46	2143	3	de_nars
deodars	9	3	762	3	deodars
depart	9	47	2056	3	de_part
departs	10	43	1068	3	de_parts
despairs	11	4	494	3	despairs
dewars	10	51	1707	3	de_wars
ears	4	63	5659	3	_e__ars
echard	12	4	922	3	_echard
echards	13	3	796	3	_echards
eclairs	9	3	596	3	_eclairs
eclats	8	3	1303	3	_eclats
eggars	8	39	897	3	_eggars
embars	10	38	1288	3	_embars
escapers	12	33	741	3	escapers
escapes	11	38	1167	3	escapes
escar	7	40	1199	3	esc_ar_
escarp	10	44	900	3	esc_arp
escarps	11	39	737	3	esc_arps
eschar	11	3	652	3	eschar_
escolars	10	4	534	3	escolars
eskars	10	35	759	3	_eskars
expats	15	3	768	3	_expats
fears	8	48	2939	3	fe__ars
fecials	12	35	1033	3	fecials
felspars	13	4	316	3	felspars
feuars	9	3	865	3	fe_uars
gears	6	46	2869	3	ge__ars
heapers	12	36	1667	3	heapers
hears	8	67	3737	3	he__ars
hectare	12	3	846	3	hectare
hectares	13	3	885	3	hectares
hectors	12	35	1326	3	hectors
helpers	12	33	1185	3	helpers
hepcats	14	3	647	3	hepcats
jeepers	16	39	919	3	jeepers
jeopard	17	4	411	3	jeopard
jeopards	18	4	368	3	jeopards
kebars	12	41	1249	3	ke_bars
keepers	13	34	1098	3	keepers
keypads	17	4	334	3	keypads
keypals	16	3	435	3	keypals
leapers	9	37	1666	3	leapers
lears	5	59	3873	3	le__ars
lechers	12	33	1396	3	lechers
lectors	9	34	1576	3	lectors
lekvars	14	3	269	3	lekvars
leopard	10	4	529	3	leopard
leopards	11	4	475	3	leopards
lepers	8	48	1732	3	le_pers
meccas	12	3	949	3	mecca_s
medlars	10	25	944	3	medlars
nears	5	55	2942	3	ne__ars
neckers	13	42	1046	3	neckers
nectar	8	3	885	3	nectar_
nectary	12	4	622	3	nectary
pars	6	75	6079	3	___pars
pears	7	51	3861	3	pe__ars
pecans	10	15	1583	3	pec_ans
peccary	16	3	628	3	peccary
pechans	14	8	1050	3	pechans
peckers	15	33	1267	3	peckers
pedlars	10	32	1021	3	pedlars
peepers	11	37	1367	3	peepers
peppers	10	33	1144	3	peppers
reapers	9	35	2045	3	reapers
rears	5	47	3965	3	re__ars
rebars	8	40	1983	3	re_bars
recaps	10	36	1573	3	rec_aps
rechart	12	3	1432	3	rechart
recharts	13	3	766	3	recharts
reclads	10	4	999	3	reclads
recoals	9	42	1462	3	recoals
recoats	9	26	1664	3	recoats
rectors	9	35	2052	3	rectors
recurs	8	33	1580	3	rec_urs
redears	8	28	1445	3	redears
regears	8	30	1246	3	regears
rehears	10	33	1277	3	rehears
repairs	9	31	997	3	re_pairs
repark	12	35	1171	3	re_park
reparks	13	24	951	3	re_parks
repass	8	41	1470	3	re_pass
repays	11	38	1397	3	re_pays
retears	7	28	1492	3	retears
rewears	10	29	1104	3	rewears
sackers	13	38	2022	3	sackers
sacrals	9	33	1179	3	sacrals
saggars	9	36	1068	3	saggars
salpas	8	51	1692	3	salpa_s
sambars	11	51	1384	3	sambars
sampans	11	24	1100	3	sampans
sangars	8	31	1625	3	sangars
sansars	7	33	1391	3	sansars
sapors	8	41	1881	3	s_apors
sappers	11	35	1890	3	sappers
sardars	8	31	1290	3	sardars
sarsars	7	35	1214	3	sarsars
scabs	9	48	1864	3	s_c_abs
scads	8	54	1996	3	s_c_ads
scags	8	55	2097	3	s_c_ags
scalars	9	37	1190	3	scalars
scams	9	44	2397	3	s_c_ams
scans	7	46	2510	3	s_c_ans
scapes	10	51	2226	3	s_capes
scar	6	64	3420	3	s_c_ar_
scare	7	53	3446	3	s_c_are
scares	8	50	3300	3	s_c_ares
scarf	10	54	2714	3	s_c_arf
scarfs	11	47	1468	3	s_c_arfs
scarp	9	57	2410	3	s_c_arp
scarps	10	47	1860	3	s_c_arps
scart	7	61	3977	3	s_c_art
scarts	8	53	2149	3	s_c_arts
scary	10	52	2259	3	s_c_ary
scats	7	59	3060	3	s_c_ats
scaurs	8	55	1205	3	s_caurs
scenas	8	41	1470	3	scena_s
scepters	12	3	779	3	scepters
sceptre	11	3	505	3	sceptre
sceptres	12	4	499	3	sceptres
schavs	14	3	649	3	s_chavs
scours	8	49	1359	3	s_cours
scrags	9	57	1380	3	s_crags
scrams	10	52	1662	3	s_crams
scraps	10	60	1724	3	s_craps
seabags	10	3	748	3	seabags
sealers	7	43	2355	3	sealers
seals	5	48	3969	3	se__als
seamark	13	3	672	3	seamark
seamarks	14	4	530	3	seamarks
seamers	9	47	1943	3	seamers
seams	7	57	3166	3	se__ams
seaport	9	3	1560	3	seaport
seaports	10	3	846	3	seaports
sear	4	73	5384	3	se__ar_
seas	4	57	5527	3	se__a_s
seaters	7	40	2894	3	seaters
seats	5	48	4434	3	se__ats
seawans	10	37	994	3	seawans
seaward	11	4	818	3	seaward
seawards	12	3	720	3	seawards
seaware	10	4	963	3	seaware
seawares	11	3	933	3	seawares
seaways	13	30	751	3	seaways
secant	8	40	2329	3	sec_ant
secants	9	34	1389	3	secants
seccos	10	3	992	3	sec_cos
seceders	11	27	796	3	seceders
secedes	10	37	1198	3	secedes
secern	8	10	1022	3	sec_ern
secerns	9	8	773	3	secerns
seconals	10	4	705	3	seconals
seconds	10	3	828	3	seconds
secrets	9	3	1177	3	secrets
secs	6	50	3389	3	sec___s
sectaries	11	3	1224	3	sectaries
sector	8	34	1593	3	sector_
sects	7	56	2289	3	sec__ts
secular	9	22	1153	3	secular_
secure	8	5	1353	3	sec_ure
securers	10	5	715	3	securers
secures	9	6	1316	3	secures
sedans	7	48	1609	3	se_dans
seders	7	44	2028	3	se_ders
seeders	8	30	1711	3	seeders
seekers	11	37	1233	3	seekers
seemers	9	38	1433	3	seemers
seepage	10	3	754	3	seepage
seepages	11	3	728	3	seepages
seeps	7	48	2875	3	seep__s
seers	5	51	3638	3	se__ers
seesaws	10	3	470	3	seesaws
seggar	8	35	781	3	seggar_
seiners	7	42	1927	3	seiners
seisers	7	38	1639	3	seisers
seisors	7	32	1284	3	seisors
seitans	7	33	1230	3	seitans
seizers	16	41	1250	3	seizers
seizors	16	32	901	3	seizors
selahs	9	3	1321	3	se_lahs
sellers	7	37	2131	3	sellers
selvas	9	38	1291	3	selva_s
seminars	10	7	904	3	seminars
sempre	10	27	1009	3	semp_re
senary	9	37	1607	3	se_nary
sendals	8	19	1226	3	sendals
senders	8	30	2235	3	senders
senhors	10	35	1213	3	senhors
seniors	7	34	1362	3	seniors
sennas	6	42	1423	3	senna_s
senoras	7	27	1495	3	senoras
senors	6	36	2079	3	se_nors
sensors	7	35	1464	3	sensors
sepal	7	77	2300	3	se_pa_l
sepias	8	36	1610	3	se_pias
sepoys	11	3	847	3	se_poys
sepses	8	45	1588	3	se_pses
sepsis	8	30	1129	3	se_psis
septs	7	54	2060	3	se_p_ts
seracs	8	44	1857	3	se_racs
serais	6	43	2613	3	se_rais
serapes	9	52	1810	3	serapes
seraphs	12	40	809	3	seraphs
serdabs	10	3	532	3	serdabs
sergers	8	38	1563	3	sergers
serials	7	39	1974	3	serials
serovars	11	4	523	3	serovars
sers	4	57	4665	3	se___rs
servals	10	34	1074	3	servals
servers	10	32	1483	3	servers
setters	7	38	2206	3	setters
severs	9	41	2112	3	se_vers
sewans	9	52	1590	3	se_wans
sewar	8	54	2110	3	se_war_
sewers	9	47	1972	3	se_wers
sexpots	16	3	629	3	sexpots
sextans	14	34	926	3	sextans
shapers	12	40	1689	3	shapers
shears	9	38	2090	3	s_hears
sherpas	12	3	809	3	sherpa_s
shikars	14	3	618	3	shikars
shmears	12	7	707	3	shmears
shofars	13	3	583	3	shofars
shophars	16	4	635	3	shophars
sidecars	11	4	590	3	sidec_ars
simars	8	49	1693	3	s_imars
simpers	11	30	1412	3	simpers
sippers	11	31	1775	3	sippers
sirdars	8	22	821	3	sirdars
sitars	6	54	1759	3	s_itars
sizars	15	48	1262	3	s_izars
sleepers	10	31	1011	3	sleepers
slopers	9	42	1309	3	slopers
smears	8	47	1443	3	s_mears
snipers	9	33	1177	3	snipers
soapers	9	37	1592	3	soapers
soars	5	47	3251	3	s__oars
socas	7	40	2618	3	soc_a_s
soccers	11	3	839	3	soccers
socials	9	9	963	3	socials
sofars	9	47	1278	3	s_ofars
sonars	6	48	1897	3	s_onars
sopors	8	52	1520	3	s_opors
soucars	9	3	842	3	soucars
sowars	9	43	1801	3	s_owars
sowcars	12	3	601	3	sowcars
spaes	7	60	2997	3	s__paes
spams	9	49	2219	3	s__pams
spans	7	45	2873	3	s__pans
spar	6	54	3330	3	s__par_
spare	7	51	3556	3	s__pare
spares	8	48	3455	3	s__pares
spark	11	49	2089	3	s__park
sparks	12	46	1636	3	s__parks
sparse	8	45	1634	3	s__parse
spas	6	70	3672	3	s__pa_s
spats	7	50	3138	3	s__pats
spays	10	55	2051	3	s__pays
spears	8	40	1947	3	s_pears
specials	12	3	803	3	specials
specters	12	28	1106	3	specters
spurs	7	46	2152	3	s__purs
stars	5	58	3657	3	s__tars
steepers	10	30	1137	3	steepers
steppers	12	28	928	3	steppers
stewpans	13	4	371	3	stewpans
stopers	9	42	1737	3	stopers
stupas	8	39	1088	3	stupa_s
stupors	9	3	588	3	stupors
subpar	10	4	866	3	subpar_
subpart	11	3	1112	3	subpart
subparts	12	4	690	3	subparts
succahs	14	3	532	3	succahs
succors	11	3	741	3	succors
suckers	13	37	1762	3	suckers
sugars	7	3	1242	3	s_ugars
supers	8	46	2240	3	s_upers
suppers	11	33	1470	3	suppers
surpass	9	3	828	3	surpass
swears	9	41	1407	3	s_wears
sweepers	13	34	816	3	sweepers
tears	5	54	3646	3	te__ars
tempers	11	35	1301	3	tempers
templars	12	5	526	3	templars
teopans	9	3	920	3	teopans
tepals	8	54	1504	3	te_pals
tepas	7	65	2168	3	te_pa_s
vectors	12	32	1259	3	vectors
velars	9	39	1372	3	ve_lars
vespers	12	3	903	3	vespers
vicars	11	7	1226	3	vic_ars
wears	8	60	3030	3	we__ars
weepers	12	35	1197	3	weepers
years	8	45	2767	3	ye__ars
yelpers	12	34	820	3	yelpers

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.390	458182.1
2	DLD Change Limit	134027	337	6.690	20033.9
3	Display Results	337	337	0.106	3179.2
	(SQL Overall)	178691	337	7.186	24866.5