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

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

88 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
somber	10	37	1400	(None)
bomber	12	50	1465	1	bomber
comber	12	51	1850	1	comber
omber	9	53	1644	1	_omber
sobber	10	40	1659	1	sobber
sober	7	48	2241	1	so_ber
sombre	10	72	947	1	sombre
amber	9	45	2321	2	_amber
bobber	9	50	1674	2	bobber
bombe	11	55	1931	2	bombe_
bombed	13	41	1387	2	bombed
bombers	13	45	1259	2	bombers
bombes	12	49	1682	2	bombes
camber	12	44	1848	2	camber
cobber	12	41	1684	2	cobber
combe	11	62	2354	2	combe_
combed	13	55	1654	2	combed
combers	13	45	1662	2	combers
combes	12	53	2173	2	combes
comer	9	58	3269	2	com_er
cumber	12	40	1670	2	cumber
dobber	11	40	1542	2	dobber
dumber	11	44	1417	2	dumber
ember	9	55	1680	2	_ember
gomer	8	52	2065	2	gom_er
goober	9	39	1174	2	goober
hobber	13	41	1463	2	hobber
hombre	13	30	930	2	hombre
homer	10	58	2845	2	hom_er
homier	11	64	1699	2	homier
isomer	8	3	1015	2	isom_er
jobber	17	38	1335	2	jobber
lamber	10	44	1849	2	lamber
limber	10	43	1679	2	limber
lobber	10	40	1660	2	lobber
lumber	10	38	1777	2	lumber
member	12	25	885	2	member
mobber	12	36	1346	2	mobber
momser	10	40	1141	2	momser
momzer	19	32	755	2	momzer
number	10	39	1322	2	number
ombers	10	42	1440	2	_ombers
ombre	9	41	1180	2	_ombre
omer	6	70	2839	2	_om_er
robber	10	39	1653	2	robber
romper	10	42	1368	2	romper
saber	7	53	3024	2	s_aber
sambar	10	39	1416	2	sambar
sambur	10	46	950	2	sambur
simmer	10	41	1535	2	simmer
simper	10	36	1629	2	simper
slobber	11	38	890	2	slobber
slumber	11	38	1100	2	slumber
smoker	12	43	1169	2	smoker
soaker	10	57	1753	2	soaker
soaper	8	45	1787	2	soaper
soarer	6	45	2224	2	soarer
sobbed	11	35	1626	2	sobbed
sobbers	11	41	1426	2	sobbers
sobers	8	52	1886	2	so_bers
soccer	10	3	854	2	soccer
soever	9	44	1209	2	soever
softer	9	40	1531	2	softer
solder	7	39	2134	2	solder
solver	9	40	1670	2	solver
somberly	15	4	405	2	somberly
sombrero	12	4	258	2	sombrero
some	6	60	4038	2	som_e_
sonder	7	36	2352	2	sonder
sooner	6	42	2046	2	sooner
sorbed	9	49	1652	2	sorbed
sorbet	8	39	2408	2	sorbet
sorer	5	62	3659	2	so_rer
sorner	6	47	2039	2	sorner
sorter	6	44	2509	2	sorter
sourer	6	36	2021	2	sourer
souter	6	42	2592	2	souter
sower	8	52	2931	2	so_wer
stomper	11	41	1123	2	stomper
suber	7	49	2450	2	s_uber
summer	10	40	1771	2	summer
swobber	14	33	654	2	swobber
timber	10	40	1268	2	timber
tombed	11	38	1213	2	tombed
umber	9	46	1759	2	_umber
vomer	10	55	1738	2	vom_er
wombed	14	41	923	2	wombed
wombier	14	3	654	2	wombier

Search took 4 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	82551	0.376	475242.0
2	DLD Change Limit	82551	88	2.813	29346.2
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	3.219	55511.3