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

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

239 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
sith	7	54	3515	(None)
kith	11	58	2636	1	kith
pith	9	54	3269	1	pith
saith	8	58	2655	1	saith
sidh	8	62	2299	1	sidh
sigh	8	56	2589	1	sigh
sinh	7	62	3804	1	sinh
sit	3	58	7775	1	sit_
site	4	70	5241	1	site
sits	4	50	5020	1	sits
sixth	15	55	1223	1	sixth
smith	10	78	1805	1	smith
soth	7	59	3252	1	soth
swith	11	59	1740	1	swith
with	10	57	3047	1	with
airth	8	56	2102	2	airth
ait	3	80	9390	2	ait_
aitch	10	52	1616	2	aitch
aits	4	63	5553	2	aits
baith	10	80	2313	2	baith
bath	9	59	4008	2	bath
beth	9	66	2923	2	beth
birth	10	56	1987	2	birth
bit	5	70	7090	2	bit_
bitch	12	50	1776	2	bitch
bite	6	65	4700	2	bite
bits	6	61	4816	2	bits
bitt	6	55	4581	2	bitt
both	9	65	3343	2	both
brith	10	49	2437	2	brith
cite	6	56	4034	2	cite
city	9	51	2262	2	city
dish	8	63	2833	2	dish
dit	4	70	7133	2	dit_
dita	5	60	3252	2	dita
ditch	11	50	1509	2	ditch
dite	5	55	4755	2	dite
dits	5	64	5052	2	dits
ditz	14	69	2951	2	ditz
doth	8	62	2571	2	doth
eath	7	57	3566	2	eath
eth	6	66	3098	2	_eth
faith	11	56	2085	2	faith
fifth	14	52	1092	2	fifth
filth	11	50	1582	2	filth
firth	11	58	1953	2	firth
fish	10	69	2627	2	fish
fit	6	63	6545	2	fit_
fitch	13	48	1687	2	fitch
fits	7	60	4346	2	fits
frith	11	59	2203	2	frith
girth	9	56	1884	2	girth
git	4	62	6605	2	git_
gite	5	54	3861	2	gite
gits	5	57	4459	2	gits
goth	8	68	2508	2	goth
grith	9	55	2037	2	grith
hath	10	59	3391	2	hath
heth	10	70	2802	2	heth
high	11	66	1992	2	high
hit	6	65	6919	2	hit_
hitch	13	45	1547	2	hitch
hits	7	55	4513	2	hits
ich	8	62	2774	2	_ich
it	2	84	5568	2	_it_
itch	9	56	1917	2	_itch
its	3	55	3883	2	_its
kit	7	85	5988	2	kit_
kite	8	53	3824	2	kite
kithe	12	59	1745	2	kithe
kiths	12	58	1497	2	kiths
kits	8	64	4177	2	kits
laith	8	57	2210	2	laith
lath	7	66	4038	2	lath
lich	9	62	3084	2	lich
lit	3	93	7731	2	lit_
lite	4	70	5454	2	lite
lithe	8	49	2201	2	lithe
litho	8	65	1378	2	litho
lits	4	62	5249	2	lits
litu	4	76	3156	2	litu
loth	7	61	3213	2	loth
math	9	54	3745	2	math
meth	9	58	2784	2	meth
mirth	10	64	1889	2	mirth
mite	6	62	4941	2	mite
mitt	6	61	4549	2	mitt
mity	9	55	2821	2	mity
moth	9	67	3133	2	moth
myth	12	67	1543	2	myth
nigh	8	52	2066	2	nigh
ninth	8	3	1458	2	ninth
nit	3	70	6594	2	nit_
nite	4	59	4358	2	nite
nits	4	57	4164	2	nits
nth	6	63	2059	2	_nth
oath	7	61	3215	2	oath
path	9	91	3491	2	path
pish	9	61	2791	2	pish
pit	5	64	7192	2	pit_
pita	6	54	3643	2	pita
pitch	12	50	1841	2	pitch
piths	10	58	1754	2	piths
pithy	13	56	1446	2	pithy
pits	6	63	4874	2	pits
pity	9	60	3193	2	pity
rath	7	60	3766	2	rath
rich	9	70	2554	2	rich
rite	4	58	4945	2	rite
ritz	13	51	2998	2	ritz
ruth	7	68	2599	2	ruth
saithe	9	47	1391	2	saithe
sash	7	72	3530	2	sash
sat	3	62	8848	2	sat_
sate	4	55	5610	2	sate
sati	4	55	3933	2	sati
set	3	66	8125	2	set_
seta	4	56	3731	2	seta
sets	4	55	4950	2	sets
sett	4	59	4905	2	sett
sh	5	68	2852	2	s__h
shah	10	56	2778	2	shah
shh	9	71	2107	2	s_hh
shit	7	67	4594	2	shit_
shits	8	47	3117	2	shits
si	2	91	4957	2	si__
sial	4	59	3883	2	sial
sib	5	68	5031	2	si_b
sibb	8	59	2142	2	sibb
sibs	6	59	3354	2	sibs
sic	5	58	4787	2	si_c
sice	6	55	4559	2	sice
sick	10	64	3557	2	sick
sics	6	52	3409	2	sics
side	5	54	4449	2	side
sidhe	9	53	1510	2	sidhe
sift	7	107	4066	2	sift
sifts	8	49	1892	2	sifts
sighs	9	54	1674	2	sighs
sight	9	46	2929	2	sight
sign	5	55	2305	2	sign
sika	8	60	2132	2	sika
sike	8	71	3878	2	sike
sild	5	50	3058	2	sild
silk	8	55	2932	2	silk
sill	4	55	4515	2	sill
silo	4	60	3791	2	silo
silt	4	65	5819	2	silt
silts	5	53	3082	2	silts
silty	8	47	2163	2	silty
sim	5	65	5314	2	si_m
sima	6	47	3078	2	sima
simp	8	52	2877	2	simp
sims	6	57	3717	2	sims
sin	3	62	6589	2	si_n
sine	4	65	6062	2	sine
sing	5	75	4417	2	sing
sinhs	8	67	1960	2	sinhs
sink	8	66	4014	2	sink
sins	4	67	5527	2	sins
sip	5	76	5601	2	si_p
sipe	6	73	4104	2	sipe
sips	6	57	4010	2	sips
sir	3	57	4667	2	si_r
sire	4	61	5041	2	sire
sirs	4	43	3833	2	sirs
sis	3	73	6054	2	si_s
sitar	5	48	2054	2	sitar
sited	6	51	3074	2	sited
sites	5	60	4543	2	sites
situp	7	44	1406	2	situp
situs	5	50	1923	2	situs
six	10	53	3974	2	si_x
sixte	12	62	1658	2	sixte
sixths	16	41	637	2	sixths
sixty	15	49	1273	2	sixty
size	13	56	3096	2	size
sizy	16	48	1639	2	sizy
skit	8	54	3753	2	skit_
skite	9	51	2005	2	skite
skits	9	47	2186	2	skits
slit	4	62	5010	2	slit_
slits	5	61	2885	2	slits
sloth	8	50	1945	2	sloth
smit	6	51	3841	2	smit_
smite	7	52	2487	2	smite
smiths	11	47	1102	2	smiths
smithy	14	50	827	2	smithy
snath	8	64	1980	2	snath
snit	4	63	4247	2	snit_
snitch	11	35	794	2	snitch
snits	5	41	2483	2	snits
sooth	8	59	2406	2	sooth
soph	9	70	2420	2	soph
sot	3	103	8430	2	sot_
soths	8	62	1863	2	soths
sots	4	55	5245	2	sots
south	8	52	2357	2	south
spilth	11	46	973	2	spilth
spit	6	55	4508	2	spit_
spite	7	54	3066	2	spite
spits	7	44	2955	2	spits
spitz	16	60	1797	2	spitz
stich	10	41	1792	2	stich
stir	4	57	2325	2	stir
stitch	11	41	910	2	stitch
stithy	12	39	821	2	stithy
sty	6	62	2731	2	s_ty
such	9	64	2481	2	such
sugh	8	64	2344	2	sugh
suit	4	56	4987	2	suit_
suite	5	48	2956	2	suite
suits	5	50	2805	2	suits
swath	11	59	2038	2	swath
swish	11	51	1482	2	swish
switch	14	45	891	2	switch
swithe	12	40	1068	2	swithe
synth	11	37	1182	2	synth
syph	12	54	1327	2	syph
teth	7	63	2789	2	teth
tilth	8	55	1536	2	tilth
tit	3	67	7105	2	tit_
tithe	8	53	1970	2	tithe
titi	4	71	3062	2	titi
tits	4	61	4504	2	tits
vita	7	58	2852	2	vita
wich	12	57	2474	2	wich
width	12	3	1096	2	width
wish	10	72	2873	2	wish
wit	6	65	6377	2	wit_
witch	13	45	1756	2	witch
wite	7	54	4327	2	wite
withe	11	52	2023	2	withe
withy	14	48	1376	2	withy
wits	7	60	4487	2	wits
yirth	11	65	1375	2	yirth
zit	12	60	4999	2	zit_
ziti	13	60	2237	2	ziti
zits	13	60	3029	2	zits

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.263	679433.5
2	DLD Change Limit	29872	239	0.940	31778.7
3	Display Results	239	239	0.060	3983.3
	(SQL Overall)	178691	239	1.263	141481.4