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

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

147 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
itinerating	12	4	523	(None)
incinerating	15	5	472	2	incinerating
intenerating	13	4	673	2	intenerating
iterating	10	3	1425	2	it__erating
itineration	11	5	632	2	itineration
itinerations	12	4	568	2	itinerations
acierating	13	4	832	3	aci_erating
exonerating	19	4	555	3	exonerating
generating	12	3	1039	3	_generating
innervating	15	4	636	3	i_nnervating
itineracies	13	5	314	3	itineracies
itinerant	9	4	519	3	itinera__nt
itineraries	11	5	333	3	itineraries
itinerate	9	11	625	3	itinerat__e
itinerated	11	12	493	3	itinerat_ed
itinerates	10	12	613	3	itinerat_es
liberating	13	4	925	3	_liberating
reiterating	12	4	1050	3	reiterating
titrating	10	3	1011	3	_ti_trating
tolerating	11	4	859	3	_tolerating
venerating	14	4	1005	3	_venerating
vituperating	18	5	197	3	vituperating
abnegating	14	4	446	4	_abnegating
aerating	9	28	2100	4	___aerating
alienating	11	4	723	4	ali_enating
alliterating	13	5	427	4	alliterating
asperating	13	4	956	4	_asperating
attenuating	12	5	310	4	attenuating
berating	11	32	2076	4	___berating
cooperating	16	4	842	4	cooperating
crenelating	14	4	551	4	crenelating
deaerating	12	3	1156	4	_deaerating
degenerating	15	4	566	4	degenerating
deliberating	16	4	512	4	deliberating
delineating	13	4	637	4	deline_ating
denervating	16	4	592	4	_denervating
denigrating	14	14	692	4	denigrating
denitrating	13	12	833	4	denitrating
derating	10	32	2228	4	___derating
desiderating	15	4	469	4	desiderating
deuterating	13	4	727	4	deuterating
disinheriting	18	5	348	4	disinheriting
disintegrating	17	6	330	4	disintegrating
disrating	11	7	1455	4	_di_srating
diverting	14	24	1033	4	_diver_ting
emigrating	14	6	750	4	emi_grating
enervating	14	8	843	4	__enervating
enumerating	14	4	500	4	enumerating
etiolating	11	4	698	4	eti_olating
eviscerating	18	5	267	4	eviscerating
exenterating	20	5	422	4	exenterating
exuberating	21	4	417	4	exuberating
federating	15	4	885	4	_federating
filtrating	14	4	597	4	_filtrating
hibernating	17	5	317	4	_hibernating
ideating	10	3	1170	4	__ide_ating
imitating	12	3	876	4	imi__tating
immigrating	17	4	331	4	immigrating
impetrating	16	4	464	4	impetrating
imprecating	18	4	490	4	imprecating
incineration	14	4	629	4	incineration
incinerations	15	4	568	4	incinerations
indurating	12	4	924	4	i_ndurating
inearthing	14	4	354	4	__inearthing
inebriating	14	4	605	4	__inebriating
infiltrating	16	5	325	4	infiltrating
inflating	13	3	1044	4	__inflating
infracting	16	4	735	4	__infracting
ingrafting	15	4	489	4	__ingrafting
inheriting	14	4	885	4	i_nheriting
initiating	11	4	962	4	ini_tiating
innerving	13	4	650	4	i_nner_ving
innovating	14	4	461	4	i_nnovating
inserting	10	9	1424	4	i_nser_ting
insinuating	12	4	453	4	insin_uating
instating	10	8	1221	4	__instating
integrating	13	4	949	4	integrating
inteneration	12	4	863	4	inteneration
intenerations	13	4	746	4	intenerations
interacting	14	4	1171	4	i_nteracting
intimating	13	4	1082	4	inti__mating
intimidating	16	5	474	4	intimidating
intonating	11	4	863	4	inton__ating
intreating	11	6	1401	4	__intreating
inundating	12	4	454	4	inun_dating
inverting	13	10	1322	4	i_nver_ting
invigorating	17	5	298	4	invigorating
iodinating	12	4	696	4	iodin__ating
iteration	9	5	1503	4	it__eration
iterations	10	4	1382	4	it__erations
iterative	12	4	1071	4	it__erative
itineracy	14	5	216	4	itinera__cy
itinerancies	14	5	279	4	itinerancies
itinerancy	15	5	233	4	itinera_ncy
itinerantly	14	5	202	4	itinerantly
itinerants	10	5	298	4	itinera_nts
itinerary	12	5	234	4	itinera__ry
lacerating	13	4	945	4	_lacerating
librating	12	3	905	4	_li_brating
linecasting	14	10	278	4	_linecasting
litigating	12	4	674	4	liti__gating
macerating	15	4	954	4	_macerating
migrating	13	9	1053	4	_mi_grating
miseating	12	12	1543	4	_mise_ating
misrating	12	10	1485	4	_mi_srating
mitigating	14	4	743	4	miti__gating
moderating	14	4	880	4	_moderating
negating	10	20	1283	4	___negating
nitrating	10	3	1267	4	_ni_trating
numerating	13	5	723	4	_numerating
obliterating	15	5	339	4	obliterating
operating	12	3	1372	4	__operating
orientating	12	4	577	4	orientating
patinating	13	3	988	4	patin__ating
penetrating	14	4	766	4	_penetrating
pirating	11	3	1451	4	_pi__rating
regenerating	14	4	633	4	regenerating
reinflating	15	4	599	4	reinflating
reinnervating	17	5	292	4	reinnervating
reinserting	12	5	690	4	reinser_ting
reinstating	12	4	811	4	reinstating
reintegrating	15	5	461	4	reintegrating
remunerating	15	4	542	4	remunerating
reoperating	14	4	902	4	reoperating
ruinating	10	3	959	4	ruin__ating
sinuating	10	3	968	4	_sin_uating
stalemating	14	4	468	4	stalemating
stimulating	14	4	568	4	stimulating
stinting	9	34	1574	4	stin___ting
stipulating	14	4	516	4	stipulating
threating	13	10	1005	4	_thre_ating
tiering	8	3	1525	4	_ti_er__ing
timesaving	16	4	198	4	_timesaving
tincting	11	4	888	4	_tin__cting
tinkering	14	3	770	4	_tinker__ing
tinting	8	46	2060	4	_tin___ting
titillating	12	4	371	4	titi_llating
titivating	14	4	532	4	_titivating
treating	9	25	1961	4	_t_re_ating
triturating	12	4	543	4	triturating
ulcerating	13	4	698	4	_ulcerating
uncrating	12	8	1318	4	__uncrating
urinating	10	3	1065	4	urin__ating
venenating	14	4	601	4	_venenating
vibrating	15	3	748	4	_vi_brating
vitiating	13	3	841	4	viti___ating
vociferating	21	8	246	4	vociferating

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.420	425454.8
2	DLD Change Limit	148819	147	8.876	16766.4
3	Display Results	147	147	0.076	1934.2
	(SQL Overall)	178691	147	9.372	19066.5