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

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

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
zizith	17	4	482	(None)
zizit	13	3	1327	1	zizit_
tzitzith	19	5	186	2	tzitzith
zenith	18	3	907	2	zenith
zibeth	20	3	417	2	zibeth
airth	8	56	2102	3	ai_rth
azimuth	21	4	184	3	azimuth
azoth	17	38	990	3	_azoth
baith	10	80	2313	3	_baith
binit	7	64	3158	3	binit_
binits	8	57	1667	3	binits
birth	10	56	1987	3	bi_rth
brith	10	49	2437	3	_brith
digit	7	38	2527	3	digit_
digits	8	41	1453	3	digits
dimity	12	3	1047	3	dimity
dixit	13	44	2059	3	dixit_
dixits	14	42	1031	3	dixits
eighth	13	33	1060	3	eighth
eolith	9	30	1390	3	eolith
faith	11	56	2085	3	_faith
fifth	14	52	1092	3	fi_fth
filth	11	50	1582	3	fi_lth
finish	12	46	1341	3	finish
finite	9	3	1682	3	finite
finito	9	3	1030	3	finito
firth	11	58	1953	3	fi_rth
fixit	15	48	1930	3	fixit_
fixity	19	42	780	3	fixity
frith	11	59	2203	3	_frith
girth	9	56	1884	3	gi_rth
grith	9	55	2037	3	_grith
hadith	13	3	1206	3	hadith
highth	12	38	915	3	highth
kibitz	21	7	764	3	kibitz
kith	11	58	2636	3	__kith
laith	8	57	2210	3	_laith
licit	7	43	2768	3	licit_
limit	7	31	2634	3	limit_
limits	8	25	1414	3	limits
liroth	9	3	838	3	liroth
minish	11	52	1630	3	minish
mirth	10	64	1889	3	mi_rth
ninth	8	3	1458	3	ni_nth
oolith	9	38	1324	3	oolith
pinite	8	3	2124	3	pinite
pipit	9	52	2487	3	pipit_
pipits	10	47	1306	3	pipits
pith	9	54	3269	3	__pith
saith	8	58	2655	3	_saith
sith	7	54	3515	3	__sith
sixth	15	55	1223	3	si_xth
sizier	15	148	1339	3	sizier
sizing	16	36	1644	3	sizing
smith	10	78	1805	3	_smith
swith	11	59	1740	3	_swith
tilth	8	55	1536	3	ti_lth
trilith	10	3	1051	3	trilith
tzitzit	15	4	270	3	tzitzit_
visit	8	3	2096	3	visit_
visits	9	3	1142	3	visits
vizier	18	43	1102	3	vizier
vizir	17	35	939	3	vizi_r
vizirs	18	30	671	3	vizirs
widish	13	41	936	3	widish
width	12	3	1096	3	wi_dth
winish	12	42	1226	3	winish
with	10	57	3047	3	__with
wraith	12	5	860	3	wraith
yirth	11	65	1375	3	yi_rth
zeniths	19	3	515	3	zeniths
zeroth	18	3	796	3	zeroth
zibet	16	4	1973	3	zibet_
zibeths	21	4	293	3	zibeths
zibets	17	3	774	3	zibets
zilch	19	43	812	3	zi_lch
zillah	18	3	656	3	zillah
zincite	18	3	723	3	zincite
zit	12	60	4999	3	__zit_
ziti	13	60	2237	3	__ziti
zitis	14	58	1558	3	ziti_s
zits	13	60	3029	3	__zits
zizzle	13	24	731	3	zizzle
zoisite	16	3	583	3	zoisite
zuzim	15	3	487	3	zuzi_m

Search took 6 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.373	479064.3
2	DLD Change Limit	112716	85	5.016	22471.3
3	Display Results	85	85	0.030	2833.3
	(SQL Overall)	178691	85	5.419	32974.9