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

Here are the results of your fuzzy-string dictionary search for “toit” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

301 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
toit	4	63	5306	(None)
doit	5	63	4785	1	doit
tit	3	67	7105	1	t_it
toft	7	74	4165	1	toft
toil	4	65	3628	1	toil
toits	5	53	2747	1	toits
toot	4	59	5888	1	toot
tort	4	69	6746	1	tort
tost	4	83	5192	1	tost
tot	3	88	8477	1	to_t
tout	4	67	5382	1	tout
twit	7	63	2906	1	twit
adit	5	64	4365	2	adit
ait	3	80	9390	2	_ait
alit	4	61	5569	2	alit
bait	6	65	5600	2	bait
bit	5	70	7090	2	_bit
boat	6	63	6031	2	boat
boil	6	63	3518	2	boil
boite	7	44	2632	2	boite
bolt	6	62	5417	2	bolt
boot	6	77	5937	2	boot
bort	6	59	6096	2	bort
bot	5	96	8040	2	bo_t
bott	6	65	4857	2	bott
bout	6	63	5329	2	bout
brit	6	63	5015	2	brit
chit	9	69	3746	2	chit
coat	6	75	5835	2	coat
coft	9	79	3968	2	coft
coif	9	63	3791	2	coif
coil	6	64	3965	2	coil
coin	6	66	4535	2	coin
coir	6	63	2724	2	coir
colt	6	71	5824	2	colt
coot	6	78	6038	2	coot
cost	6	80	5794	2	cost
cot	5	104	8322	2	co_t
crit	6	57	4371	2	crit
dit	4	70	7133	2	_dit
doat	5	69	4767	2	doat
doits	6	62	2367	2	doits
dolt	5	66	4942	2	dolt
dost	5	72	4835	2	dost
dot	4	75	7318	2	do_t
droit	6	51	2712	2	droit
duit	5	62	4158	2	duit
edit	5	49	3486	2	edit
emit	6	54	3842	2	emit
exit	11	44	2867	2	exit
fit	6	63	6545	2	_fit
flit	7	65	3927	2	flit
foil	7	64	3391	2	foil
foin	7	72	3156	2	foin
foist	8	57	3097	2	foist
font	7	71	4375	2	font
foot	7	62	4801	2	foot
fort	7	64	5644	2	fort
frit	7	70	4447	2	frit
gait	5	61	5019	2	gait
git	4	62	6605	2	_git
goat	5	62	5083	2	goat
got	4	98	7044	2	go_t
gout	5	66	4600	2	gout
grit	5	52	4724	2	grit
hit	6	65	6919	2	_hit
hoist	8	64	3321	2	hoist
holt	7	78	5258	2	holt
hoot	7	57	5210	2	hoot
host	7	78	5283	2	host
hot	6	77	7606	2	ho_t
it	2	84	5568	2	__it
join	11	67	2483	2	join
joint	12	52	2772	2	joint
joist	12	51	2565	2	joist
jolt	11	66	3912	2	jolt
jot	10	82	5902	2	jo_t
kit	7	85	5988	2	_kit
knit	8	57	2814	2	knit
koi	7	75	3475	2	koi_
kois	8	51	2940	2	kois
lit	3	93	7731	2	_lit
loft	7	65	3914	2	loft
loid	5	55	3149	2	loid
loin	4	68	3872	2	loin
loot	4	69	5582	2	loot
lost	4	79	5149	2	lost
lot	3	81	7926	2	lo_t
loti	4	64	3184	2	loti
lout	4	59	5214	2	lout
moat	6	63	5203	2	moat
moil	6	55	3409	2	moil
moist	7	60	3358	2	moist
molt	6	63	5616	2	molt
moot	6	76	5362	2	moot
mort	6	67	5883	2	mort
most	6	65	5420	2	most
mot	5	72	7942	2	mo_t
mott	6	66	4844	2	mott
nit	3	70	6594	2	_nit
noil	4	61	3324	2	noil
noir	4	67	2243	2	noir
not	3	94	7466	2	no_t
nowt	7	88	3375	2	nowt
oat	3	98	8826	2	_oat
obit	6	68	3708	2	obit
oft	6	77	4406	2	_oft
oi	2	90	6148	2	_oi_
oil	3	74	5205	2	_oil
omit	6	53	3737	2	omit
oot	3	112	7469	2	_oot
opt	5	75	4554	2	_opt
ort	3	94	6523	2	_ort
otic	6	66	2482	2	otic
out	3	80	7215	2	_out
pit	5	64	7192	2	_pit
poet	6	55	5290	2	poet
poi	5	72	4466	2	poi_
point	7	53	3873	2	point
pois	6	65	3904	2	pois
port	6	60	5963	2	port
posit	7	58	3333	2	posit
post	6	79	5336	2	post
pot	5	80	7843	2	po_t
pout	6	57	5255	2	pout
quit	13	61	3651	2	quit
quoit	14	38	1986	2	quoit
riot	4	59	4721	2	riot
roil	4	62	3529	2	roil
root	4	56	5592	2	root
rot	3	72	8295	2	ro_t
roti	4	63	3293	2	roti
rout	4	61	5328	2	rout
shit	7	67	4594	2	shit
sit	3	58	7775	2	_sit
skit	8	54	3753	2	skit
slit	4	62	5010	2	slit
smit	6	51	3841	2	smit
snit	4	63	4247	2	snit
soft	7	69	4282	2	soft
soil	4	61	3883	2	soil
soot	4	57	6106	2	soot
sort	4	62	6481	2	sort
sot	3	103	8430	2	so_t
spit	6	55	4508	2	spit
stoat	5	71	3595	2	stoat
stoic	7	3	1725	2	stoic
stopt	7	65	2835	2	stopt
stot	4	63	4733	2	sto_t
stott	5	69	2979	2	stott
stout	5	74	3405	2	stout
suit	4	56	4987	2	suit
tacit	7	63	3367	2	tacit
tact	6	73	4903	2	tact
tail	4	54	4365	2	tail
tain	4	55	4807	2	tain
taint	5	55	4228	2	taint
tart	4	75	6618	2	tart
tat	3	76	9029	2	t_at
taut	4	70	4896	2	taut
teat	4	59	6363	2	teat
tent	4	61	5986	2	tent
test	4	86	5162	2	test
tet	3	92	7499	2	t_et
text	11	60	3393	2	text
that	7	56	3932	2	that
thin	7	67	3239	2	thin
thio	7	72	2541	2	thio
thir	7	64	2054	2	thir
this	7	60	2738	2	this
ti	2	84	4829	2	t_i_
tic	5	63	4346	2	t_ic
tie	3	65	5753	2	t_ie
til	3	63	5026	2	t_il
tilt	4	62	5242	2	tilt
tin	3	63	6217	2	t_in
tint	4	67	5886	2	tint
tip	5	65	5122	2	t_ip
tis	3	70	5664	2	t_is
titi	4	71	3062	2	t_iti
tits	4	61	4504	2	t_its
to	2	188	5898	2	to__
toad	5	58	3018	2	toad
toast	5	58	3101	2	toast
toby	9	63	2229	2	toby
tod	4	94	5707	2	to_d
tods	5	61	4184	2	tods
tody	8	63	2721	2	tody
toe	3	101	6685	2	to_e
toea	4	67	3233	2	toea
toed	5	61	3704	2	toed
toes	4	69	5644	2	toes
toff	10	59	2990	2	toff
tofts	8	49	1924	2	tofts
tofu	7	69	2133	2	tofu
tog	4	102	5504	2	to_g
toga	5	70	2741	2	toga
togs	5	72	4243	2	togs
toile	5	46	2649	2	toile
toilet	6	62	2809	2	toilet
toils	5	45	2749	2	toils
toited	7	40	1675	2	toited
toke	8	67	3849	2	toke
tola	4	52	3633	2	tola
told	5	61	3220	2	told
tole	4	60	5290	2	tole
toll	4	55	3526	2	toll
tolu	4	55	2915	2	tolu
tom	5	143	5805	2	to_m
tomb	8	90	2965	2	tomb
tome	6	75	4319	2	tome
toms	6	83	4349	2	toms
tomtit	8	4	1385	2	tomtit
ton	3	102	6510	2	to_n
tone	4	69	5374	2	tone
tong	5	64	3435	2	tong
tonic	7	47	2765	2	tonic
tons	4	65	5305	2	tons
tony	7	56	3515	2	tony
too	3	89	6542	2	to_o
took	8	65	3107	2	took
tool	4	67	3568	2	tool
toom	6	65	3293	2	toom
toon	4	77	4063	2	toon
tooth	8	80	2018	2	tooth
toots	5	53	3187	2	toots
top	5	105	6068	2	to_p
tope	6	59	4638	2	tope
toph	9	63	2687	2	toph
topi	6	78	3039	2	topi
topic	9	57	2150	2	topic
topis	7	60	2583	2	topis
topo	6	69	3240	2	topo
tops	6	62	4812	2	tops
tor	3	92	6168	2	to_r
tora	4	75	4599	2	tora
torc	6	63	3335	2	torc
tore	4	73	5932	2	tore
tori	4	75	4215	2	tori
toric	7	65	2931	2	toric
torii	5	55	2159	2	torii
torn	4	60	4425	2	torn
toro	4	80	4568	2	toro
torot	5	61	3994	2	torot
torr	4	56	3090	2	torr
tors	4	61	5738	2	tors
torta	5	59	2535	2	torta
torte	5	54	3170	2	torte
torts	5	61	3812	2	torts
tory	7	58	4054	2	tory
tosh	7	48	2681	2	tosh
toss	4	56	3797	2	toss
tote	4	66	4367	2	tote
tots	4	66	5412	2	tots
tour	4	55	3038	2	tour
touts	5	48	3039	2	touts
tow	6	105	5736	2	to_w
towie	8	58	2187	2	towie
town	7	69	2870	2	town
tows	7	85	4555	2	tows
towy	10	53	2547	2	towy
toxic	14	53	1562	2	toxic
toxin	12	47	1671	2	toxin
toy	6	96	5519	2	to_y
toyo	7	69	2545	2	toyo
toys	7	80	3634	2	toys
trait	5	69	4084	2	trait
tret	4	66	5353	2	tret
trig	5	55	2816	2	trig
trim	6	53	2952	2	trim
trio	4	52	3334	2	trio
trip	6	68	3039	2	trip
trite	5	47	3003	2	trite
trois	5	72	2609	2	trois
trot	4	63	5131	2	trot
trout	5	73	3257	2	trout
tuft	7	69	2951	2	tuft
tui	3	70	3402	2	tui_
tuis	4	48	2964	2	tuis
tut	3	67	5809	2	t_ut
twat	7	58	3151	2	twat
twig	8	76	1577	2	twig
twin	7	60	2308	2	twin
twist	8	68	2098	2	twist
twits	8	60	1579	2	twits
twixt	15	55	1248	2	twixt
tyin	7	64	2400	2	tyin
unit	4	51	4007	2	unit
void	8	62	2056	2	void
volt	7	64	3953	2	volt
vomit	10	26	2257	2	vomit
wait	7	55	5369	2	wait
whit	10	48	3417	2	whit
wit	6	65	6377	2	_wit
wont	7	58	4250	2	wont
wort	7	66	5475	2	wort
wost	7	65	4436	2	wost
wot	6	104	6748	2	wo_t
writ	7	55	3791	2	writ
zit	12	60	4999	2	_zit
zoic	15	23	1607	2	zoic

Search took 2 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	29872	0.296	603685.8
2	DLD Change Limit	29872	301	0.783	38150.7
3	Display Results	301	301	0.076	3960.5
	(SQL Overall)	178691	301	1.155	154710.8