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

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

113 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
immigrations	17	4	372	(None)
immigration	16	4	417	1	immigration_
emigrations	14	18	715	2	_emigrations
immigrating	17	4	331	2	immigrati_ng
immigrational	18	5	193	2	immigrational
migrations	13	16	868	2	__migrations
remigrations	15	22	779	2	remigrations
admirations	14	4	669	3	admi_rations
denigrations	14	4	735	3	denigrations
emigration	13	22	821	3	_emigration_
fumigations	17	4	492	3	fumig_ations
imaginations	15	4	634	3	imaginations
imitations	12	5	996	3	i_mi_tations
immigrates	15	4	402	3	immigrat__es
immoderations	18	5	307	3	immoderations
immolations	15	4	547	3	imm_olations
impetrations	16	4	544	3	impetrations
indignations	14	4	604	3	indignations
integrations	13	12	947	3	integrations
invigorations	17	5	391	3	invigorations
irrigations	12	4	694	3	irrig_ations
migration	12	17	970	3	__migration_
mitigations	14	4	762	3	mitig_ations
remigration	14	22	891	3	remigration_
admiration	13	4	773	4	admi_ration_
ameliorations	15	6	319	4	ameliorations
ammoniations	16	4	541	4	ammoniations
arbitrations	14	4	576	4	arbitrations
aspirations	13	4	899	4	aspi_rations
assignations	13	4	416	4	assignations
calibrations	16	4	515	4	calibrations
comminations	18	8	1048	4	commi_nations
commiserations	20	5	345	4	commiserations
denigration	13	4	846	4	denigration_
designations	14	5	694	4	designations
dominations	14	6	1104	4	domi_nations
emigrating	14	6	750	4	_emigrati_ng
expirations	20	6	958	4	expi_rations
figurations	15	4	508	4	__figurations
fumigation	16	4	562	4	fumig_ation_
geminations	14	13	925	4	gemi_nations
humiliations	17	8	455	4	humiliations
imagination	14	4	719	4	imagination_
imbibitions	17	5	238	4	imbi_bitions
imbrications	18	4	568	4	imbrications
imitation	11	5	1085	4	i_mi_tation_
immersions	14	4	400	4	imm_er_sions
immigrant	14	5	319	4	immigra___nt
immigrants	15	5	207	4	immigra__nts
immigrate	14	4	435	4	immigrat___e
immigrated	16	4	331	4	immigrat__ed
immoderation	17	5	343	4	immoderation_
immolation	14	4	610	4	imm_olation_
immunizations	26	11	534	4	immunizations
impartations	16	13	543	4	impartations
impetration	15	4	590	4	impetration_
implications	18	4	702	4	implications
importations	16	15	614	4	importations
imprecations	18	4	627	4	imprecations
impregnations	18	5	377	4	impregnations
imputations	15	4	635	4	i_mputations
inaugurations	14	5	315	4	inaugurations
incinerations	15	4	568	4	incinerations
incitations	13	3	1088	4	inci_tations
indagations	13	4	540	4	indag_ations
indications	14	3	1097	4	indi_cations
indigestions	14	5	364	4	indigestions
indignation	13	4	653	4	indignation_
indurations	12	4	958	4	i_ndurations
infiltrations	16	5	390	4	infiltrations
infixations	21	4	669	4	infi_xations
initiations	11	4	1072	4	i_nitiations
insinuations	12	13	642	4	insinuations
inspirations	14	4	730	4	inspirations
instigations	13	4	824	4	instig_ations
integration	12	13	1049	4	integration_
intimations	13	4	1188	4	inti_mations
invigilations	17	6	448	4	invigilations
invigoration	16	5	459	4	invigoration_
invitations	14	4	905	4	invi_tations
iodinations	12	6	884	4	iodi_nations
ionizations	20	4	989	4	ioni_zations
irrigation	11	4	780	4	irrig_ation_
irritations	11	4	783	4	irri_tations
itemizations	23	4	784	4	itemi_zations
iterations	10	4	1382	4	i__terations
itinerations	12	4	568	4	itinerations
laminations	13	3	980	4	lami_nations
levigations	15	4	621	4	levig_ations
librations	12	14	906	4	__librations
ligations	10	21	1199	4	__lig_ations
limitations	13	4	818	4	limi_tations
litigations	12	4	733	4	litig_ations
macerations	15	4	847	4	_macerations
maturations	13	4	844	4	_maturations
meliorations	14	6	675	4	meliorations
migrating	13	9	1053	4	__migrati_ng
migrational	14	4	474	4	__migrational
migrators	12	4	754	4	__migrat_ors
ministrations	15	5	544	4	ministrations
mitigation	13	4	864	4	mitig_ation_
moderations	14	4	827	4	_moderations
navigations	15	4	520	4	navig_ations
nitrations	10	3	1203	4	__nitrations
nominations	13	4	1053	4	nomi_nations
numerations	13	12	729	4	num_erations
obligations	14	4	614	4	oblig_ations
premigration	17	5	569	4	premigration_
remigrating	15	4	759	4	remigrati_ng
resignations	13	4	688	4	resignations
ruminations	13	4	939	4	rumi_nations
titrations	10	3	917	4	__titrations
vibrations	15	15	737	4	__vibrations

Search took 8 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	124790	0.373	479064.3
2	DLD Change Limit	124790	113	6.813	18316.5
3	Display Results	113	113	0.080	1412.5
	(SQL Overall)	178691	113	7.266	24592.8