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

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

111 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
migrational	14	4	474	(None)
immigrational	18	5	193	2	immigrational
irrational	10	4	721	2	_irrational
librational	13	4	455	2	librational
migration	12	17	970	2	migration__
migrations	13	16	868	2	migration_s
vibrational	16	4	436	2	vibrational
agitational	12	4	484	3	agitational
binational	12	4	637	3	bi_national
citational	12	6	646	3	ci_tational
emigration	13	22	821	3	emigration__
emigrations	14	18	715	3	emigration_s
gyrational	14	4	474	3	_gyrational
ideational	11	4	650	3	_ideational
irrationals	11	5	473	3	_irrationals
maturational	14	5	418	3	maturational
mediational	14	4	564	3	mediational
microtonal	14	5	614	3	microt_onal
migrating	13	9	1053	3	migrati_n_g
mutational	12	4	651	3	m_utational
narrational	11	4	544	3	narrational
negational	11	4	715	3	neg_ational
nonrational	11	10	912	3	nonrational
operational	13	4	752	3	operational
rational	8	4	1254	3	___rational
situational	11	4	458	3	situational
subrational	13	4	549	3	subrational
aberrational	14	5	348	4	aberrational
aggregational	16	6	222	4	aggregational
antirational	12	7	849	4	antirational
arbitrational	15	5	318	4	arbitrational
aspirational	14	5	500	4	aspirational
attritional	11	5	424	4	attritional
avocational	16	4	518	4	avocational
bioregional	14	5	218	4	bioregional
bisectional	15	5	464	4	bisectional
cognitional	14	5	427	4	cognitional
dictional	12	6	861	4	di__ctional
digressional	14	5	317	4	digressional
dilatational	13	5	277	4	dilatational
directional	14	4	544	4	directional
educational	14	4	487	4	educational
emigrating	14	6	750	4	emigrati_n_g
equational	19	4	560	4	_equational
fictional	14	7	780	4	fi__ctional
figuration	14	4	591	4	figuration__
figurations	15	4	508	4	figuration_s
fractional	15	4	713	4	__fractional
generational	13	5	482	4	generational
gestational	12	4	511	4	gestational
gradational	13	5	447	4	gradational
immigration	16	4	417	4	immigration__
immigrations	17	4	372	4	immigration_s
irrationally	15	5	524	4	_irrationally
irrotational	12	5	402	4	_irrotational
lactational	13	4	465	4	lactational
libration	11	15	1016	4	libration__
librations	12	14	906	4	libration_s
ligation	9	23	1309	4	lig_ation__
ligations	10	21	1199	4	lig_ation_s
limitational	14	5	354	4	limitational
locational	12	4	659	4	_locational
matinal	9	3	1260	4	m___ati_nal
matronal	10	4	811	4	m___atronal
meridional	13	5	355	4	m_eridional
migraine	11	5	786	4	migra_i_n_e
migraines	12	8	693	4	migra_i_nes
migrainous	13	5	224	4	migra_inous
migrator	11	4	787	4	migrat_o__r
migrators	12	4	754	4	migrat_o_rs
migratory	15	4	534	4	migrat_o_ry
miracidial	15	5	229	4	mi_racidial
misrating	12	10	1485	4	misrati_n_g
missional	11	4	606	4	mi__ssional
morainal	10	4	720	4	m_ora_i_nal
motional	10	5	867	4	m___otional
motivational	17	5	391	4	motivational
national	8	3	1153	4	___national
navigational	16	5	329	4	navig_ational
nitration	9	3	1344	4	nitration__
nitrations	10	3	1203	4	nitration_s
nonnational	11	10	783	4	nonnational
notational	10	4	812	4	_notational
nutational	10	4	704	4	_nutational
nutritional	11	5	478	4	nutritional
ovational	12	4	685	4	__ovational
perorational	14	4	639	4	perorational
piratical	13	4	867	4	pi_rati_cal
probational	15	4	708	4	probational
radiational	12	4	595	4	radiational
rationale	9	4	946	4	___rationale
rationals	9	4	994	4	___rationals
recreational	14	5	517	4	recreational
relational	10	4	771	4	_relational
remigration	14	22	891	4	remigration__
remigrations	15	22	779	4	remigration_s
rotational	10	4	809	4	_rotational
salvational	14	4	371	4	salvational
sensational	11	4	638	4	sensational
stational	9	4	851	4	__stational
subnational	13	5	457	4	subnational
summational	15	5	368	4	summational
titration	9	3	1054	4	titration__
titrations	10	3	917	4	titration_s
tractional	12	4	805	4	__tractional
valuational	14	4	404	4	valuational
variational	14	4	477	4	variational
vegetational	16	5	337	4	vegetational
vibration	14	13	820	4	vibration__
vibrations	15	15	737	4	vibration_s
vocational	15	4	695	4	_vocational

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.423	422437.4
2	DLD Change Limit	148819	111	8.593	17318.6
3	Display Results	111	111	0.060	1850.0
	(SQL Overall)	178691	111	9.076	19688.3