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

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

76 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
bafflements	21	8	345	(None)
bafflement	20	7	416	1	bafflement_
babblements	16	5	339	2	babblements
battlements	15	4	496	2	battlements
afferents	15	4	601	3	_aff_erents
affixments	25	4	307	3	_affixments
affluents	15	13	330	3	_affl_uents
babblement	15	5	413	3	babblement_
bailments	13	4	646	3	ba_il_ments
basements	13	4	826	3	ba__sements
battements	14	5	581	3	ba_ttements
battlement	14	4	609	3	battlement_
cajolements	22	5	416	3	cajolements
defilements	17	4	707	3	defilements
rabblements	17	5	364	3	rabblements
tanglements	14	5	474	3	tanglements
abasements	14	4	653	4	_abasements
abatements	14	4	635	4	_abatements
afferent	14	4	798	4	_aff_erent_
affirmants	18	5	276	4	_affirmants
affixment	24	4	388	4	_affixment_
affluent	14	9	455	4	_affl_uent_
agreements	13	4	549	4	_agreements
ailments	10	3	943	4	_a_il_ments
aliments	10	3	1109	4	_a__liments
alinements	12	4	713	4	_alinements
amazements	23	4	531	4	_amazements
amusements	14	4	623	4	_amusements
atonements	12	4	720	4	_atonements
bafflegabs	21	8	63	4	baffle_gabs
bafflers	16	35	659	4	baffl__e_rs
baffles	15	37	1068	4	baffl__e__s
bailment	12	4	918	4	ba_il_ment_
bakemeats	17	4	314	4	ba__kemeats
baleens	9	3	847	4	ba__le_en_s
banishments	18	6	429	4	banishments
basement	12	3	1149	4	ba__sement_
battement	13	5	777	4	ba_ttement_
battlemented	17	6	180	4	battlemented
bedazzlements	26	8	133	4	bedazzlements
befuddlements	22	6	120	4	befuddlements
beguilements	17	11	389	4	beguilements
bemusements	17	5	444	4	bemusements
bodements	14	4	761	4	b__odements
buffleheads	23	5	150	4	buffleheads
cajolement	21	5	523	4	cajolement_
casements	13	4	858	4	ca__sements
complements	19	4	818	4	complements
couplements	17	5	619	4	couplements
defacements	19	4	607	4	defacements
defilement	16	4	807	4	defilement_
definements	17	4	711	4	definements
easements	11	4	1033	4	ea__sements
effacements	21	5	487	4	effacements
efferents	15	4	533	4	_eff_erents
effluents	15	13	344	4	_effl_uents
elements	10	3	1217	4	___elements
embattlements	19	5	278	4	embattlements
emblements	16	4	779	4	_emblements
filaments	14	4	665	4	__filaments
habiliments	18	5	255	4	habiliments
impalements	17	4	643	4	impalements
implements	16	4	785	4	_implements
managements	16	5	531	4	managements
pavements	16	4	700	4	pa__vements
puzzlements	23	5	223	4	puzzlements
rabblement	16	5	445	4	rabblement_
ravagements	17	5	416	4	ravagements
ravelments	15	4	519	4	ravel_ments
refinements	16	4	679	4	refinements
revilements	16	4	713	4	revilements
settlements	13	4	554	4	settlements
startlements	14	5	339	4	startlements
supplements	17	5	459	4	supplements
tanglement	13	4	613	4	tanglement_
unfoldments	17	5	286	4	unfoldments

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.406	440125.6
2	DLD Change Limit	148819	76	9.000	16535.4
3	Display Results	76	76	0.033	2303.0
	(SQL Overall)	178691	76	9.439	18931.1