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

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

156 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
affronting	17	4	260	(None)
fronting	12	3	1044	2	__fronting
refronting	14	3	727	2	refronting
affecting	18	4	523	3	aff_ecting
affiancing	19	4	184	3	affiancing
afflicting	19	4	348	3	afflicting
affording	17	4	402	3	aff_ording
afforesting	18	5	285	3	afforesting
affraying	19	4	310	3	affr_aying
affricating	20	4	396	3	affricating
affrighting	22	5	201	3	affrighting
affront	13	5	796	3	affront___
affronted	16	4	250	3	affront_ed
affronts	14	4	416	3	affront__s
aproning	11	3	1179	3	a_pron_ing
arointing	10	4	936	3	a__rointing
aroynting	13	4	463	3	a__roynting
confronting	17	4	486	3	confronting
defrosting	15	4	449	3	defrosting
frosting	12	3	1118	3	__frosting
offprinting	20	5	211	3	offprinting
aborning	11	8	800	4	abor_n_ing
aborting	11	7	1025	4	a__borting
abrogating	14	9	798	4	a_brogating
absconding	16	4	299	4	absconding
absenting	12	3	699	4	a_bsenting
accenting	14	8	782	4	a_ccenting
accosting	14	4	673	4	a_ccosting
accounting	15	4	492	4	accounting
accreting	14	4	633	4	accr_eting
acerbating	15	4	628	4	acerbating
adopting	12	3	745	4	a__dopting
adorning	10	8	732	4	ador_n_ing
aerating	9	28	2100	4	a_er_ating
affiliating	18	4	416	4	affiliating
affirming	18	4	310	4	aff_irming
affixing	22	6	433	4	aff__ixing
agenting	10	3	938	4	a__genting
airting	8	36	1630	4	a_ir__ting
alerting	9	13	1238	4	aler__ting
alimenting	13	4	450	4	alimenting
allotting	10	4	650	4	a_llotting
amounting	12	3	664	4	a_mounting
anointing	10	3	862	4	a_nointing
anting	7	58	2702	4	a____nting
appointing	15	4	532	4	appointing
approbating	18	4	458	4	approbating
approving	17	4	505	4	appro_ving
arousing	9	38	1180	4	a__rousing
arranging	11	5	630	4	a_rranging
arresting	10	3	863	4	a_rresting
arrogating	12	177	839	4	a_rrogating
arrowing	12	3	794	4	a_rro_wing
assenting	10	3	816	4	a_ssenting
assorting	10	3	730	4	a_ssorting
astonying	13	4	523	4	a_stonying
astricting	13	5	783	4	astricting
astringing	12	4	577	4	astringing
atoning	8	35	1487	4	a__ton_ing
attainting	11	4	478	4	attainting
attorning	10	4	550	4	attorn_ing
attracting	13	4	656	4	attracting
attriting	10	4	868	4	attr_iting
attritting	11	4	476	4	attritting
augmenting	14	4	385	4	augmenting
averting	12	25	1273	4	aver__ting
befretting	16	4	479	4	befretting
befringing	17	4	406	4	befringing
bronzing	20	3	769	4	__bronzing
coronating	13	4	1017	4	_coronating
defrocking	21	4	315	4	defrocking
diffracting	21	4	334	4	diffracting
disrooting	12	4	774	4	disrooting
droning	9	30	1372	4	__dron_ing
effecting	18	4	558	4	eff_ecting
effrontery	19	5	91	4	effrontery
enrooting	10	12	813	4	_enrooting
faggoting	15	4	331	4	faggo_ting
fagoting	13	3	628	4	_fago_ting
fainting	12	33	1216	4	__fainting
farrowing	16	4	587	4	farro_wing
farting	11	41	2075	4	_far__ting
feinting	12	34	1083	4	__feinting
fermenting	16	4	682	4	_fermenting
ferreting	13	12	769	4	_ferreting
flaunting	13	3	504	4	_flaunting
flinting	12	34	1234	4	__flinting
floating	12	31	1188	4	__floating
flouting	12	26	1047	4	__flouting
fomenting	15	3	723	4	_fomenting
fonding	12	38	1542	4	__f_onding
fontina	10	3	863	4	__f_ontina
footing	11	50	1759	4	__f_ooting
foresting	13	3	1136	4	_foresting
franking	16	43	1086	4	__franking
fretting	12	27	1152	4	__fretting
fringing	13	30	1090	4	__fringing
fritting	12	35	1070	4	__fritting
frocking	18	30	957	4	__frocking
frogging	14	35	873	4	__frogging
frontier	11	4	731	4	__frontier
frontline	12	4	505	4	__frontline
fronton	10	3	720	4	__fronton_
frontons	11	3	650	4	__frontons
frostings	13	3	573	4	__frostings
frothing	15	20	853	4	__frothing
frouncing	15	3	476	4	__frouncing
frowning	15	30	783	4	__frowning
frowsting	16	3	468	4	__frowsting
fruiting	12	22	906	4	__fruiting
furcating	15	3	778	4	_furcating
garoting	10	5	1070	4	_garo_ting
garotting	11	3	610	4	_garotting
garroting	11	3	695	4	garro_ting
garrotting	12	5	419	4	garrotting
granting	10	35	1452	4	__granting
grouting	10	34	1079	4	__grouting
grunting	10	26	958	4	__grunting
imprinting	15	4	602	4	imprinting
infracting	16	4	735	4	infracting
infringing	15	4	444	4	infringing
ironing	8	24	1401	4	__iron_ing
misrouting	13	4	722	4	misrouting
offending	17	4	409	4	off_ending
offloading	18	4	216	4	offloading
offsetting	17	4	233	4	offsetting
outrooting	11	4	793	4	outrooting
parenting	12	6	1158	4	_parenting
parroting	12	3	915	4	parro_ting
printing	11	32	1608	4	__printing
pronating	12	3	1376	4	__pronating
pronging	12	35	1184	4	__pronging
ranting	8	40	2541	4	___ranting
refloating	14	19	832	4	refloating
refracting	16	3	873	4	refracting
regranting	12	3	832	4	regranting
renting	8	40	2685	4	___renting
reprinting	13	15	1058	4	reprinting
rerenting	10	26	1766	4	_rerenting
rerouting	10	3	1187	4	_rerouting
rooting	8	35	2243	4	___rooting
rotting	8	29	1968	4	___rotting
routing	8	38	2109	4	___routing
sprinting	12	3	1003	4	_sprinting
sprouting	12	3	694	4	_sprouting
strunting	10	3	787	4	_strunting
throating	13	9	840	4	_throating
thronging	14	3	507	4	_thronging
throning	12	3	886	4	_thron_ing
trotting	9	25	1091	4	__trotting
unfrocking	20	4	353	4	unfrocking
unrooting	10	9	883	4	_unrooting
uprooting	12	7	690	4	_uprooting
warranting	14	4	474	4	warranting
wonting	11	32	1410	4	___wonting
wronging	13	32	739	4	__wronging

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.436	409841.7
2	DLD Change Limit	161450	156	9.360	17248.9
3	Display Results	156	156	0.080	1950.0
	(SQL Overall)	178691	156	9.876	18093.5