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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

206 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
afflicting	19	4	348	(None)
affecting	18	4	523	2	aff_ecting
affiliating	18	4	417	2	affiliating
affliction	18	4	354	2	affliction
afflictions	19	4	340	2	afflictions
afflictive	21	10	280	2	afflictive
affricating	20	4	396	2	affricating
inflicting	16	4	572	2	inflicting
addicting	14	8	507	3	a_ddicting
affirming	18	4	310	3	aff_irming
affixing	22	6	433	3	aff_i_xing
afflict	15	4	704	3	afflict___
afflicted	18	4	343	3	afflict_ed
afflicter	17	4	282	3	afflict_er
afflicters	18	5	224	3	afflicters
afflicts	16	4	400	3	afflict__s
affrighting	22	5	201	3	affrighting
affronting	17	4	260	3	affronting
airlifting	14	4	334	3	airlifting
astricting	13	5	783	3	astricting
conflicting	19	4	472	3	conflicting
deflecting	17	3	650	3	deflecting
effecting	18	4	558	3	eff_ecting
filiating	13	3	925	3	_filiating
flicking	18	41	1004	3	__flicking
flinting	12	34	1234	3	__flinting
flirting	12	31	901	3	__flirting
fliting	11	35	1461	3	__fli_ting
flitting	12	30	1088	3	__flitting
foliating	13	3	925	3	_foliating
inflecting	16	4	631	3	inflecting
mafficking	25	4	264	3	maff_icking
reflecting	16	3	882	3	reflecting
abdicating	16	8	615	4	a_bdicating
abducting	15	8	408	4	a_bducting
ablating	11	3	1200	4	a_bl_ating
abolishing	16	4	423	4	abolishing
abreacting	15	4	453	4	abreacting
abstricting	16	5	450	4	abstricting
acclimating	18	4	529	4	acclimating
acquitting	22	4	365	4	acquitting
acting	9	59	2098	4	a____cting
acylating	15	4	757	4	acyl_ating
adducting	14	9	430	4	a_dducting
admitting	13	4	503	4	a_dmitting
adulating	11	7	872	4	adul_ating
advecting	16	4	511	4	a_dvecting
affectingly	23	5	240	4	aff_ectingly
affection	17	4	589	4	aff_ection
affections	18	4	589	4	aff_ections
affective	20	13	541	4	aff_ective
affiancing	19	4	184	4	affiancing
affiliation	17	4	485	4	affiliation
affiliations	18	4	418	4	affiliations
afflictively	26	5	218	4	afflictively
affording	17	4	402	4	aff_ording
afforesting	18	5	285	4	afforesting
affraying	19	4	310	4	aff_raying
affricative	22	5	303	4	affricative
agisting	10	3	824	4	a__gisting
airting	8	36	1630	4	a___irting
alerting	9	13	1238	4	a__lerting
aliasing	9	3	1007	4	a__liasing
alibiing	11	3	532	4	a__libiing
aliening	9	15	1089	4	a__liening
alighting	14	4	641	4	a__lighting
aligning	10	15	853	4	a__ligning
alining	8	19	1704	4	a__li_ning
allicin	9	4	995	4	a_llic_in_
allicins	10	4	965	4	a_llic_ins
allocating	13	4	738	4	a_llocating
allotting	10	4	650	4	a_llotting
amplifying	21	4	412	4	amplifying
anglicising	15	10	225	4	anglicising
anglicizing	24	8	308	4	anglicizing
anointing	10	3	862	4	a_nointing
anticking	16	4	924	4	a_nticking
anticling	12	3	1069	4	a_nticling
appointing	15	4	532	4	appointing
arointing	10	4	936	4	a_rointing
articling	12	4	771	4	a_rticling
assisting	10	4	618	4	a_ssisting
attainting	11	4	478	4	attainting
attracting	13	4	656	4	attracting
attriting	10	4	869	4	attri_ting
attritting	11	4	476	4	attritting
auditing	10	3	903	4	a_udi_ting
auspicating	16	4	460	4	auspicating
aviating	12	3	1102	4	a__viating
awaiting	12	3	827	4	a_wai_ting
backlisting	20	4	387	4	backlisting
baffling	17	5	605	4	baffl___ing
befitting	15	23	662	4	bef_itting
beflecking	22	4	303	4	beflecking
clicking	17	36	1098	4	__clicking
collecting	15	4	828	4	collecting
convicting	18	4	758	4	convicting
curlicuing	15	4	213	4	curlicuing
defecting	16	25	1022	4	def_ecting
deflating	14	26	1071	4	defl_ating
defoliating	16	4	582	4	defoliating
delisting	11	27	1050	4	_delisting
depicting	15	3	781	4	_depicting
diffracting	21	4	335	4	diffracting
duplicating	17	4	540	4	duplicating
effacing	17	4	446	4	eff_ac_ing
electing	11	21	1378	4	__electing
eliciting	12	3	777	4	__eliciting
enlisting	10	3	834	4	_enlisting
evicting	14	3	748	4	__evicting
exfoliating	22	4	339	4	exfoliating
explicating	23	5	612	4	explicating
fabricating	19	4	503	4	fabricating
facelifting	20	5	212	4	facelifting
fainting	12	33	1216	4	__fainting
faulting	12	23	773	4	faul__ting
feinting	12	34	1083	4	__feinting
fellating	13	3	925	4	_fellating
felting	11	35	1521	4	_fel__ting
filching	17	3	611	4	_fil_ching
fileting	12	3	930	4	_fil_eting
filleting	13	3	585	4	_filleting
finicking	19	5	446	4	_finicking
fisting	11	38	1812	4	__f_isting
fitting	11	35	1656	4	__f_itting
flacking	18	43	1179	4	__flacking
flatting	12	35	1125	4	__flatting
flecking	18	40	823	4	__flecking
fleeting	12	29	1032	4	__fleeting
flighting	17	3	610	4	__flighting
flinching	18	24	583	4	__flinching
flinging	13	33	1005	4	__flinging
flipping	16	30	766	4	__flipping
flitching	18	26	534	4	__flitching
floating	12	31	1188	4	__floating
floccing	16	30	603	4	__floccing
flocking	18	34	1087	4	__flocking
flouting	12	26	1047	4	__flouting
fluting	11	38	1509	4	__fl_uting
flyting	14	37	855	4	__fl_yting
foisting	12	29	1050	4	__foisting
folioing	12	3	757	4	_foli_oing
fritting	12	35	1070	4	__fritting
frolicking	20	4	281	4	frolicking
fruiting	12	22	906	4	_frui_ting
garlicking	18	4	305	4	garlicking
glinting	10	32	1005	4	__glinting
graffiting	18	4	292	4	graff_i_ting
implicating	18	5	574	4	implicating
indicting	13	3	961	4	_indicting
infecting	15	10	967	4	inf_ecting
inflating	13	3	1044	4	infl_ating
infliction	15	4	594	4	infliction
inflictions	16	4	544	4	inflictions
inflictive	18	10	463	4	inflictive
infracting	16	4	735	4	infracting
lichting	14	26	851	4	___lichting
licking	14	41	1828	4	___licking
lifting	11	33	1327	4	___lifting
lilting	8	35	1538	4	___lilting
linting	8	38	2098	4	___linting
listing	8	40	2059	4	___listing
maledicting	17	5	272	4	maledicting
mulcting	13	24	698	4	_mul_cting
neglecting	14	4	454	4	neglecting
officering	19	4	214	4	off_icering
officiating	20	5	292	4	officiating
offloading	18	4	216	4	offloading
offprinting	20	5	211	4	offprinting
offsetting	17	4	233	4	offsetting
palliating	13	4	789	4	palliating
policing	13	3	1167	4	_polic_ing
predicting	16	4	987	4	predicting
prelecting	15	3	1016	4	prelecting
raffling	15	6	706	4	raffl___ing
reelecting	13	3	878	4	reelecting
refecting	15	24	1335	4	ref_ecting
refitting	13	28	1112	4	ref_itting
reflating	13	25	1471	4	refl_ating
refloating	14	19	832	4	refloating
refracting	16	3	873	4	refracting
relisting	10	24	1435	4	_relisting
relucting	12	3	977	4	_relucting
replicating	16	4	909	4	replicating
rollicking	17	4	293	4	rollicking
sealifting	14	4	463	4	sealifting
selecting	12	3	1053	4	_selecting
slicing	10	35	1464	4	__slic_ing
slicking	15	37	1259	4	__slicking
slitting	9	30	1258	4	__slitting
soliciting	13	4	681	4	_soliciting
splicing	13	3	896	4	_splic_ing
splinting	12	3	819	4	_splinting
splitting	12	3	656	4	_splitting
spoliating	13	6	696	4	spoliating
sufficing	18	4	488	4	suffic_ing
sufflating	17	4	484	4	suffl_ating
trafficking	24	5	178	4	traff_icking
unaffecting	20	5	216	4	unaff_ecting
unfitting	13	3	642	4	unf_itting
unflinching	20	5	169	4	unflinching
upflinging	17	4	229	4	upflinging
uplifting	15	3	496	4	_uplifting
vellicating	17	4	456	4	vellicating
waffling	18	4	542	4	waffl___ing
waitlisting	15	5	216	4	waitlisting

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.423	422437.4
2	DLD Change Limit	161450	206	9.280	17397.6
3	Display Results	206	206	0.110	1872.7
	(SQL Overall)	178691	206	9.813	18209.6