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

Here are the results of your fuzzy-string dictionary search for “hundreds” 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
hundreds	13	4	400	(None)
hundred	12	3	714	1	hundred_
hundredth	17	5	148	2	hundredth
hundredths	18	5	112	2	hundredths
huntress	11	4	483	2	huntress
kindreds	14	27	401	2	kindreds
sundress	9	3	698	2	sundress
undress	8	3	889	2	_undress
bundled	11	40	1130	3	bundled_
bundlers	11	39	918	3	bundlers
bundles	10	35	1577	3	bundle_s
funded	11	44	1389	3	fund_ed_
funders	11	38	1393	3	fund_ers
handed	11	49	1998	3	hand_ed_
handers	11	42	2433	3	hand_ers
handhelds	17	4	376	3	handhelds
handled	12	41	1453	3	handled_
handlers	12	40	1414	3	handlers
handles	11	40	2065	3	handle_s
handless	12	35	1206	3	handless
handpress	15	4	403	3	handpress
handsels	12	31	725	3	handsels
handsets	12	25	834	3	handsets
hatreds	11	30	781	3	h_atreds
hindered	13	3	945	3	hindered_
hinderers	13	3	735	3	hinderers
hinders	11	37	1850	3	hind_ers
hondled	12	35	1065	3	hondled_
hondles	11	36	1452	3	hondle_s
honored	11	3	1012	3	honored_
honorees	11	4	878	3	honorees
honorers	11	3	927	3	honorers
hounded	12	33	1103	3	hound_ed_
hounders	12	31	1171	3	hound_ers
huddled	13	34	978	3	huddled_
huddlers	13	33	763	3	huddlers
huddles	12	37	1257	3	huddle_s
humdrums	16	4	270	3	humdrums
humored	13	3	672	3	humored_
hunched	16	37	1049	3	hunched_
hunches	15	39	1346	3	hunche_s
hungered	13	21	705	3	hungered_
hungers	11	40	1330	3	hun_gers
hunkered	16	18	692	3	hunkered_
hunkers	14	33	1433	3	hun_kers
hunkeys	17	38	619	3	hun_keys
hunkies	14	32	1450	3	hunkie_s
hunted	10	44	1701	3	hun_ted_
hunters	10	39	1573	3	hun_ters
hurdies	11	40	1566	3	hurdie_s
hurdled	12	37	983	3	hurdled_
hurdlers	12	33	749	3	hurdlers
hurdles	11	36	1337	3	hurdle_s
hurds	9	52	1907	3	hu__r_ds
hydrids	15	26	723	3	h_ydrids
inbreds	10	24	573	3	_inbreds
kindred	13	31	695	3	kindred_
laundress	10	4	281	3	laundress
mandrels	11	3	731	3	mandrels
outdress	9	13	732	3	outdress
rundles	8	32	1471	3	rundle_s
rundlets	9	30	736	3	rundlets
sundaes	8	3	1309	3	sundae_s
sundered	10	3	1215	3	sundered_
sunderers	10	3	907	3	sunderers
sunders	8	41	2005	3	sund_ers
sundews	11	39	815	3	sund_ews
sundries	9	3	1202	3	sundries
sundrops	11	4	582	3	sundrops
thundered	14	4	457	3	thundered_
thunderers	14	4	397	3	thunderers
thunders	12	3	695	3	thund_ers
tundras	8	5	711	3	tundr_as
unbred	9	26	1330	3	_unbred_
underdo	9	3	736	3	_underdo
undies	7	38	2196	3	_undie_s
undoers	8	29	1058	3	_undoers
undoes	7	39	1740	3	_undoe_s
undraws	11	3	689	3	_undraws
undrest	8	3	1301	3	_undrest
undrew	10	3	791	3	_undre_w
undried	9	23	1461	3	_undried_
undyed	11	3	814	3	_undyed_
unfrees	10	4	864	3	_unfrees
untreads	9	3	622	3	_untreads

Search took 7 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.423	422437.4
2	DLD Change Limit	146162	85	6.360	22981.4
3	Display Results	85	85	0.046	1847.8
	(SQL Overall)	178691	85	6.829	26166.5