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

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

258 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
dacoit	9	4	1545	(None)
dacoits	10	7	907	1	dacoits
dacoity	13	6	618	1	dacoity
dakoit	11	3	1035	1	dakoit
adroit	7	5	1879	2	adroit
dacite	9	11	1588	2	dac_ite
dakoits	12	4	529	2	dakoits
dakoity	15	4	342	2	dakoity
dammit	11	3	1113	2	dammit
davit	9	34	2459	2	da_vit
daylit	10	5	1249	2	daylit
deceit	9	30	1821	2	deceit
decoct	11	3	1378	2	decoct
dicot	8	54	2909	2	dico_t
doit	5	63	4785	2	d__oit
droit	6	51	2712	2	d_roit
tacit	7	63	3367	2	tac_it
aboil	7	22	1754	3	_aboil
abort	7	61	3358	3	_abort
about	7	52	2908	3	_about
accost	10	11	1226	3	accost
acid	7	75	3339	3	_ac_id
acmic	11	3	1233	3	_acmic
acock	13	21	1021	3	_acock
acold	8	62	1493	3	_acold
aconite	9	3	1547	3	_aconite
acorn	7	56	1662	3	_acorn
acquit	17	6	1032	3	_acquit
acrid	8	69	2010	3	_acrid
act	5	95	5784	3	_ac__t
actin	7	49	2255	3	_actin
acuity	11	3	937	3	_acuity
adit	5	64	4365	3	_a_dit
adjoin	14	10	729	3	adjoin
adjoint	15	10	828	3	adjoint
admit	8	3	1949	3	_admit
adopt	8	12	1974	3	_adopt
afoot	8	4	2011	3	_afoot
afrit	8	3	2317	3	_afrit
ait	3	80	9390	3	_a__it
alit	4	61	5569	3	_a_lit
aloft	8	4	2343	3	_aloft
aloin	5	52	2742	3	_aloin
ambit	9	42	2371	3	_ambit
amort	7	58	3220	3	_amort
anoint	6	4	2363	3	_anoint
aport	7	54	3217	3	_aport
aroid	6	54	2834	3	_aroid
aroint	6	3	2815	3	_aroint
ascot	7	65	2251	3	asco_t
audit	6	25	2788	3	_audit
avoid	9	55	1668	3	_avoid
await	8	55	2449	3	_await
azoic	16	29	1206	3	_azoic
backbit	17	12	910	3	backbit
backfit	18	10	821	3	backfit
backlit	15	9	1190	3	backlit
backout	15	6	1295	3	backout
bacon	9	56	2059	3	baco_n
bacons	10	49	1758	3	bacons
bait	6	65	5600	3	ba__it
bandit	9	38	2113	3	bandit
bankit	12	36	1704	3	bankit
cachet	13	45	2641	3	cachet
cacti	9	3	1864	3	cacti_
cactoid	12	3	1103	3	cactoid
cahoot	11	4	1647	3	cahoot
cavort	11	3	1617	3	cavort
chit	9	69	3746	3	__chit
coat	6	75	5835	3	__coat
coft	9	79	3968	3	__coft
coif	9	63	3791	3	__coif
coil	6	64	3965	3	__coil
coin	6	66	4535	3	__coin
coir	6	63	2724	3	__coir
colt	6	71	5824	3	__colt
coot	6	78	6038	3	__coot
cost	6	80	5794	3	__cost
cot	5	104	8322	3	__co_t
crit	6	57	4371	3	__crit
dace	7	69	3492	3	dac__e
daces	8	50	3068	3	dac_es
dacha	11	48	1257	3	dac_ha
dachas	12	41	1325	3	dachas
dacites	10	11	1459	3	dac_ites
dacker	13	49	2075	3	dacker
dacoities	12	4	821	3	dacoit~~ies~~
dacron	9	43	1069	3	dacron
dacrons	10	32	1103	3	dacrons
dactyl	12	3	498	3	dactyl
dadaist	9	3	1010	3	dadaist
dado	6	71	2633	3	dado__
dadoed	9	44	990	3	dadoed
dadoes	8	56	1653	3	dadoes
dadoing	10	3	852	3	dadoing
dados	7	55	2243	3	dado_s
daft	8	55	3725	3	da__ft
dago	6	57	2509	3	dago__
dagoba	10	7	494	3	dagoba
dagoes	8	57	1460	3	dagoes
dagos	7	64	1944	3	dago_s
dahlia	10	3	577	3	dahlia
dahoon	10	3	905	3	dahoon
daimio	9	3	746	3	daimio
dais	5	70	4070	3	da__is
danio	6	3	1978	3	da_nio
danios	7	3	1460	3	danios
daric	8	56	2312	3	da_ric
darkie	11	37	1401	3	darkie
dart	5	58	5787	3	da__rt
dashi	9	50	1311	3	dashi_
dashis	10	44	1439	3	dashis
dassie	7	46	1557	3	dassie
dato	5	61	2994	3	dato__
datos	6	52	2278	3	dato_s
daunt	6	59	2908	3	da_unt
daut	5	64	4356	3	da__ut
dautie	7	29	1470	3	dautie
davits	10	40	1236	3	da_vits
dawt	8	54	3594	3	da__wt
dawtie	10	30	1109	3	dawtie
deacon	9	5	1042	3	deaco_n
deacons	10	3	1039	3	deacons
debit	8	57	2785	3	d_ebit
decant	9	35	2422	3	decant
deceits	10	28	1088	3	deceits
decent	9	40	2370	3	decent
deco	7	61	2597	3	deco__
decocts	12	3	783	3	decocts
decode	10	44	1474	3	decode
decor	8	47	1757	3	deco_r
decors	9	40	1777	3	decors
decos	8	55	2212	3	deco_s
decoy	11	57	1631	3	deco_y
decoys	12	39	1128	3	decoys
dehort	10	46	1810	3	dehort
demit	8	48	3230	3	d_emit
deport	9	49	2239	3	deport
deposit	10	3	1300	3	deposit
depot	8	57	2792	3	depo_t
devoid	11	8	936	3	devoid
devoir	10	7	603	3	devoir
devout	10	7	1299	3	devout
dhooti	10	3	566	3	dhooti
dhoti	9	3	1012	3	d_hoti
diacid	10	3	1063	3	diac_id
dicast	9	3	1557	3	dicast
dickie	13	39	1311	3	dickie
dicots	9	49	1579	3	dicots
digit	7	38	2527	3	d_igit
dimout	9	4	1424	3	dimout
dimwit	12	3	795	3	dimwit
discoid	11	3	1124	3	discoid
dit	4	70	7133	3	d___it
divot	9	57	2307	3	divo_t
dixit	13	44	2059	3	d_ixit
doat	5	69	4767	3	d__oat
docent	9	29	1868	3	docent
docket	13	47	2117	3	docket
doits	6	62	2367	3	d__oits
dolt	5	66	4942	3	d__olt
dost	5	72	4835	3	d__ost
dot	4	75	7318	3	d__o_t
draconic	13	4	620	3	draconic
droid	7	42	1854	3	d_roid
droits	7	43	1431	3	d_roits
dropt	8	69	2443	3	d_ropt
ducat	8	62	2590	3	duc_at
duci	7	64	2262	3	duc_i_
duckie	13	35	1166	3	duckie
duct	7	57	3546	3	duc__t
dugout	8	3	1036	3	dugout
duit	5	62	4158	3	d__uit
edacity	13	3	637	3	edac_ity
escort	8	46	1648	3	escort
escot	7	53	2008	3	esco_t
facet	10	60	3852	3	fac_et
facia	10	32	1846	3	fac_ia
fact	9	71	4254	3	fac__t
factoid	13	3	869	3	factoid
fagot	9	3	2340	3	fago_t
fucoid	12	3	789	3	fucoid
gadoid	9	3	1046	3	gadoid
gait	5	61	5019	3	ga__it
galiot	7	23	2259	3	galiot
galoot	7	27	1916	3	galoot
gambit	11	47	1421	3	gambit
ganoid	8	3	1444	3	ganoid
gaslit	7	5	1350	3	gaslit
gavot	9	3	2112	3	gavo_t
habit	10	30	2702	3	ha_bit
hackie	15	46	1562	3	hackie
haffit	15	3	853	3	haffit
haloid	10	43	1776	3	haloid
jabot	14	3	2151	3	jabo_t
jacket	19	47	2067	3	jacket
jacobin	18	4	439	3	jacobin
jaconet	16	3	1148	3	jaconet
kainit	10	4	1448	3	kainit
laconic	11	3	988	3	laconic
lactic	10	7	1349	3	lactic
layout	9	5	1370	3	layout
licit	7	43	2768	3	lic_it
macon	9	45	1995	3	maco_n
macons	10	40	1724	3	macons
magot	8	3	2639	3	mago_t
mahout	11	4	1581	3	mahout
maloti	8	3	1321	3	maloti
mascot	10	40	1607	3	masco_t
mucoid	11	3	978	3	mucoid
naoi	4	60	2463	3	na_oi_
packet	14	47	2650	3	packet
pact	8	66	4872	3	pac__t
pandit	9	38	2075	3	pandit
patois	8	43	1936	3	patois
payout	11	7	1465	3	payout
peacoat	11	4	1291	3	peacoat
picot	9	50	3101	3	pico_t
placoid	12	3	977	3	placoid
quoit	14	38	1986	3	_quoit
rabbit	10	29	1456	3	rabbit
rachet	11	50	2897	3	rachet
rachis	11	40	1765	3	rachis
racist	8	28	2279	3	racist
racket	12	52	2942	3	racket
racon	7	54	2214	3	raco_n
racons	8	43	1934	3	racons
racoon	8	38	1447	3	racoon
ragout	7	3	1718	3	ragout
recit	7	52	3510	3	rec_it
recoat	8	40	2427	3	recoat
recoil	8	40	1672	3	recoil
recoin	8	43	2029	3	recoin
sabot	7	9	3178	3	sabo_t
sacbut	10	8	1194	3	sacbut
sachet	11	47	2577	3	sachet
sacrist	9	3	1542	3	sacrist
sarcoid	10	3	1045	3	sarcoid
scoot	7	57	2915	3	_scoot
scot	6	62	4261	3	_sco_t
scout	7	50	3145	3	_scout
tacet	7	58	4002	3	tac_et
tachist	12	6	1329	3	tachist
tacket	12	46	2749	3	tacket
taco	6	70	3135	3	taco__
taconite	10	4	931	3	taconite
tacos	7	70	2355	3	taco_s
tact	6	73	4903	3	tac__t
tactic	10	6	1275	3	tactic
tallit	6	34	2273	3	tallit
tarot	5	59	4393	3	taro_t
toit	4	63	5306	3	__toit
uncoil	8	8	1185	3	uncoil
upcoil	10	12	619	3	upcoil
vacant	11	4	1513	3	vacant
vacuity	15	4	576	3	vacuity
wait	7	55	5369	3	wa__it
yacht	13	4	1739	3	yac_ht

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	112716	0.390	458182.1
2	DLD Change Limit	112716	258	5.986	18829.9
3	Display Results	258	258	0.093	2774.2
	(SQL Overall)	178691	258	6.469	27622.7