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

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

345 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
deacons	10	3	1039	(None)
beacons	11	4	1073	1	beacons
deacon	9	5	1042	1	deacon_
bacons	10	49	1758	2	_bacons
beacon	10	5	1137	2	beacon_
dacrons	10	32	1103	2	d_acrons
daemons	10	26	923	2	daemons
deaconed	12	3	749	2	deaconed
deaconess	12	4	554	2	deaconess
deaconry	14	4	332	2	deaconry
deadens	9	34	1069	2	deadens
deafens	11	31	725	2	deafens
deans	6	61	3139	2	dea__ns
decagons	12	3	589	2	decagons
decors	9	40	1777	2	de_cors
decos	8	55	2212	2	de_co_s
decoys	12	39	1128	2	de_coys
demons	9	49	1772	2	de_mons
devons	10	45	1225	2	de_vons
dragons	9	3	838	2	dragons
flacons	12	3	805	2	flacons
macons	10	40	1724	2	_macons
neocons	9	3	691	2	neocons
racons	8	43	1934	2	_racons
reasons	7	25	1494	2	reasons
recons	8	49	2299	2	re_cons
seasons	7	26	1423	2	seasons
weakons	14	28	780	2	weakons
weapons	12	27	860	2	weapons
weasons	10	23	1058	2	weasons
acorns	8	50	1301	3	__acorns
aeons	5	76	2465	3	__aeons
agons	6	64	2378	3	__agons
alencons	10	4	548	3	alencons
amazons	18	3	665	3	amazons
axons	12	55	1793	3	__axons
azons	14	65	1825	3	__azons
bacon	9	56	2059	3	_bacon_
barons	8	50	2538	3	_barons
batons	8	55	1942	3	_batons
beaches	14	41	2065	3	beaches
beaconed	13	3	698	3	beaconed
beanos	8	55	1651	3	beano_s
beans	7	57	3469	3	bea__ns
beckons	15	27	914	3	beckons
belons	8	41	1941	3	be_lons
betons	8	49	1955	3	be_tons
blazons	18	3	616	3	blazons
canons	8	55	2206	3	_canons
capons	10	41	1950	3	_capons
celadons	11	3	700	3	celadons
claxons	16	3	580	3	claxons
cons	6	60	5769	3	___cons
cratons	9	43	1603	3	cratons
crayons	12	43	923	3	crayons
daces	8	50	3068	3	d_ac_es
dachas	12	41	1325	3	d_achas
dacoit	9	4	1545	3	d_acoit
dacoits	10	7	907	3	d_acoits
dacron	9	43	1069	3	d_acron_
dadoes	8	56	1653	3	d_adoes
dados	7	55	2243	3	d_ado_s
daemon	9	27	959	3	daemon_
daemones	11	20	916	3	daemones
dagoes	8	57	1460	3	d_agoes
dagos	7	64	1944	3	d_ago_s
dahoons	11	3	775	3	dahoons
daikons	12	18	669	3	daikons
daimons	10	24	932	3	daimons
dalapons	11	4	544	3	dalapons
daltons	8	3	1040	3	daltons
damans	9	47	1598	3	d_amans
damns	8	49	1692	3	d_a_mns
damsons	10	3	801	3	damsons
dans	5	67	4815	3	d_a__ns
darns	6	69	2789	3	d_a_rns
datos	6	52	2278	3	d_ato_s
davens	10	46	1291	3	d_avens
dawns	9	59	1659	3	d_a_wns
deaconing	13	3	719	3	deaconing
deaconries	13	4	516	3	deacon~~rie~~s
deaden	8	37	1432	3	deaden_
deadpans	12	20	517	3	deadpans
deads	7	57	2691	3	dea__ds
deafen	10	38	967	3	deafen_
deairs	7	40	1378	3	dea_irs
dealers	8	41	1861	3	dealers
dealing	9	43	2323	3	dealing
dealings	10	35	1070	3	dealings
deals	6	54	3534	3	dea__ls
dean	5	60	3948	3	dea__n_
deaning	9	40	2047	3	deaning
dearies	8	35	2627	3	dearies
dears	6	57	3688	3	dea__rs
dearths	11	49	884	3	dearths
deashes	11	33	1390	3	deashes
deaths	10	59	1444	3	dea_ths
deaves	10	53	1953	3	dea_ves
deaving	12	38	1475	3	deaving
debacles	13	3	572	3	debacles
debone	9	37	1478	3	de_bone
debones	10	33	1511	3	de_bones
debtors	10	3	853	3	debtors
decades	11	36	1551	3	decades
decafs	12	40	1088	3	de_cafs
decagon	11	3	586	3	decagon_
decalogs	12	4	563	3	decalogs
decals	9	37	1771	3	de_cals
decamps	14	3	564	3	decamps
decane	9	38	1887	3	de_cane
decanes	10	31	1891	3	decanes
decant	9	35	2422	3	de_cant
decants	10	35	1444	3	decants
decapods	14	4	462	3	decapods
decares	10	28	1853	3	decares
decays	12	46	1291	3	de_cays
decent	9	40	2370	3	de_cent
decerns	10	11	905	3	decerns
decks	12	48	2219	3	de_c_ks
deco	7	61	2597	3	de_co__
decoct	11	3	1378	3	de_coct
decocts	12	3	783	3	de_cocts
decode	10	44	1474	3	de_code
decodes	11	39	1498	3	de_codes
decor	8	47	1757	3	de_co_r
decoy	11	57	1631	3	de_co_y
decrowns	14	26	506	3	decrowns
dedans	8	59	1507	3	de_dans
deepens	10	30	781	3	deepens
deewans	11	30	690	3	deewans
defacers	14	23	799	3	defacers
defaces	13	32	1340	3	defac_es
defacing	15	23	868	3	defacing
defocus	13	3	528	3	defocus
defogs	11	5	668	3	de_fogs
dehorns	11	42	836	3	dehorns
deicers	10	36	1273	3	deicers
deices	9	41	1937	3	deic_es
deicing	11	3	1219	3	deicing
deigns	8	38	998	3	de_igns
dekkos	10	3	410	3	dekko_s
delations	10	26	1659	3	delations
delators	9	23	1482	3	delators
demagogs	13	4	388	3	demagogs
demeans	10	3	972	3	demeans
demetons	11	3	762	3	demetons
demobs	11	42	948	3	de_mobs
demon	8	65	2031	3	de_mon_
demos	8	60	2299	3	de_mo_s
dendrons	10	4	739	3	dendrons
dens	5	59	4507	3	de___ns
dentins	8	34	1922	3	dentins
deploys	13	3	652	3	deploys
depone	9	36	1655	3	de_pone
depones	10	37	1709	3	de_pones
depots	9	47	1634	3	de_pots
deraigns	10	3	488	3	deraigns
descant	10	43	1559	3	descant
descants	11	29	1014	3	descants
descend	11	24	815	3	descend
descends	12	26	698	3	descends
descent	10	26	1629	3	descent
descents	11	25	1120	3	descents
designs	9	32	831	3	designs
desmans	10	3	900	3	desmans
despond	11	3	751	3	despond
desponds	12	4	624	3	desponds
despots	10	31	968	3	despots
detaches	14	3	965	3	detaches
detains	8	37	1609	3	detains
deuces	9	40	1551	3	deuc_es
deucing	11	3	939	3	deucing
deveins	11	3	881	3	deveins
devious	11	3	852	3	devious
devon	9	51	1368	3	de_von_
dewans	10	52	1514	3	de_wans
dewools	11	4	559	3	dewools
diacids	11	3	786	3	diacids
diaconal	11	9	613	3	diaconal
dialogs	9	3	810	3	dialogs
diamins	10	3	1221	3	diamins
diamond	11	8	611	3	diamond
diamonds	12	12	517	3	diamonds
diatoms	10	3	907	3	diatoms
diatrons	9	3	961	3	diatrons
diazins	17	3	918	3	diazins
dicots	9	49	1579	3	d_icots
discos	9	49	1521	3	disco_s
diurons	8	3	882	3	diurons
doblons	10	3	704	3	doblons
dobsons	10	3	620	3	dobsons
donjons	15	3	673	3	donjons
dons	5	60	4870	3	d___ons
dracena	10	3	492	3	dracena
dracenas	11	4	579	3	dracenas
drachms	15	3	425	3	drachms
draconic	13	4	619	3	draconic
dragon	8	3	884	3	dragon_
dragoons	10	4	501	3	dragoons
drains	7	37	1940	3	dra_ins
dromons	10	3	819	3	dromons
durions	8	3	996	3	durions
earns	5	59	2756	3	_ea_rns
ebons	7	43	1609	3	_e_bons
edacious	11	4	602	3	edacious
eikons	10	3	850	3	_eikons
eons	4	66	3871	3	_e__ons
escots	8	42	1174	3	_escots
etalons	7	3	907	3	etalons
exons	12	58	1334	3	_e_xons
falcons	12	3	912	3	falcons
fanons	9	61	1521	3	_fanons
felons	9	36	1576	3	fe_lons
flacon	11	3	863	3	flacon_
flagons	11	3	797	3	flagons
garcons	10	24	1164	3	garcons
gascons	10	28	910	3	gascons
guacos	9	44	1031	3	guaco_s
halons	9	57	2071	3	_halons
heavens	13	43	930	3	heavens
helicons	13	3	761	3	helicons
herons	9	48	2054	3	he_rons
hexagons	19	4	394	3	hexagons
icons	7	65	1649	3	__icons
ideations	10	3	990	3	ideations
jealous	14	3	809	3	jealous
jeans	12	60	2211	3	jea__ns
jetons	13	45	1261	3	je_tons
jettons	14	3	727	3	jettons
kaons	9	50	1485	3	_ka_ons
kelsons	11	3	732	3	kelsons
klaxons	18	3	326	3	klaxons
leaches	12	33	1934	3	leaches
leadens	8	36	1098	3	leadens
leans	5	55	3625	3	lea__ns
learns	6	55	1374	3	lea_rns
leavens	10	40	930	3	leavens
legions	8	46	1178	3	legions
lemons	8	44	1505	3	le_mons
leptons	9	19	1043	3	leptons
lesions	7	38	1387	3	lesions
lessons	7	38	1102	3	lessons
leucins	9	3	810	3	leucins
leukons	11	3	575	3	leukons
lexicons	17	4	389	3	lexicons
limacons	12	4	395	3	limacons
macon	9	45	1995	3	_macon_
macrons	11	35	1489	3	_macrons
mascons	11	34	1158	3	mascons
masons	8	39	1651	3	_masons
meadows	13	3	733	3	meadows
means	7	58	3123	3	mea__ns
megatons	11	27	970	3	megatons
melons	8	41	1771	3	me_lons
meltons	9	4	1092	3	meltons
menazons	19	4	573	3	menazons
merlons	9	33	1127	3	merlons
mesons	8	32	1584	3	me_sons
neatens	7	33	1040	3	neatens
negatons	9	29	927	3	negatons
nektons	11	3	639	3	nektons
nelsons	7	3	800	3	nelsons
neocon	8	3	671	3	neocon_
neons	5	58	1868	3	ne__ons
neurons	7	4	1044	3	neurons
newtons	10	3	681	3	newtons
niacins	9	3	854	3	niacins
odeons	7	3	902	3	ode__ons
paeons	8	39	1552	3	_paeons
peaces	10	63	2408	3	peac_es
peaches	14	41	2005	3	peaches
peacing	12	41	1707	3	peacing
peacoat	11	4	1291	3	peacoat
peacoats	12	4	783	3	peacoats
peacock	17	4	514	3	peacock
peacocks	18	4	499	3	peacocks
peahens	12	30	757	3	peahens
peans	7	54	3764	3	pea__ns
peascods	13	4	406	3	peascods
pecans	10	15	1583	3	pe_cans
pennons	9	3	971	3	pennons
peons	7	53	2718	3	pe__ons
pereons	9	28	1500	3	pereons
perrons	9	31	1548	3	perrons
persons	9	37	1701	3	persons
racon	7	54	2214	3	_racon_
racoons	9	39	1243	3	_racoons
radons	7	41	1853	3	_radons
rayons	9	41	1334	3	_rayons
reaches	12	34	2320	3	reaches
reactions	11	7	1171	3	reactions
reactors	10	32	1228	3	reactors
reacts	8	36	1660	3	reac_ts
readorns	9	3	828	3	readorns
reagins	8	42	1564	3	reagins
reason	6	26	1633	3	reason_
reavows	13	3	527	3	reavows
reckons	13	26	965	3	reckons
recoins	9	40	1924	3	re_coins
recon	7	56	2424	3	re_con_
redons	7	52	2218	3	re_dons
regions	8	36	1347	3	regions
salons	6	38	2369	3	_salons
seacoast	10	4	778	3	seacoast
seacock	15	4	557	3	seacock
seacocks	16	4	564	3	seacocks
seadogs	9	5	864	3	seadogs
season	6	27	1490	3	season_
seawans	10	37	994	3	seawans
seccos	10	3	992	3	secco_s
second	9	4	1115	3	se_cond
seconds	10	3	828	3	se_conds
sermons	9	3	1178	3	sermons
setons	6	46	2017	3	se_tons
sextons	14	37	1041	3	sextons
subdeacons	15	5	265	3	~~sub~~deacons
tacos	7	70	2355	3	_taco_s
talons	6	40	1944	3	_talons
tauons	6	34	1267	3	_tauons
taxons	13	42	1150	3	_taxons
teaches	12	27	1835	3	teaches
teacups	11	3	396	3	teacups
teapots	9	3	905	3	teapots
teapoys	12	3	596	3	teapoys
teflons	10	3	654	3	teflons
telcos	8	7	1068	3	telco_s
telsons	7	3	922	3	telsons
tendons	8	3	1147	3	tendons
tenons	6	29	1660	3	te_nons
testons	7	3	1356	3	testons
treasons	8	4	868	3	treasons
wagons	10	39	1121	3	_wagons
weakens	14	36	706	3	weakens
weakon	13	35	762	3	weakon_
weans	8	53	2674	3	wea__ns
weapon	11	28	811	3	weapon_
weason	9	32	1082	3	weason_
xenons	13	27	1048	3	xe_nons
yapons	11	44	1177	3	_yapons
yeans	8	66	2488	3	yea__ns
yearns	9	50	954	3	yea_rns
zealots	16	3	676	3	zealots
zealous	16	3	781	3	zealous
zeatins	16	3	1173	3	zeatins
zircons	18	5	496	3	zircons

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.406	440125.6
2	DLD Change Limit	134027	345	6.546	20474.6
3	Display Results	345	345	0.123	2804.9
	(SQL Overall)	178691	345	7.075	25256.7