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

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

138 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
nonrotating	12	4	630	(None)
corotating	13	4	932	2	co_rotating
annotating	11	4	623	3	_annotating
coronating	13	4	1017	3	co_ronating
nonbetting	13	4	584	3	nonbet_ting
nonirritating	14	7	251	3	nonirritating
nonreading	12	4	688	3	nonr_eading
nonrioting	11	4	675	3	nonr_ioting
nonroutine	10	6	601	3	nonro_utine
nonvoting	13	4	690	3	nonvo__ting
notating	9	25	1334	3	__n_otating
rotating	9	26	1455	3	___rotating
abrogating	14	9	798	4	_abrogating
approbating	18	4	458	4	approbating
arrogating	12	177	839	4	_arrogating
autorotating	13	7	384	4	autorotating
borating	11	34	1450	4	bo_r__ating
boycotting	18	4	263	4	boycot_ting
bromating	14	3	917	4	__bromating
cocreating	15	3	1029	4	cocr_eating
cogitating	14	4	721	4	co_gitating
cohobating	18	4	502	4	co_hobating
collocating	16	4	590	4	collocating
colocating	15	4	862	4	co_locating
commutating	18	4	602	4	commutating
concocting	14	4	841	4	conco_cting
conflating	16	4	1000	4	con_flating
confronting	17	4	486	4	confro_nting
conglobating	18	5	316	4	conglobating
congregating	17	5	428	4	congregating
conjugating	22	4	450	4	conjugating
connotation	13	4	798	4	connotation
connotations	14	4	728	4	connotations
connotative	16	6	538	4	connotative
connoting	12	3	1002	4	conno__ting
consociating	17	5	557	4	consociating
consorting	13	4	1074	4	conso_rting
contacting	15	6	1007	4	con__tacting
contorting	13	4	1010	4	conto_rting
convoluting	17	4	420	4	convoluting
coplotting	15	5	595	4	coplot_ting
corelating	13	5	1158	4	co_relating
corotation	12	4	1097	4	co_rotation
corotations	13	4	976	4	co_rotations
correlating	14	8	708	4	correlating
corrugating	15	4	426	4	corrugating
derogating	13	4	863	4	_derogating
dogtrotting	14	6	203	4	dogtrot_ting
donating	10	3	1180	4	don___ating
embrocating	18	4	414	4	embrocating
enrooting	10	12	813	4	_enro_oting
foredating	15	7	712	4	fo_redating
foretasting	15	5	442	4	fo_retasting
formatting	16	4	416	4	fo_rmatting
fornicating	17	7	487	4	fornicating
foxtrotting	22	5	173	4	foxtrot_ting
garotting	11	3	610	4	_garot_ting
garrotting	12	5	419	4	garrot_ting
innovating	14	4	461	4	_innovating
insolating	11	4	915	4	_insolating
instating	10	8	1221	4	_in_stating
intonating	11	4	863	4	_intonating
invocating	16	4	633	4	_invocating
irritating	11	4	629	4	_irritating
knotting	13	23	657	4	_kn_ot_ting
montaging	13	4	654	4	mon__taging
mortaring	12	3	794	4	mo_r_taring
narrating	10	3	1035	4	n_ar_rating
necrotizing	23	4	519	4	necrotizing
negotiating	13	4	424	4	n_egotiating
nictating	12	3	757	4	__nictating
nictitating	14	4	438	4	nictitating
nitrating	10	3	1267	4	nitr__ating
nominating	13	4	950	4	no_minating
nonacting	12	3	878	4	non__acting
nonaromatic	15	5	636	4	nonaromati_c
nonaromatics	16	5	422	4	nonaromatics
nonbearing	13	4	645	4	non_bearing
nonbiting	12	4	782	4	non__biting
nonbonding	14	4	503	4	nonbo_nding
nonbotanist	13	5	460	4	nonbotanist
nonbreathing	18	5	210	4	nonbreathing
noncaking	16	4	668	4	non__caking
noncoding	13	4	767	4	nonco__ding
noncoking	16	4	681	4	nonco__king
nonfading	14	4	587	4	non__fading
nongrowing	15	4	376	4	nongro__wing
nonhousing	14	4	451	4	nonho_using
nonhunting	14	4	468	4	non_hunting
nonionizing	21	4	556	4	nonionizing
nonloving	13	4	541	4	nonlo__ving
nonmeeting	13	4	607	4	non_meeting
nonmoving	15	4	510	4	nonmo__ving
nonoperating	15	5	541	4	nonoperating
nonpaying	15	4	571	4	non__paying
nonplaying	16	4	444	4	non_playing
nonpolluting	15	5	204	4	nonpolluting
nonproducing	18	5	252	4	nonproducing
nonprossing	14	5	449	4	nonpro_ssing
nonprotein	12	5	482	4	nonprot_ein_
nonreducing	15	5	317	4	nonreducing
nonrelative	14	5	683	4	nonrelative
nonruling	10	4	643	4	nonr__uling
nonspeaking	18	5	319	4	nonspeaking
nonsporting	14	4	482	4	nonsporting
nonstatic	11	4	846	4	non_stati_c
nonsuiting	11	4	727	4	non_suiting
nonvolatile	14	5	317	4	nonvolatile
nonworking	18	4	421	4	nonwo_rking
northing	12	19	906	4	no_r_t_hing
nutating	9	24	1195	4	__n_utating
onloading	11	4	516	4	_onlo_ading
orating	8	35	2032	4	_o_r__ating
outstating	11	3	936	4	_outstating
overstating	15	4	1073	4	overstating
ozonating	19	4	432	4	_o_zonating
perorating	13	3	1313	4	_perorating
portaging	13	4	684	4	po_r_taging
probating	14	3	1119	4	__probating
pronating	12	3	1376	4	__pronating
prorating	12	3	1428	4	__prorating
prorogating	15	5	606	4	prorogating
renovating	14	4	742	4	ren_ovating
reprobating	16	4	710	4	reprobating
rotting	8	29	1968	4	___rot_ting
sanitating	11	4	964	4	san_itating
sonicating	13	4	831	4	son_icating
sonnetting	11	4	482	4	sonnet_ting
subrogating	15	16	498	4	subrogating
surrogating	13	19	432	4	surrogating
syncopating	19	5	325	4	syncopating
throating	13	9	840	4	_thro_ating
trotting	9	25	1091	4	__trot_ting
uncoating	12	6	1192	4	_unco_ating
understating	14	4	654	4	understating
unknotting	15	4	266	4	unkn_ot_ting
unrooting	10	9	883	4	_unro_oting
unstating	10	7	1121	4	_un_stating

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.440	406115.9
2	DLD Change Limit	148819	138	9.170	16228.9
3	Display Results	138	138	0.080	1725.0
	(SQL Overall)	178691	138	9.690	18440.8