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

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

90 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
bomber	12	50	1465	(None)
bobber	9	50	1674	1	bobber
bombe	11	55	1931	1	bombe_
bombed	13	41	1387	1	bombed
bombers	13	45	1259	1	bombers
bombes	12	49	1682	1	bombes
comber	12	51	1850	1	comber
omber	9	53	1644	1	_omber
somber	10	37	1400	1	somber
amber	9	45	2321	2	_amber
barber	10	44	1932	2	barber
bibber	9	46	1357	2	bibber
boater	8	46	2209	2	boater
bobbed	10	43	1583	2	bobbed
bobbers	10	36	1428	2	bobbers
bobbery	13	43	835	2	bobbery
boiler	8	43	1927	2	boiler
bolder	9	48	2093	2	bolder
bolter	8	39	2075	2	bolter
bomb	10	69	2742	2	bomb__
bombard	14	3	733	2	bombard
bombax	19	3	575	2	bombax
bomblet	13	4	1226	2	bomblet
bombs	11	58	1882	2	bomb_s
bombyx	22	3	269	2	bombyx
bonder	9	53	2478	2	bonder
boner	7	51	3308	2	bo_ner
bonier	8	43	2199	2	bonier
bonzer	17	53	1367	2	bonzer
boobed	11	45	1487	2	boobed
booger	9	48	1655	2	booger
booker	12	47	1919	2	booker
boomer	10	46	1851	2	boomer
boomier	11	33	1218	2	boomier
boozer	17	48	1596	2	boozer
bopper	12	38	1383	2	bopper
border	9	44	1997	2	border
borer	7	51	3127	2	bo_rer
bosker	12	38	1365	2	bosker
bother	11	52	1806	2	bother
bower	10	73	2818	2	bo_wer
bowler	11	42	1731	2	bowler
bowyer	14	36	892	2	bowyer
boxer	14	50	1652	2	bo_xer
boxier	15	43	1174	2	boxier
briber	10	47	1405	2	briber
bumbler	13	40	1323	2	bumbler
bummer	12	40	1410	2	bummer
bumper	12	37	1434	2	bumper
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
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
sobber	10	40	1659	2	sobber
sober	7	48	2241	2	so_ber
sombre	10	72	947	2	sombre
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 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	82551	0.343	520965.0
2	DLD Change Limit	82551	90	2.203	37472.1
3	Display Results	90	90	0.016	5625.0
	(SQL Overall)	178691	90	2.562	69746.7