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

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

155 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
unit	4	51	4007	(None)
knit	8	57	2815	1	knit
nit	3	70	6595	1	_nit
snit	4	63	4247	1	snit
unfit	8	45	1856	1	unfit
unite	5	48	2838	1	unite
units	5	49	2343	1	units
unity	8	49	1849	1	unity
unlit	5	50	2546	1	unlit
unwit	8	44	1752	1	unwit
adit	5	64	4366	2	adit
ait	3	80	9391	2	_ait
alit	4	61	5569	2	alit
ani	3	77	5118	2	ani_
anil	4	64	3743	2	anil
anis	4	57	4647	2	anis
ant	3	72	7079	2	an_t
anti	4	55	3636	2	anti
audit	6	25	2788	2	audit
aunt	4	65	5365	2	aun_t
bait	6	65	5600	2	bait
binit	7	64	3158	2	binit
bint	6	73	5505	2	bint
bit	5	70	7091	2	_bit
brit	6	63	5015	2	brit
bundt	8	58	2485	2	bundt
bunt	6	58	5085	2	bun_t
chit	9	69	3746	2	chit
crit	6	57	4371	2	crit
cubit	9	41	2289	2	cubit
cunt	6	62	4367	2	cun_t
dint	5	67	5906	2	dint
dit	4	70	7134	2	_dit
doit	5	63	4785	2	doit
duit	5	62	4158	2	duit
dunite	7	3	1501	2	dunite
dunt	5	57	4687	2	dun_t
edit	5	49	3487	2	edit
emit	6	54	3842	2	emit
exit	11	44	2867	2	exit
fit	6	63	6546	2	_fit
flit	7	65	3927	2	flit
frit	7	70	4447	2	frit
gait	5	61	5019	2	gait
git	4	62	6606	2	_git
gnat	5	60	3443	2	gnat
grit	5	52	4724	2	grit
gunite	7	4	1440	2	gunite
hint	7	74	5575	2	hint
hit	6	65	6920	2	_hit
hunt	7	64	4549	2	hun_t
inia	4	50	2470	2	inia
inti	4	66	2608	2	inti
it	2	84	5569	2	__it
kit	7	85	5989	2	_kit
knits	9	39	1475	2	knits
knot	8	56	3051	2	knot
lint	4	162	6624	2	lint
lit	3	93	7732	2	_lit
lunet	5	68	3542	2	lunet
lunt	4	61	4884	2	lun_t
mint	6	67	5807	2	mint
muni	6	58	2441	2	muni_
munis	7	50	2200	2	munis
net	3	66	7029	2	_net
nib	5	67	4520	2	_nib
nil	3	61	4420	2	_nil
nim	5	71	4296	2	_nim
nip	5	69	4599	2	_nip
nite	4	59	4359	2	_nite
nits	4	57	4165	2	_nits
nix	10	69	3284	2	_nix
not	3	94	7466	2	_not
nut	3	66	5196	2	_nut
obit	6	68	3708	2	obit
omit	6	53	3737	2	omit
pint	6	69	6318	2	pint
pit	5	64	7193	2	_pit
pundit	9	29	1418	2	pundit
punt	6	57	4720	2	pun_t
qubit	16	42	1899	2	qubit
quint	14	45	2990	2	quint
quit	13	61	3651	2	quit
quoit	14	38	1986	2	quoit
runic	7	36	1577	2	runic
runt	4	66	4799	2	run_t
shit	7	67	4594	2	shit
sit	3	58	7776	2	_sit
skit	8	54	3754	2	skit
slit	4	62	5010	2	slit
smit	6	51	3841	2	smit
snib	6	65	2298	2	snib
snip	6	64	2465	2	snip
snits	5	41	2483	2	snits
snot	4	47	4545	2	snot
spit	6	55	4508	2	spit
suint	5	56	3818	2	suint
suit	4	56	4987	2	suit
sunlit	6	15	1610	2	sunlit
tint	4	67	5887	2	tint
tit	3	67	7106	2	_tit
toit	4	63	5306	2	toit
tunic	7	40	1822	2	tunic
twit	7	63	2906	2	twit
un	2	83	4114	2	un__
unai	4	48	2478	2	unai
unais	5	34	2077	2	unais
unapt	7	104	2159	2	unapt
unau	4	39	2415	2	unau
unbe	6	53	1927	2	unbe
unbid	8	32	1464	2	unbid
unci	6	50	1946	2	unci
uncia	7	50	1516	2	uncia
unco	6	60	2140	2	unco
uncut	7	32	1917	2	uncut
unde	5	58	2549	2	unde
undid	7	24	1536	2	undid
undo	5	56	2016	2	undo
undy	8	50	1517	2	undy
unfits	9	39	1029	2	unfits
unfix	15	42	903	2	unfix
unfixt	16	39	842	2	unfixt
ungirt	7	11	1271	2	ungirt
ungot	6	17	1806	2	ungot
unhat	8	11	1926	2	unhat
unhip	10	17	882	2	unhip
unify	11	36	1111	2	unify
union	5	45	1979	2	union
united	7	44	2154	2	united
uniter	6	46	1914	2	uniter
unites	6	50	2485	2	unites
unknit	10	6	859	2	unknit
unlet	5	41	3333	2	unlet
unmet	7	44	2639	2	unmet
unmix	14	38	897	2	unmix
unmixt	15	37	870	2	unmixt
unpin	7	26	1324	2	unpin
unrig	6	17	1141	2	unrig
unrip	7	20	1286	2	unrip
uns	3	59	3676	2	un_s
unset	5	45	3243	2	unset
untie	5	44	2549	2	untie
until	5	35	1774	2	until
unto	4	58	2428	2	unto
unwet	8	44	2317	2	unwet
unwits	9	38	989	2	unwits
unzip	16	20	762	2	unzip
uplit	7	60	2080	2	uplit
uric	6	36	2494	2	uric
ut	2	86	4703	2	u__t
wait	7	55	5369	2	wait
whit	10	48	3417	2	whit
wit	6	65	6378	2	_wit
writ	7	55	3791	2	writ
zit	12	60	5000	2	_zit

Search took 3 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.703	254183.5
2	DLD Change Limit	29872	155	2.046	14600.2
3	Display Results	155	155	0.030	5166.7
	(SQL Overall)	178691	155	2.779	64300.5