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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

85 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
kithe	12	59	1745	(None)
kite	8	53	3823	1	kit_e
kith	11	58	2635	1	kith_
kithed	14	46	1301	1	kithed
kithes	13	50	1665	1	kithes
kiths	12	58	1497	1	kiths
kythe	15	50	967	1	kythe
lithe	8	49	2201	1	lithe
tithe	8	53	1970	1	tithe
withe	11	52	2023	1	withe
bathe	10	58	2288	2	bathe
bite	6	65	4700	2	bit_e
blithe	11	58	1086	2	blithe
cite	6	56	4034	2	cit_e
cither	11	46	1668	2	cither
dite	5	55	4755	2	dit_e
dither	10	44	1768	2	dither
either	9	45	1742	2	either
fiche	13	46	1674	2	fiche
gighe	10	13	973	2	gighe
gite	5	54	3861	2	git_e
hither	12	44	1725	2	hither
ither	8	46	1760	2	_ither
kibbe	13	52	1197	2	kibbe
kibe	10	65	2344	2	ki_be
kike	7	65	2478	2	ki_ke
kiltie	10	32	1096	2	kiltie
kine	8	56	4342	2	ki_ne
kirtle	10	30	947	2	kirtle
kishke	12	5	427	2	kishke
kit	7	85	5987	2	kit__
kitchen	16	28	768	2	kitchen
kited	10	51	2009	2	kited
kiter	9	55	2321	2	kiter
kites	9	54	3254	2	kites
kits	8	64	4176	2	kit_s
kitted	11	51	1483	2	kitted
kittel	10	36	886	2	kittel
kitten	10	46	1148	2	kitten
kittle	10	40	1217	2	kittle
kitty	12	46	1456	2	kitty
kyte	11	70	1776	2	kyt_e
kythed	17	40	731	2	kythed
kythes	16	49	913	2	kythes
lathe	8	56	2671	2	lathe
lethe	8	57	1730	2	lethe
lite	4	70	5454	2	lit_e
lither	9	45	2095	2	lither
litho	8	65	1378	2	litho
litre	5	54	2146	2	litre
miche	12	62	1924	2	miche
mite	6	62	4941	2	mit_e
mither	11	42	1856	2	mither
mitre	7	55	2242	2	mitre
niche	10	50	1679	2	niche
nite	4	59	4358	2	nit_e
nitre	5	75	1968	2	nitre
pith	9	54	3269	2	pith_
pithed	12	46	1561	2	pithed
piths	10	58	1754	2	piths
pithy	13	56	1446	2	pithy
rathe	8	58	2192	2	rathe
rite	4	58	4945	2	rit_e
saithe	9	47	1391	2	saithe
sidhe	9	53	1510	2	sidhe
site	4	70	5241	2	sit_e
sith	7	54	3515	2	sith_
skite	9	51	2004	2	skit_e
swithe	12	40	1068	2	swithe
the	6	74	3605	2	__the
tithed	10	41	1559	2	tithed
tither	9	49	2028	2	tither
tithes	9	47	2021	2	tithes
title	5	47	2107	2	title
titre	5	46	1939	2	titre
tythe	11	52	1045	2	tythe
vitae	8	42	1763	2	vitae
wite	7	54	4327	2	wit_e
with	10	57	3047	2	with_
withed	13	44	1623	2	withed
wither	12	43	2135	2	wither
withes	12	46	2084	2	withes
withy	14	48	1376	2	withy
writhe	12	53	1070	2	writhe
zither	18	38	1308	2	zither

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	53800	0.093	1921408.6
2	DLD Change Limit	53800	85	1.360	39558.8
3	Display Results	85	85	0.030	2833.3
	(SQL Overall)	178691	85	1.483	120492.9