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

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

112 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
unai	4	48	2478	(None)
unais	5	34	2077	1	unais
unau	4	39	2415	1	unau
unci	6	50	1946	1	unci
ai	2	112	8839	2	__ai
ana	3	95	5983	2	ana_
anal	4	80	3752	2	anal
anas	4	66	4986	2	anas
ani	3	77	5118	2	an_i
anti	4	55	3636	2	anti
bani	6	53	3496	2	bani
buna	6	47	3072	2	buna_
bunas	7	51	2657	2	bunas
chai	9	59	2990	2	chai
dunam	8	3	1373	2	dunam
fundi	9	68	1491	2	fundi
fungi	9	50	1413	2	fungi
gnar	5	60	2138	2	gnar
gnat	5	60	3443	2	gnat
gnaw	8	65	1574	2	gnaw
inia	4	50	2470	2	inia
inti	4	66	2608	2	inti
knap	10	58	1540	2	knap
knar	8	58	1872	2	knar
kuna	8	51	2070	2	kuna_
lanai	5	3	1957	2	lanai
luna	4	62	2985	2	luna_
lunar	5	70	1731	2	lunar
lunas	5	50	2501	2	lunas
lungi	6	55	1605	2	lungi
muni	6	58	2441	2	mun_i
na	2	86	5248	2	_na_
nab	5	69	5492	2	_nab
nae	3	59	5274	2	_nae
nag	4	64	5081	2	_nag
nah	6	98	4700	2	_nah
naif	7	68	3902	2	_naif
nail	4	58	3865	2	_nail
nam	5	59	5339	2	_nam
nan	3	78	5488	2	_nan
naoi	4	60	2463	2	_naoi
nap	5	67	5320	2	_nap
naw	6	63	4649	2	_naw
nay	6	69	5277	2	_nay
nazi	13	62	1987	2	_nazi
puna	6	53	3165	2	puna_
punas	7	48	2675	2	punas
punji	14	3	820	2	punji
quai	13	44	2039	2	quai
rai	3	76	5822	2	_rai
rani	4	66	4011	2	rani
snag	5	58	2787	2	snag
snail	5	70	2020	2	snail
snap	6	57	2703	2	snap
snaw	7	89	2307	2	snaw
tuna	4	51	2784	2	tuna_
tunas	5	42	2412	2	tunas
ulan	4	65	2739	2	ulan
ulna	4	63	1733	2	ulna_
ulnad	6	56	1145	2	ulnad
ulnae	5	52	1457	2	ulnae
ulnar	5	60	1398	2	ulnar
ulnas	5	57	1653	2	ulnas
umami	9	3	988	2	umami
un	2	83	4114	2	un__
unakin	10	3	1096	2	unakin
unapt	7	104	2159	2	unapt
unarm	7	3	1445	2	unarm
unary	8	3	1599	2	unary
unaus	5	32	1657	2	unaus
unban	7	21	1433	2	unban
unbar	7	19	1361	2	unbar
unbe	6	53	1927	2	unbe
unbid	8	32	1464	2	unbid
uncap	9	3	1228	2	uncap
uncia	7	50	1516	2	uncia
unco	6	60	2140	2	unco
unde	5	58	2548	2	unde
undid	7	24	1536	2	undid
undo	5	56	2015	2	undo
undy	8	50	1516	2	undy
unfair	9	3	623	2	unfair
unfit	8	45	1856	2	unfit
unfix	15	42	903	2	unfix
unhair	9	3	733	2	unhair
unhat	8	11	1926	2	unhat
unhip	10	17	882	2	unhip
unit	4	51	4007	2	unit
unjam	14	4	872	2	unjam
unlaid	7	3	1175	2	unlaid
unlay	8	46	1370	2	unlay
unlit	5	50	2546	2	unlit
unman	7	27	1542	2	unman
unmix	14	38	897	2	unmix
unnail	6	4	1058	2	unnail
unpaid	9	3	947	2	unpaid
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
unsaid	7	4	1183	2	unsaid
unsay	8	32	1284	2	unsay
untie	5	44	2549	2	untie
until	5	35	1774	2	until
unto	4	58	2428	2	unto
unwit	8	44	1752	2	unwit
unzip	16	20	762	2	unzip
upas	6	83	2238	2	upas
uraei	5	30	1608	2	uraei
urari	5	46	1996	2	urari
uta	3	74	2558	2	uta_
utas	4	59	2495	2	utas

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.266	671770.7
2	DLD Change Limit	29872	112	0.860	34734.9
3	Display Results	112	112	0.013	8615.4
	(SQL Overall)	178691	112	1.139	156884.1