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

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

73 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
bombers	13	45	1259	(None)
bobbers	10	36	1428	1	bobbers
bomber	12	50	1465	1	bomber_
bombes	12	49	1682	1	bombe_s
combers	13	45	1662	1	combers
ombers	10	42	1440	1	_ombers
ambers	10	45	1958	2	_ambers
barbers	11	43	1750	2	barbers
bibbers	10	39	1135	2	bibbers
boaters	9	34	1924	2	boaters
bobber	9	50	1674	2	bobber_
bobbery	13	43	835	2	bobbery
boilers	9	34	1706	2	boilers
bolters	9	40	1780	2	bolters
bombard	14	3	733	2	bombard
bombards	15	3	649	2	bombards
bombe	11	55	1931	2	bombe__
bombed	13	41	1387	2	bombe_d
bomblets	14	3	602	2	bomblets
bombs	11	58	1882	2	bomb__s
bonders	10	41	2066	2	bonders
boners	8	48	2543	2	bo_ners
bonkers	13	40	1530	2	bonkers
boogers	10	45	1463	2	boogers
bookers	13	40	1661	2	bookers
boomers	11	41	1591	2	boomers
boozers	18	39	1244	2	boozers
boppers	13	39	1192	2	boppers
borders	10	43	1753	2	borders
borers	8	51	2268	2	bo_rers
bothers	12	43	1775	2	bothers
bowers	11	55	2370	2	bo_wers
bowlers	12	37	1578	2	bowlers
bowyers	15	43	873	2	bowyers
boxers	15	50	1348	2	bo_xers
bribers	11	41	1150	2	bribers
bumblers	14	37	1073	2	bumblers
bummers	13	37	1244	2	bummers
bumpers	13	39	1205	2	bumpers
cambers	13	40	1744	2	cambers
cobbers	13	41	1475	2	cobbers
comber	12	51	1850	2	comber_
combes	12	53	2173	2	combe_s
comers	10	53	2808	2	com_ers
cumbers	13	45	1541	2	cumbers
dobbers	12	35	1325	2	dobbers
embers	10	41	1618	2	_embers
gomers	9	41	1688	2	gom_ers
goobers	10	21	962	2	goobers
hobbers	14	35	1234	2	hobbers
hombres	14	36	988	2	hombres
homers	11	48	2198	2	hom_ers
jobbers	18	29	1113	2	jobbers
lambers	11	38	1711	2	lambers
limbers	11	36	1474	2	limbers
lobbers	11	37	1394	2	lobbers
lumbers	11	38	1591	2	lumbers
members	13	25	860	2	members
mobbers	13	36	1092	2	mobbers
momsers	11	38	1085	2	momsers
momzers	20	36	713	2	momzers
numbers	11	37	1124	2	numbers
omber	9	53	1644	2	_omber_
ombres	10	39	1114	2	_ombres
omers	7	69	2319	2	_om_ers
robbers	11	28	1416	2	robbers
rompers	11	34	1224	2	rompers
sobbers	11	41	1426	2	sobbers
sobers	8	52	1886	2	so_bers
somber	10	37	1400	2	somber_
timbers	11	31	1185	2	timbers
umbers	10	42	1521	2	_umbers
vomers	11	56	1494	2	vom_ers

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	107671	0.393	454684.5
2	DLD Change Limit	107671	73	3.356	32083.1
3	Display Results	73	73	0.033	2212.1
	(SQL Overall)	178691	73	3.782	47247.8