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

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

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.

71 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
highfliers	20	5	182	(None)
highflier	19	4	228	1	highflier_
highflyers	23	5	144	1	highflyers
highflyer	22	5	164	2	highflyer_
higglers	13	29	723	3	hig_gl_ers
highlifes	19	4	288	3	high_lifes
sightlier	13	4	445	3	sightlier_
argufiers	13	4	161	4	arguf_iers
eighties	12	7	1080	4	eigh_tie_s
fighters	15	26	940	4	figh__ters
fireflies	15	4	535	4	fireflie_s
fliers	9	44	1719	4	____fliers
gigglers	11	29	740	4	gig_gl_ers
gigglier	11	5	432	4	gig_glier_
hagglers	13	32	662	4	hag_gl_ers
hauliers	11	7	671	4	h__auliers
higgler	12	36	980	4	hig_gl_er_
higgles	12	39	1180	4	hig_gl_e_s
highbinders	21	5	138	4	highbinders
highchairs	18	5	173	4	highchairs
higher	13	46	1089	4	high___er_
highlanders	19	5	202	4	highlanders
highlands	17	11	411	4	high_lands
highlife	18	4	300	4	high_li_fe
highlight	16	5	354	4	high_light
highlights	17	5	239	4	high_lights
highness	15	3	605	4	high__ness
highrises	16	4	463	4	high_rises
hightails	16	4	531	4	hightai_ls
hillers	10	37	1873	4	hi___llers
hillier	10	34	1396	4	hi__llier_
hoteliers	12	4	580	4	h_oteliers
inhalers	11	6	664	4	_inhal_ers
inholders	13	4	535	4	_inholders
inliers	7	31	1074	4	_i__nliers
jigglier	17	5	409	4	jig_glier_
lighteners	14	4	498	4	lighteners
lighters	12	31	1139	4	ligh__ters
lightless	13	8	607	4	lightl_ess
mightier	14	3	638	4	migh_tier_
milliers	10	26	1190	4	mi__lliers
nigglers	10	30	725	4	nig_gl_ers
nigglier	10	4	484	4	nig_glier_
nighties	12	10	1138	4	nigh_tie_s
nightless	13	8	607	4	nightl_ess
nightlifes	17	9	375	4	nightlifes
nightlives	17	6	380	4	nightlives
pistoliers	12	4	458	4	pistoliers
rifflers	14	33	644	4	ri_ffl_ers
riflers	10	35	1219	4	ri__fl_ers
righters	12	26	1071	4	righ__ters
righties	12	7	1157	4	righ_tie_s
sighers	11	37	1218	4	sigh___ers
sighless	12	7	655	4	sigh_l_ess
sighters	12	25	1060	4	sigh__ters
sightless	13	8	592	4	sightl_ess
sightliest	14	4	511	4	sightliest
sightlines	14	6	575	4	sightlines
sightliness	15	7	456	4	sightliness
sightseers	14	5	254	4	sightseers
signalers	10	4	458	4	signal_ers
signallers	11	4	284	4	signallers
signifiers	14	4	418	4	signifiers
tighteners	14	4	404	4	tighteners
tightwires	17	10	276	4	tightwires
vilifiers	15	4	456	4	vilif_iers
vivifiers	18	4	367	4	vivif_iers
whifflers	21	4	277	4	whi_ffl_ers
whiteflies	19	4	222	4	whiteflie_s
wigglers	13	25	721	4	wig_gl_ers
wigglier	13	5	445	4	wig_glier_

Search took 10 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	161450	0.436	409841.7
2	DLD Change Limit	161450	71	9.143	17658.3
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	9.609	18596.2