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

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

284 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
slit	4	62	5010	(None)
alit	4	61	5569	1	alit
flit	7	65	3927	1	flit
lit	3	93	7731	1	_lit
shit	7	67	4594	1	shit
silt	4	65	5819	1	silt
sit	3	58	7775	1	s_it
skit	8	54	3753	1	skit
slat	4	69	5902	1	slat
slid	5	58	2898	1	slid
slim	6	66	3196	1	slim
slip	6	70	3173	1	slip
slipt	7	66	2748	1	slipt
slits	5	61	2885	1	slits
slot	4	60	4983	1	slot
slut	4	50	4059	1	slut
smit	6	51	3841	1	smit
snit	4	63	4247	1	snit
spit	6	55	4508	1	spit
split	7	57	2901	1	split
suit	4	56	4987	1	suit
adit	5	64	4365	2	adit
ait	3	80	9390	2	_ait
alif	7	62	4214	2	alif
alist	5	61	3678	2	alist
alt	3	64	6796	2	al_t
bait	6	65	5600	2	bait
bit	5	70	7090	2	_bit
blat	6	65	5095	2	blat
blet	6	62	4767	2	blet
blin	6	72	2817	2	blin
blip	8	83	2277	2	blip
blite	7	62	2535	2	blite
blitz	16	53	1813	2	blitz
blot	6	58	4232	2	blot
brit	6	63	5015	2	brit
chit	9	69	3746	2	chit
clift	10	64	2219	2	clift
clip	8	69	2400	2	clip
clipt	9	63	2427	2	clipt
clot	6	65	4242	2	clot
crit	6	57	4371	2	crit
dit	4	70	7133	2	_dit
doit	5	63	4785	2	doit
duit	5	62	4158	2	duit
edit	5	49	3486	2	edit
elint	5	54	3647	2	elint
elite	5	62	3018	2	elite
emit	6	54	3842	2	emit
exit	11	44	2867	2	exit
fit	6	63	6545	2	_fit
flat	7	71	4782	2	flat
flic	9	62	2373	2	flic
flint	8	73	3350	2	flint
flip	9	63	2426	2	flip
flir	7	64	2220	2	flir
flirt	8	74	2475	2	flirt
flite	8	54	2496	2	flite
flits	8	56	2522	2	flits
frit	7	70	4447	2	frit
gait	5	61	5019	2	gait
gaslit	7	5	1350	2	gaslit
gilt	5	63	4854	2	gilt
git	4	62	6605	2	_git
glia	5	64	2315	2	glia
glib	7	94	2144	2	glib
glim	7	60	2635	2	glim
glint	6	68	3018	2	glint
glitz	15	49	1637	2	glitz
glut	5	63	3129	2	glut
grit	5	52	4724	2	grit
hilt	7	58	5071	2	hilt
hit	6	65	6919	2	_hit
ilia	4	60	2682	2	ilia
islet	5	45	2755	2	islet
it	2	84	5568	2	__it
jilt	11	58	3942	2	jilt
kilt	8	61	4441	2	kilt
kit	7	85	5987	2	_kit
klik	7	44	1265	2	klik
knit	8	57	2814	2	knit
lat	3	75	9340	2	_lat
let	3	64	8147	2	_let
li	2	99	4875	2	_li_
lib	5	77	5027	2	_lib
lid	4	74	5351	2	_lid
lie	3	82	6452	2	_lie
lift	7	69	4272	2	_lift
lilt	4	63	4994	2	_lilt
lin	3	79	6737	2	_lin
lint	4	162	6623	2	_lint
lip	5	147	5580	2	_lip
lis	3	71	6227	2	_lis
list	4	70	5534	2	_list
lite	4	70	5454	2	_lite
lits	4	62	5249	2	_lits
litu	4	76	3156	2	_litu
lot	3	81	7926	2	_lot
milt	6	54	5581	2	milt
mislit	8	30	1969	2	mislit
nit	3	70	6594	2	_nit
obit	6	68	3708	2	obit
olio	4	68	2967	2	olio
omit	6	53	3737	2	omit
pit	5	64	7192	2	_pit
plait	7	56	3157	2	plait
plat	6	60	4887	2	plat
plie	6	51	2739	2	plie
plot	6	61	4123	2	plot
quit	13	61	3651	2	quit
relit	5	53	4068	2	relit
said	5	57	4211	2	said
sail	4	54	4716	2	sail
sain	4	55	5129	2	sain
saint	5	51	4707	2	saint
saith	8	58	2655	2	saith
salic	7	34	2471	2	salic
salt	4	57	5852	2	salt
sat	3	62	8848	2	s_at
sati	4	55	3933	2	sati
scat	6	58	4837	2	scat
scot	6	62	4261	2	scot
scut	6	58	3554	2	scut
seat	4	75	7556	2	seat
sect	6	74	4362	2	sect
sei	3	60	4893	2	sei_
seif	7	56	3873	2	seif
seis	4	55	4239	2	seis
sent	4	69	6301	2	sent
sept	6	58	4436	2	sept
set	3	66	8125	2	s_et
sett	4	59	4905	2	sett
sext	11	73	3809	2	sext
shat	7	64	5660	2	shat
shift	11	42	2514	2	shift
shim	9	58	2786	2	shim
shin	7	56	3431	2	shin
ship	9	52	2824	2	ship
shirt	8	45	3390	2	shirt
shist	8	48	2961	2	shist
shits	8	47	3117	2	shits
shiv	10	57	2117	2	shiv
shot	7	61	5026	2	shot
shut	7	61	3759	2	shut
si	2	91	4957	2	s_i_
sib	5	68	5031	2	s_ib
sic	5	58	4787	2	s_ic
sift	7	107	4066	2	sift
sild	5	50	3058	2	sild
silk	8	55	2932	2	silk
sill	4	55	4515	2	sill
silo	4	60	3791	2	silo
silts	5	53	3082	2	silts
silty	8	47	2163	2	silty
sim	5	65	5314	2	s_im
sin	3	62	6589	2	s_in
sip	5	76	5601	2	s_ip
sir	3	57	4667	2	s_ir
sis	3	73	6054	2	s_is
site	4	70	5241	2	s_ite
sith	7	54	3515	2	s_ith
sits	4	50	5020	2	s_its
six	10	53	3974	2	s_ix
skat	8	70	3790	2	skat
ski	7	49	2569	2	ski_
skid	9	57	2092	2	skid
skim	10	53	2251	2	skim
skin	8	59	2753	2	skin
skint	9	56	2922	2	skint
skip	10	54	2175	2	skip
skirt	9	56	2466	2	skirt
skis	8	48	2529	2	skis
skite	9	51	2005	2	skite
skits	9	47	2186	2	skits
skylit	13	3	828	2	skylit
slab	6	71	3376	2	slab
slag	5	59	3435	2	slag
slain	5	49	2357	2	slain
slam	6	77	3797	2	slam
slant	5	52	3870	2	slant
slap	6	64	3404	2	slap
slate	5	54	3828	2	slate
slats	5	54	3690	2	slats
slaty	8	65	2315	2	slaty
slaw	7	79	3071	2	slaw
slay	7	64	3638	2	slay
sled	5	53	3437	2	sled
sleet	5	56	3913	2	sleet
slept	7	57	2810	2	slept
slew	7	62	2823	2	slew
slice	7	49	2582	2	slice
slick	11	55	2052	2	slick
slide	6	47	2541	2	slide
slier	5	48	2724	2	slier
sliest	6	66	2195	2	sliest
slight	10	34	1600	2	slight
slily	8	58	2003	2	slily
slime	7	49	2575	2	slime
slims	7	54	2365	2	slims
slimy	10	54	1742	2	slimy
sling	6	60	2880	2	sling
slink	9	54	2291	2	slink
slipe	7	56	2613	2	slipe
slips	7	60	2372	2	slips
slitty	9	32	916	2	slitty
slob	6	60	2942	2	slob
sloe	4	55	3495	2	sloe
slog	5	67	2827	2	slog
sloid	6	46	1971	2	sloid
slop	6	65	3387	2	slop
sloth	8	50	1945	2	sloth
slots	5	48	3053	2	slots
slow	7	77	2949	2	slow
slub	6	54	2803	2	slub
slue	4	53	3219	2	slue
slug	5	51	2464	2	slug
slum	6	54	3051	2	slum
slur	4	55	2515	2	slur
sluts	5	45	2398	2	sluts
sly	6	62	2856	2	sl_y
smite	7	52	2487	2	smite
smith	10	78	1805	2	smith
smut	6	66	2978	2	smut
snib	6	65	2298	2	snib
snip	6	64	2465	2	snip
snits	5	41	2483	2	snits
snot	4	47	4545	2	snot
soft	7	69	4282	2	soft
soil	4	61	3883	2	soil
soli	4	66	3701	2	soli_
solid	6	50	2508	2	solid
soot	4	57	6106	2	soot
sort	4	62	6481	2	sort
sot	3	103	8430	2	s_ot
spait	7	56	3160	2	spait
spat	6	65	4852	2	spat
spic	8	52	2743	2	spic
spik	10	54	1971	2	spik
spilt	7	55	3222	2	spilt
spin	6	62	3130	2	spin
spirt	7	50	3295	2	spirt
spite	7	54	3066	2	spite
spits	7	44	2955	2	spits
spitz	16	60	1797	2	spitz
spiv	9	59	1779	2	spiv
splat	7	61	2934	2	splat
splint	8	52	2328	2	splint
splits	8	54	1641	2	splits
spot	6	55	4069	2	spot
sprit	7	67	3640	2	sprit
sri	3	56	3400	2	sri_
sris	4	54	3415	2	sris
stat	4	73	5269	2	stat
stet	4	59	4732	2	stet
stilt	5	48	3198	2	stilt
stint	5	70	3766	2	stint
stir	4	57	2325	2	stir
stot	4	63	4733	2	stot
suet	4	67	5482	2	suet
suint	5	56	3818	2	suint
suite	5	48	2956	2	suite
suits	5	50	2805	2	suits
sunlit	6	15	1610	2	sunlit
swat	7	72	4444	2	swat
swift	11	68	1805	2	swift
swig	8	58	1802	2	swig
swim	9	62	2140	2	swim
swith	11	59	1740	2	swith
swot	7	51	3466	2	swot
syli	7	43	1898	2	syli_
sylis	8	43	1602	2	sylis
tilt	4	62	5242	2	tilt
tit	3	67	7105	2	_tit
toit	4	63	5306	2	toit
twit	7	63	2906	2	twit
unit	4	51	4007	2	unit
unlit	5	50	2546	2	unlit
uplit	7	60	2080	2	uplit
wait	7	55	5369	2	wait
whit	10	48	3417	2	whit
wilt	7	62	4629	2	wilt
wit	6	65	6377	2	_wit
writ	7	55	3791	2	writ
zit	12	60	4999	2	_zit

Search took 1 second 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.060	2978183.3
2	DLD Change Limit	29872	284	0.830	35990.4
3	Display Results	284	284	0.063	4507.9
	(SQL Overall)	178691	284	0.953	187503.7