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

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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
Check this box to automatically increase the Change Limit after seconds.

98 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
unbe	6	53	1927	(None)
unde	5	58	2548	1	unde
abbe	8	76	2719	2	abbe
ane	3	78	6695	2	an_e
ante	4	65	3890	2	ante
babe	8	68	3582	2	babe
be	4	79	4894	2	__be
cube	8	58	3021	2	cube
dunce	8	63	1926	2	dunce
dune	5	61	3758	2	dun_e
gibe	7	59	2778	2	gibe
gybe	10	59	1624	2	gybe
hebe	9	64	2470	2	hebe
inby	9	53	1566	2	inby
inbye	10	42	706	2	inbye
jibe	13	63	2339	2	jibe
jube	13	63	2278	2	jube
kibe	10	65	2344	2	kibe
knee	8	53	2360	2	knee
kune	8	54	2457	2	kun_e
lobe	6	55	3536	2	lobe
lube	6	47	3156	2	lube
lune	4	71	4049	2	lun_e
lunge	6	53	2380	2	lunge
mabe	8	57	3336	2	mabe
nabe	6	60	2949	2	nabe
nae	3	59	5274	2	_nae
ne	2	70	4510	2	_n_e
neb	5	72	3862	2	_neb
nee	3	66	5778	2	_nee
nub	5	64	3914	2	nub_
nubs	6	59	2714	2	nubs
nude	5	66	2627	2	nude
nuke	8	59	2075	2	nuke
obe	5	66	3864	2	_obe
once	6	54	2308	2	once
one	3	70	5091	2	on_e
ounce	7	70	1993	2	ounce
robe	6	53	3564	2	robe
rube	6	55	3201	2	rube
rune	4	52	3629	2	run_e
sabe	6	61	4057	2	sabe
snye	7	71	1549	2	snye
tube	6	58	2866	2	tube
tune	4	56	3586	2	tun_e
uke	7	57	2729	2	u_ke
ulnae	5	52	1457	2	ulnae
umbel	9	36	1284	2	umbel
umber	9	46	1759	2	umber
umbo	8	55	1666	2	umbo
un	2	83	4113	2	un__
unable	8	38	1922	2	unable
unai	4	48	2478	2	unai
unau	4	39	2415	2	unau
unbale	8	36	1640	2	unbale
unban	7	21	1433	2	unban
unbar	7	19	1361	2	unbar
unbear	8	8	916	2	unbear
unbelt	8	30	1569	2	unbelt
unbend	9	26	977	2	unbend
unbent	8	32	1659	2	unbent
unbid	8	32	1464	2	unbid
unbox	14	3	875	2	unbox
unbred	9	26	1330	2	unbred
unci	6	50	1946	2	unci
uncle	7	3	1705	2	uncle
unco	6	60	2140	2	unco
undee	6	53	2727	2	undee
under	6	46	2421	2	under
undo	5	56	2015	2	undo
undue	6	67	1555	2	undue
undy	8	50	1516	2	undy
unfed	9	46	1422	2	unfed
unit	4	51	4007	2	unit
unite	5	48	2838	2	unite
unled	6	40	2107	2	unled
unlet	5	41	3333	2	unlet
unmet	7	44	2639	2	unmet
unmew	10	36	1007	2	unmew
unpeg	8	30	936	2	unpeg
unpen	7	29	1357	2	unpen
unrobe	8	26	1167	2	unrobe
uns	3	59	3675	2	un_s
unset	5	45	3243	2	unset
unsew	8	39	1269	2	unsew
unsex	12	35	1263	2	unsex
untie	5	44	2549	2	untie
unto	4	58	2428	2	unto
unwed	9	41	1487	2	unwed
unwet	8	44	2317	2	unwet
upby	11	3	906	2	upby
upbye	12	4	479	2	upbye
urb	5	57	3110	2	urb_
urbs	6	59	2205	2	urbs
urge	5	47	2241	2	urge
use	3	68	3516	2	u_se
ute	3	53	3588	2	u_te
vibe	9	51	2450	2	vibe

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	98	0.766	38997.4
3	Display Results	98	98	0.013	7538.5
	(SQL Overall)	178691	98	1.045	170996.2