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

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

85 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
busload	10	4	468	(None)
busloads	11	4	415	1	busloads
unload	7	30	1080	2	_unload
upload	9	25	778	2	_upload
armload	10	4	429	3	armload
backload	17	4	683	3	backload
ballad	9	43	1532	3	b_allad
bausond	10	4	449	3	baus_ond
beblood	12	10	608	3	beblood
becloak	15	4	504	3	becloak
becloud	12	4	629	3	becloud
beglad	10	13	846	3	begl_ad
bestead	10	38	912	3	bestead
bloat	7	52	2992	3	b__loat
blond	8	56	1837	3	b__lond
blood	8	53	1952	3	b__lood
boatload	11	4	340	3	boatload
bombload	15	4	314	3	bombload
broad	8	48	1769	3	b__road
buboed	11	30	1000	3	bu_boed
bugled	10	49	1813	3	bugl_ed
bugloss	10	3	589	3	bugloss
build	8	44	1335	3	buil__d
builded	11	3	647	3	builded
bulbar	10	3	958	3	bu_lbar
bulbed	11	43	1277	3	bu_lbed
bulged	10	51	1712	3	bu_lged
bulked	13	42	1674	3	bu_lked
bulla	7	46	2056	3	bu_lla_
bullae	8	34	1616	3	bu_llae
bullbat	11	5	855	3	bullbat
bulled	9	46	2649	3	bu_lled
bullhead	14	6	478	3	bullhead
bullied	10	45	1481	3	bullied
bullock	15	3	719	3	bullock
bullous	9	3	1166	3	bullous
bumboat	13	4	902	3	bumboat
buncoed	12	37	844	3	buncoed
bunkoed	14	35	666	3	bunkoed
burlap	10	9	835	3	burl_ap
burled	9	48	2538	3	burl_ed
busbar	10	3	845	3	bus_bar
busboy	13	30	744	3	busbo_y
busboys	14	32	502	3	busboys
bused	8	56	2449	3	bus__ed
bushed	12	48	2238	3	bus_hed
bushgoat	14	4	344	3	bushgoat
bushland	14	4	419	3	bushland
bushman	14	5	569	3	bushman
bushwa	14	10	514	3	bushwa_
bushwah	18	12	398	3	bushwah
bushwas	15	10	561	3	bushwas
busied	9	51	1722	3	bus_ied
busked	13	49	1770	3	bus_ked
busman	10	3	1025	3	bus_man
bussed	9	47	1705	3	bus_sed
bustard	10	38	972	3	bustard
busted	9	51	2315	3	bus_ted
bustled	10	40	1152	3	bustled
busulfan	13	4	162	3	busulfan
butled	9	48	1860	3	butl_ed
byroad	12	3	662	3	b_yroad
carload	10	3	978	3	carload
caseload	11	4	562	3	caseload
euploid	10	3	896	3	euploid
hulloa	9	50	1118	3	hulloa_
hulloaed	12	10	580	3	hulloaed
hulloas	10	39	1191	3	hulloas
hulloed	11	36	979	3	hulloed
load	5	67	3060	3	___load
mislead	10	41	997	3	mislead
offload	14	4	320	3	offload
onload	7	26	863	3	_onload
outlead	8	33	1110	3	outlead
payload	13	3	640	3	payload
preload	10	4	981	3	preload
reload	7	4	1389	3	_reload
sloid	6	46	1971	3	__sloid
slojd	13	37	884	3	__slojd
sloyd	9	40	968	3	__sloyd
ulnad	6	56	1145	3	_u_lnad
unlead	7	33	1237	3	_unlead
unloads	8	27	852	3	_unloads
uploads	10	26	650	3	_uploads
vanload	11	4	470	3	vanload

Search took 8 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	134027	0.406	440125.6
2	DLD Change Limit	134027	85	6.923	19359.7
3	Display Results	85	85	0.030	2833.3
	(SQL Overall)	178691	85	7.359	24282.0