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

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

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.

89 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
affixers	21	4	329	(None)
affixer	20	3	391	1	affixer_
affixes	20	3	550	1	affixe_s
affines	13	3	948	2	affine_s
affirmers	17	4	256	2	affirmers
affixed	21	3	412	2	affixe_d
fixers	16	51	1298	2	__fixers
officers	16	4	380	2	officers
abiders	10	40	1108	3	a_biders
admirers	11	3	471	3	admirers
admixes	17	6	596	3	admixe_s
advisers	12	13	500	3	advisers
affaires	14	4	430	3	affaire_s
affairs	13	3	416	3	aff_airs
affecters	17	6	393	3	affecters
affiants	14	4	523	3	affiants
affiches	19	4	523	3	affiches
affine	12	3	1050	3	affine__
affined	14	3	641	3	affine_d
affinely	17	4	386	3	affinely
affirm	14	3	552	3	affi__rm
affirmer	16	4	308	3	affirmer_
affirms	15	3	438	3	affi_rms
affix	18	3	600	3	affix___
affixal	20	4	376	3	affix_al
affixial	21	4	359	3	affixial
affixing	22	6	433	3	affixing
affixment	24	4	388	3	affixment
affixments	25	4	307	3	affixments
affixture	22	5	181	3	affixture
affixtures	23	5	178	3	affixtures
afflicters	18	5	224	3	afflicters
affluxes	21	4	253	3	affluxe_s
affrayers	18	4	221	3	affrayers
afters	9	47	1707	3	a_f_ters
aiders	7	45	2463	3	a__iders
aimers	8	46	2191	3	a__imers
airers	6	49	2231	3	a__irers
aivers	9	48	2232	3	a__ivers
aliners	7	47	1772	3	a_liners
aquifers	20	4	439	3	aquifers
arbiters	10	3	885	3	arbiters
armigers	11	3	570	3	armigers
arrivers	11	13	700	3	arrivers
aspirers	10	6	649	3	aspirers
avoiders	12	5	479	3	avoiders
awaiters	11	4	664	3	awaiters
baffies	15	36	1294	3	baffi_e_s
bafflers	16	35	659	3	baff_lers
daffier	14	5	783	3	daffi_er_
daffiness	16	3	484	3	daffiness
defiers	11	39	1399	3	defi_ers
defilers	12	43	947	3	defilers
definers	12	42	1119	3	definers
effacers	16	24	423	3	effacers
fibers	11	47	1752	3	__fibers
fifers	12	54	1492	3	__fifers
filers	9	46	2372	3	__filers
firers	9	49	2268	3	__firers
fivers	12	44	2092	3	__fivers
fixer	15	47	1783	3	__fixer_
fixes	15	47	2359	3	__fixe_s
fliers	9	44	1719	3	_fli_ers
friers	9	47	1893	3	_fri_ers
frizers	19	32	955	3	_frizers
gaffers	14	42	871	3	gaff__ers
iffier	12	3	676	3	iffi_er_
iffiness	14	3	502	3	iffiness
infixes	17	23	813	3	infixe_s
kaffirs	17	32	555	3	kaffi__rs
kaffiyehs	25	8	125	3	kaffiyehs
maffickers	24	4	196	3	maffickers
mixers	15	45	1356	3	__mixers
offerers	14	3	493	3	offerers
offers	12	34	996	3	off__ers
officer	15	3	421	3	officer_
offices	15	3	624	3	office_s
rafflers	14	31	736	3	raff_lers
reaffixes	22	4	302	3	reaffixe_s
refiners	11	47	1331	3	refiners
refixes	17	48	1317	3	refixe_s
sufficers	17	20	453	3	sufficers
suffixes	21	19	635	3	suffixe_s
taffies	13	30	1269	3	taffi_e_s
unfixes	17	23	811	3	unfixe_s
waffies	16	36	1144	3	waffi_e_s
wafflers	17	30	632	3	waff_lers
zaffers	22	38	677	3	zaff__ers
zaffirs	22	37	566	3	zaffi__rs

Search took 7 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	146162	0.156	1145455.1
2	DLD Change Limit	146162	89	6.796	21507.1
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	6.982	25593.1