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

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

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.

68 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
bulldogs	12	7	424	(None)
bulldog	11	7	425	1	bulldog_
bulldoze	20	4	305	2	bulldoze
bulldozes	21	4	305	2	bulldozes
bullfrogs	15	4	232	2	bullfrogs
bullions	10	17	1004	2	bullions
bullous	9	3	1166	2	bull_ous
ballons	9	39	1696	3	ball_ons
balloons	10	31	1052	3	balloons
ballots	9	41	1603	3	ball_ots
bandogs	11	3	836	3	b_andogs
beclogs	12	3	707	3	becl_ogs
bellboys	15	4	452	3	bellboys
bellhops	15	4	487	3	bellhops
bellings	11	38	1115	3	bellings
bellows	12	43	1330	3	bell_ows
billbugs	13	4	270	3	billbugs
billings	11	34	1263	3	billings
billions	10	22	1179	3	billions
billons	9	30	1336	3	bill_ons
billows	12	36	1129	3	bill_ows
birddogs	13	8	243	3	birddogs
blogs	8	53	1923	3	b__l_ogs
bugloss	10	3	589	3	bugl_oss
builders	11	4	674	3	builders
buildings	13	3	425	3	buildings
builds	9	37	849	3	build__s
buildups	13	4	203	3	buildups
bulbous	11	3	829	3	bu_lbous
bullaces	12	29	943	3	bullaces
bullbats	12	5	589	3	bullbats
bulldogged	16	5	175	3	bulldogged
bulldogger	15	5	192	3	bulldogger
bulldoggers	16	5	161	3	bulldoggers
bulldozed	22	4	223	3	bulldozed
bulldozer	21	5	241	3	bulldozer
bulldozers	22	5	203	3	bulldozers
bulldyke	18	4	195	3	bulldyke
bulldykes	19	4	191	3	bulldykes
bullets	9	35	1639	3	bull_ets
bullfrog	14	4	236	3	bullfrog_
bullhorn	13	4	446	3	bullhorn
bullhorns	14	4	396	3	bullhorns
bullies	9	41	2189	3	bull_ies
bulling	10	43	2479	3	bulling_
bullion	9	19	1103	3	bullio_n
bullnose	10	4	455	3	bullnose
bullnoses	11	4	470	3	bullnoses
bullock	15	3	719	3	bull_ock
bullocks	16	3	629	3	bullocks
bullpens	12	5	408	3	bullpens
bullpout	12	4	578	3	bullpout
bullpouts	13	4	319	3	bullpouts
bullrings	12	31	462	3	bullrings
bulls	7	56	2957	3	bull___s
bullshots	14	4	317	3	bullshots
bullyboys	19	4	226	3	bullyboys
bullyrags	15	4	280	3	bullyrags
cullions	10	21	922	3	cullions
duologs	9	3	536	3	duol_ogs
gundogs	10	3	460	3	gu_ndogs
hulloas	10	39	1191	3	hull_oas
hulloes	10	41	1392	3	hull_oes
hulloos	10	40	1007	3	hull_oos
hullos	9	49	1629	3	hull_o_s
mullions	10	19	1035	3	mullions
putlogs	10	6	508	3	putl_ogs
sundogs	9	4	710	3	su_ndogs

Search took 9 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	146162	0.453	394461.4
2	DLD Change Limit	146162	68	7.686	19016.7
3	Display Results	68	68	0.030	2266.7
	(SQL Overall)	178691	68	8.169	21874.3