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

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

68 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
backfitting	23	5	307	(None)
backbiting	21	4	429	2	backbi_ting
backfilling	23	5	261	2	backfilling
backfiring	22	4	380	2	backfi_ring
backlisting	20	4	386	2	backlisting
acquitting	22	4	365	3	_acquitting
babbitting	14	4	300	3	ba_bbitting
babysitting	19	5	161	3	babysitting
backbitings	22	5	233	3	backbi_tings
backbitten	20	5	289	3	backbitten_
backdating	20	4	571	3	back_dating
backfitted	22	5	325	3	backfitt_ed
backflipping	28	6	145	3	backflipping
backlighting	25	5	247	3	backlighting
befitting	15	23	662	3	b__efitting
benefitting	17	5	285	3	benefitting
blacklisting	21	5	223	3	blacklisting
admitting	13	4	503	4	_a_dmitting
attritting	11	4	476	4	_attritting
backfit	18	10	821	4	backfi_t___
backfits	19	10	695	4	backfi_t__s
backhanding	24	5	376	4	backhanding
backhauling	23	5	281	4	backhauling
backhoeing	22	4	340	4	back_hoeing
backing	16	55	2344	4	back____ing
backlashing	23	5	343	4	backlashing
backloading	21	5	381	4	backloading
backlogging	22	5	262	4	backlogging
backpacking	23	5	332	4	backpacking
backsliding	21	5	320	4	backsliding
backspacing	24	5	294	4	backspacing
backstitching	27	7	153	4	backstitching
backswing	21	4	490	4	back__swing
backwashing	26	5	309	4	backwashing
baiting	10	39	1888	4	ba___i_ting
bankrupting	20	5	175	4	bankrupting
bassetting	13	4	463	4	ba_ssetting
batting	10	44	2227	4	ba____tting
bayonetting	17	5	163	4	bayonetting
beknotting	17	8	281	4	b_eknotting
benefiting	16	4	431	4	benefi_ting
bitting	10	37	1729	4	b____itting
blackbirding	24	5	200	4	blackbirding
blacksmithing	27	6	163	4	blacksmithing
brachiating	19	4	443	4	brac_hiating
bracketing	19	4	523	4	brack__eting
bucketing	18	3	571	4	buck__eting
cockfighting	28	5	134	4	cockfighting
facelifting	20	5	211	4	facelifting
facetting	15	3	528	4	fac__etting
facilitating	18	5	400	4	facilitating
fitting	11	35	1656	4	____fitting
formfitting	20	5	189	4	formfitting
jacketing	23	4	564	4	jack__eting
jacklighting	30	5	172	4	jacklighting
kitting	12	32	1444	4	___k_itting
knitting	13	25	702	4	___knitting
manumitting	16	5	247	4	manumitting
misfitting	16	4	553	4	_misfitting
outfitting	14	6	582	4	_outfitting
pacesetting	16	5	263	4	pacesetting
packeting	18	3	685	4	pack__eting
racketing	16	4	787	4	rack__eting
refitting	13	28	1112	4	__refitting
reknitting	15	8	499	4	_reknitting
tackifying	23	4	380	4	tack_ifying
unfitting	13	3	642	4	__unfitting
unknitting	15	4	287	4	_unknitting

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	148819	0.486	367677.0
2	DLD Change Limit	148819	68	7.783	19121.0
3	Display Results	68	68	0.030	2266.7
	(SQL Overall)	178691	68	8.299	21531.6