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

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

171 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
incarnating	14	4	554	(None)
incanting	12	8	990	2	inca_n_ting
incarnadine	14	9	251	2	incarnadine
incarnation	13	4	746	2	incarnation
incarnations	14	4	666	2	incarnations
incurvating	17	8	495	2	incurvating
reincarnating	16	5	244	2	reincarnating
incarcerating	18	5	258	3	incarcerating
incarnadined	16	9	149	3	incarnadined
incarnadines	15	9	220	3	incarnadines
incarnadining	17	6	87	3	incarnadining
incarnate	11	5	722	3	incarnat__e
incarnated	13	5	581	3	incarnat_ed
incarnates	12	4	671	3	incarnat_es
incenting	12	9	1206	3	inc_en_ting
increasing	13	4	632	3	inc_reasing
incrusting	13	12	647	3	inc_rusting
incubating	15	9	713	3	inc_ubating
inculcating	16	4	554	3	inculcating
inculpating	16	4	522	3	inculpating
indagating	13	4	526	3	inda_gating
indurating	12	4	924	3	indur_ating
inebriating	14	4	605	3	inebriating
infatuating	15	4	358	3	infatuating
infuriating	15	4	628	3	infuriating
innervating	15	4	636	3	innervating
intonating	11	4	863	3	in_tonating
intreating	11	6	1401	3	in_treating
invaginating	17	5	390	3	invaginating
narrating	10	3	1035	3	_n_arrating
uncrating	12	8	1318	3	unc_r_ating
uncreating	13	3	1047	3	unc_reating
acerbating	15	4	629	4	_acerbating
alternating	12	4	571	4	alternating
becarpeting	18	8	279	4	becarpeting
canaling	11	20	1641	4	__ca_naling
canting	10	47	2590	4	__ca_n_ting
carbonating	16	4	586	4	__carbonating
carnation	11	3	1294	4	__carnation
carnations	12	3	1135	4	__carnations
carnitine	11	7	857	4	__carnitine
carpeting	14	3	948	4	__carpeting
carting	10	42	2828	4	__car__ting
caseating	12	3	1174	4	__caseating
catenating	13	4	868	4	__catenating
caveating	15	3	929	4	__caveating
cocreating	15	3	1029	4	coc_reating
concatenating	18	5	326	4	concatenating
coronating	13	4	1017	4	__coronating
crating	10	37	2520	4	__c_r_ating
creating	11	39	2195	4	__c_reating
curating	11	3	1429	4	__cur_ating
cybernating	19	5	285	4	cybernating
decanting	13	25	1063	4	deca_n_ting
decarbonating	19	5	323	4	decarbonating
decorating	14	3	1207	4	decor_ating
demarcating	17	4	520	4	demarcating
discanting	14	4	945	4	disca_n_ting
emanating	12	3	900	4	_ema_nating
enchanting	16	4	594	4	enchan_ting
encrusting	13	12	529	4	enc_rusting
encrypting	18	4	305	4	enc_rypting
enervating	14	8	843	4	en_ervating
entreating	11	8	1155	4	en_treating
escalating	13	4	709	4	esca_lating
excavating	23	4	411	4	exca_vating
excoriating	21	4	548	4	excoriating
hibernating	17	5	317	4	hibernating
iceboating	15	4	335	4	i_ceboating
impainting	15	4	450	4	impain_ting
imparting	14	3	724	4	impar__ting
inactivating	18	5	346	4	inactivating
inarching	15	4	634	4	in_ar_ching
inarming	11	3	834	4	in_ar__ming
inbreathing	17	4	280	4	in_breathing
incaging	12	8	867	4	inc___aging
incantation	13	4	705	4	incantation
incantations	14	4	664	4	incantations
incardination	16	5	503	4	incardination
incardinations	17	5	441	4	incardinations
incasing	11	6	1060	4	inc___asing
incensing	12	9	766	4	inc_en_sing
incepting	14	8	929	4	inc__epting
incinerating	15	5	472	4	incinerating
inciting	11	3	1253	4	inc___iting
inclination	13	4	973	4	inclination
inclinations	14	4	875	4	inclinations
inclining	12	4	840	4	inclin__ing
incorporating	18	5	412	4	incorporating
incorpsing	15	4	443	4	incor_psing
incriminating	18	5	417	4	incriminating
incrossing	13	4	502	4	inc_rossing
incurring	12	3	687	4	incur__ring
incurvation	16	4	698	4	incurvation
incurvations	17	4	638	4	incurvations
incurving	15	4	537	4	incur__ving
indenting	11	9	1126	4	in_den_ting
indicating	14	4	969	4	in_dicating
indoctrinating	18	6	204	4	indoctrinating
inearthing	14	4	354	4	inear_thing
infantine	12	4	714	4	infa_n_tine
inflating	13	3	1044	4	in__flating
infracting	16	4	735	4	in_fracting
ingrafting	15	4	489	4	in_grafting
ingratiating	14	5	406	4	ingratiating
inhabiting	16	4	429	4	inha_biting
inheriting	14	4	885	4	inher_iting
initiating	11	4	962	4	in_itiating
innovating	14	4	461	4	in_novating
inoculating	14	4	672	4	inoculating
inseminating	15	5	455	4	inseminating
inserting	10	9	1424	4	inser__ting
insinuating	12	4	453	4	insinuating
insnaring	10	4	631	4	in__snaring
insolating	11	4	915	4	in_solating
instating	10	8	1221	4	in__stating
instigating	13	4	715	4	instigating
instructing	14	4	629	4	instructing
insulating	11	3	926	4	in_sulating
integrating	13	4	949	4	integrating
interacting	14	4	1171	4	interacting
interesting	12	4	1112	4	interesting
interfacing	17	4	770	4	interfacing
interlacing	14	4	905	4	interlacing
interlaying	15	4	757	4	interlaying
intermatting	15	4	717	4	intermatting
interning	10	3	1525	4	intern__ing
intimating	13	4	1082	4	in_timating
intorting	10	3	1141	4	intor__ting
intrusting	11	12	817	4	in_trusting
intubating	13	7	671	4	in_tubating
inundating	12	4	454	4	in_undating
inurning	9	3	755	4	in_urn__ing
invalidating	17	9	344	4	invalidating
inventing	13	10	997	4	in_ven_ting
inverting	13	10	1322	4	inver__ting
invocating	16	4	633	4	in_vocating
iodinating	12	4	696	4	i_odinating
irradiating	13	5	377	4	irradiating
iterating	10	3	1425	4	i_ter_ating
lacerating	13	4	945	4	lacer_ating
lancinating	14	4	545	4	lanc_inating
lariating	10	3	1179	4	__lariating
macerating	15	4	954	4	macer_ating
machinating	19	4	562	4	machinating
marinating	13	4	1027	4	__marinating
miscreating	16	4	849	4	misc_reating
nicknaming	19	5	211	4	nic_knaming
nictating	12	3	757	4	nic__tating
nictitating	14	4	438	4	nictitating
nitrating	10	3	1267	4	_nitr_ating
nominating	13	4	950	4	_nominating
recanting	12	24	1482	4	reca_n_ting
recarpeting	16	7	436	4	recarpeting
recrating	12	13	1879	4	rec_r_ating
recreating	13	12	1458	4	rec_reating
reincarnation	15	6	317	4	reincarnation
reincarnations	16	7	278	4	reincarnations
scanting	11	39	1476	4	_sca_n_ting
scarlatina	12	9	405	4	_scarlatina
scarting	11	34	1526	4	_scar__ting
separating	13	4	864	4	separ_ating
stagnating	12	5	497	4	_stagnating
ulcerating	13	4	698	4	ulcer_ating
unabating	12	4	675	4	un_a_bating
uncaring	11	3	1284	4	uncar___ing
uncoating	12	6	1192	4	unc__oating
undereating	13	6	955	4	undereating
underrating	13	8	825	4	underrating
vaccinating	19	4	519	4	vaccinating
variating	13	3	1095	4	__variating

Search took 9 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.423	422437.4
2	DLD Change Limit	148819	171	8.390	17737.7
3	Display Results	171	171	0.110	1554.5
	(SQL Overall)	178691	171	8.923	20025.9