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

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

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.

59 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
undersurfaces	19	6	154	(None)
undersurface	18	6	167	1	undersurface_
hypersurfaces	26	6	167	3	hypersurfaces
hypersurface	25	6	166	4	hypersurface_
resurfaces	15	4	301	4	__re_surfaces
underprices	16	4	472	4	under_pr_ices
underrates	11	4	1056	4	under__r_ates
underreacts	14	5	302	4	under__reacts
understates	12	4	770	4	unders__tates
undersupplies	18	6	143	4	undersupplies
interfaces	15	4	1041	5	inte___rfaces
interspaces	15	4	615	5	inters__paces
resurface	14	4	327	5	__re_surface_
resurfaced	16	4	246	5	__re_surfaced
resurfacer	15	5	197	5	__re_surfacer
resurfacers	16	5	147	5	__re_surfacers
subsurfaces	18	5	203	5	__subsurfaces
surfaces	13	3	867	5	_____surfaces
undefaced	16	4	475	5	unde____faced
underacts	12	4	858	5	unde___r_acts
underages	11	8	1108	5	unde___r_ages
underbakes	17	4	636	5	unde___rbakes
underbrushes	18	5	220	5	under_brushes
undercarriages	18	6	124	5	undercarriages
undercurrents	16	9	202	5	undercurrents
underdrawers	17	5	171	5	under_dr_awers
underemphases	21	14	196	5	underemphases
underestimates	17	6	286	5	underestimates
underfurs	13	5	549	5	underfur____s
underglazes	22	4	390	5	under__glazes
undergrads	13	4	479	5	under_gr_a_ds
underprice	15	4	551	5	under_pr_ice_
underpriced	17	4	461	5	under_pr_iced
underrate	10	4	1189	5	under__r_ate_
underrated	12	3	1084	5	under__r_ated
underreact	13	4	468	5	under__reac_t
underreacted	16	5	360	5	under__reacted
undersaturated	16	6	249	5	undersatur_ated
underscores	14	4	537	5	unders__cores
underseas	10	8	780	5	unders__ea__s
underserved	16	4	463	5	underser__ved
undershrubs	17	10	213	5	undershr__ubs
undersides	12	4	869	5	unders___ides
understaffed	20	5	281	5	understaf_fed
understands	13	4	465	5	unders__tands
understate	11	4	886	5	unders__tate_
understated	13	4	783	5	unders__tated
understories	13	6	556	5	unders_tories
understrapper	18	6	199	5	understrapper
understrappers	19	6	142	5	understrappers
understudies	14	5	332	5	unders_tudies
undertakes	15	4	769	5	unde___rtakes
undertaxes	18	4	702	5	unde___rtaxes
undertricks	18	7	301	5	under_tr_icks
underuses	10	3	991	5	under_u___ses
underwires	14	4	702	5	underwir___es
underwrites	15	4	518	5	under_wr_ites
undesirables	15	5	331	5	unde_sirables
unpersuaded	15	5	246	5	unpersu__aded

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	124790	0.406	440125.6
2	DLD Change Limit	124790	59	8.170	15274.2
3	Display Results	59	59	0.046	1282.6
	(SQL Overall)	178691	59	8.622	20725.0