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

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

70 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
freelancers	16	5	235	(None)
freelancer	15	5	333	1	freelancer_
freelances	15	4	522	1	freelance_s
freelance	14	4	514	2	freelance__
freelanced	16	4	327	2	freelance_d
freebasers	15	4	300	3	freeba_sers
freelancing	17	4	224	3	freelancing
freeloaders	15	6	218	3	freeloaders
precancers	16	4	525	3	pr_ecancers
replacers	13	26	683	3	_repla_cers
balancers	13	4	506	4	__balancers
enhancers	14	4	510	4	__enhancers
feasances	14	4	540	4	f_easance_s
feelers	10	38	1474	4	f_eel___ers
fencers	12	38	1062	4	f__e__ncers
fireplaces	17	4	434	4	firepla_ce_s
flangers	12	33	1137	4	f___langers
flankers	15	34	930	4	f___lankers
flatlanders	15	5	198	4	flatlanders
fleecers	13	32	593	4	flee___cers
fragrances	16	4	388	4	fragrance_s
frankers	15	34	835	4	fr___ankers
freebaser	14	4	368	4	freeba_ser_
freebases	14	4	493	4	freeba_se_s
freebooters	16	5	205	4	freebooters
freehanded	18	4	340	4	freehande_d
freeholders	18	5	285	4	freeholders
freeloader	14	5	261	4	freeloader_
freeness	11	7	1044	4	free__n_ess
freestylers	17	5	139	4	freestylers
freethinkers	22	5	119	4	freethinkers
freewares	15	4	594	4	freewa_re_s
freezers	20	30	717	4	free___zers
frequences	24	4	493	4	frequence_s
frequenters	23	5	264	4	frequenters
fresheners	16	4	386	4	freshen_ers
geomancers	15	4	295	4	_geomancers
glancers	11	40	800	4	___glancers
grievances	16	4	322	4	grievance_s
lancers	9	36	1664	4	____lancers
prancers	12	32	1033	4	pr___ancers
precancels	16	4	406	4	pr_ecancels
precancer	15	4	709	4	pr_ecancer_
preeners	10	27	1281	4	pree__n_ers
prefacers	16	3	629	4	pr_efa_cers
preplaces	15	7	875	4	prepla_ce_s
rebalances	14	4	525	4	_rebalance_s
recanters	11	23	1048	4	_r_ecanters
reclaimers	14	4	359	4	_reclaimers
recliners	11	27	911	4	_reclin_ers
redliners	10	26	785	4	_redlin_ers
reelers	7	35	2027	4	_reel___ers
reenters	8	29	1530	4	_ree__nters
relaces	9	34	2088	4	_r_ela_ce_s
relapsers	11	6	412	4	_r_elapsers
relaters	8	32	1815	4	_r_ela_ters
relaunders	11	5	310	4	_r_elaunders
relaxers	15	29	826	4	_r_ela_xers
releasers	9	3	732	4	_relea_sers
relevances	15	9	611	4	_relevance_s
reliances	11	3	962	4	_reliance_s
renouncers	12	4	462	4	_renouncers
replacer	12	27	974	4	_repla_cer_
replaces	12	31	1412	4	_repla_ce_s
replasters	12	4	553	4	_replasters
retracers	11	14	955	4	_retra_cers
reverencers	16	7	332	4	_reverencers
romancers	13	4	573	4	_r_omancers
ropedancers	16	10	174	4	ropedancers
trepanners	12	4	308	4	tr_epanners

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	148819	0.420	425454.8
2	DLD Change Limit	148819	70	9.033	16475.0
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	9.483	18843.3