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

Here are the results of your fuzzy-string dictionary search for “duration” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

224 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
duration	9	3	1269	(None)
durations	10	3	1146	1	durations
adjuration	18	4	552	2	adjuration
adoration	10	3	1131	2	adoration
adulation	10	3	1101	2	adulation
aeration	8	3	1993	2	aeration
darnation	10	3	982	2	darnation
delation	9	23	1808	2	delation
dilation	9	22	1546	2	dilation
donation	9	15	1378	2	donation
dotation	9	14	1273	2	dotation
durative	12	3	907	2	durative
durion	7	5	1096	2	dur__ion
education	12	3	1020	2	education
furcation	14	4	835	2	furcation
gyration	12	3	776	2	gyration
induration	11	4	1061	2	induration
lunation	8	3	1192	2	lunation
luxation	15	3	823	2	luxation
mutation	10	14	1288	2	mutation
nutation	8	15	1310	2	nutation
oration	7	16	1771	2	_oration
pupation	12	6	950	2	pupation
purgation	12	4	739	2	purgation
ration	6	42	2601	2	__ration
sudation	9	3	1080	2	sudation
abjuration	19	4	588	3	abjuration
ablation	10	3	1243	3	ablation
abrasion	10	4	662	3	abrasion
adjurations	19	4	482	3	adjurations
admiration	13	4	773	3	admiration
adnation	9	3	1078	3	adnation
adorations	11	3	1023	3	adorations
adulations	11	3	1012	3	adulations
adumbration	16	5	261	3	adumbration
aerations	9	3	1790	3	aerations
agnation	9	3	1172	3	agnation
alation	7	29	2055	3	_alation
auction	9	34	1293	3	au_ction
audition	9	7	917	3	audition
aviation	11	3	1274	3	aviation
burton	8	3	1127	3	bur_t_on
carnation	11	3	1294	3	carnation
cation	8	39	2550	3	__cation
caudation	12	6	999	3	caudation
causation	11	9	952	3	causation
ceratin	9	30	2016	3	cerati_n
citation	10	3	1436	3	citation
conation	10	14	2088	3	conation
craton	8	45	1719	3	_crat_on
creation	10	28	1651	3	creation
curating	11	3	1429	3	curating
curative	13	3	1040	3	curative
curator	9	3	1221	3	curat_or
curtain	9	31	979	3	curtai_n
damnation	12	3	840	3	damnation
darnations	11	3	841	3	darnations
deaeration	11	3	1301	3	deaeration
dealation	10	3	1300	3	dealation
decoration	13	3	1442	3	decoration
deflation	13	3	1065	3	deflation
delations	10	26	1659	3	delations
deletion	9	20	1197	3	deletion
demotion	11	6	907	3	demotion
dentation	10	3	1524	3	dentation
denudation	12	4	730	3	denudation
deputation	13	3	939	3	deputation
deraign	9	3	657	3	dera_ign
derating	10	32	2228	3	derating
derision	9	3	907	3	derision
derivation	14	7	1278	3	derivation
derogation	12	4	1039	3	derogation
detraction	13	13	858	3	detraction
detrition	10	4	913	3	detrition
deuteration	12	4	910	3	deuteration
deviation	13	3	1239	3	deviation
devotion	12	5	676	3	devotion
diatron	8	3	928	3	d_iatron
dictation	12	8	1056	3	dictation
diction	10	23	1305	3	d_iction
dilations	10	26	1445	3	dilations
dilution	9	23	914	3	dilution
direction	12	8	978	3	direction
donations	10	11	1235	3	donations
dotations	10	14	1163	3	dotations
dragon	8	3	884	3	d_ra_gon
dragoon	9	3	528	3	d_ragoon
drain	6	52	2289	3	d_ra_i_n
dubitation	13	7	733	3	dubitation
duramen	10	9	690	3	dura_men
duratives	13	4	622	3	duratives
durian	7	3	1200	3	dur__ian
durions	8	3	996	3	dur__ions
dynatron	12	4	362	3	dynatron
educations	13	3	923	3	educations
eduction	11	6	905	3	edu_ction
elation	7	36	2045	3	_elation
emulation	11	3	1239	3	emulation
enation	7	34	1923	3	_enation
equation	17	3	1048	3	equation
erasion	7	3	1196	3	_erasion
eruption	10	4	704	3	eruption
exudation	17	8	769	3	exudation
federation	14	4	957	3	federation
fetation	11	6	1314	3	fetation
figuration	14	4	591	3	figuration
fixation	18	3	707	3	fixation
formation	14	3	942	3	formation
fraction	13	5	948	3	_fraction
fruition	11	10	610	3	fruition
function	13	3	784	3	function
furcations	15	4	753	3	furcations
gelation	9	30	1443	3	gelation
gratin	7	45	2058	3	_grati_n
gumption	13	4	398	3	gumption
gustation	10	4	796	3	gustation
guttation	10	4	617	3	guttation
gyrations	13	3	692	3	gyrations
halation	11	3	1385	3	halation
himation	13	3	975	3	himation
hydration	16	4	607	3	hydration
ideation	9	3	1049	3	ideation
illation	8	3	1194	3	illation
indurations	12	4	958	3	indurations
iodation	9	3	1038	3	iodation
iteration	9	5	1503	3	iteration
junction	17	3	620	3	junction
kation	10	43	1568	3	__kation
keratin	11	33	1415	3	kerati_n
laudation	10	8	813	3	laudation
laureation	10	4	615	3	laureation
lavation	11	3	997	3	lavation
laxation	15	3	842	3	laxation
legation	9	24	1293	3	legation
libation	10	24	1136	3	libation
libration	11	15	1016	3	libration
ligation	9	23	1309	3	ligation
lobation	10	21	1055	3	lobation
location	10	21	1391	3	location
lunations	9	3	1072	3	lunations
lustration	10	4	835	3	lustration
luxations	16	3	727	3	luxations
marathon	13	4	681	3	marathon
maturation	12	4	951	3	maturation
migration	12	17	970	3	migration
moderation	13	4	865	3	moderation
modulation	13	14	793	3	modulation
munition	10	3	876	3	munition
mutations	11	12	1145	3	mutations
narration	9	3	1006	3	narration
natation	8	15	1393	3	natation
nation	6	43	2280	3	__nation
negation	9	29	1302	3	negation
nervation	12	6	1024	3	nervation
nidation	9	4	1058	3	nidation
nitration	9	3	1344	3	nitration
nodulation	11	12	799	3	nodulation
notation	8	14	1460	3	notation
novation	11	17	1001	3	novation
numeration	12	13	796	3	numeration
nunnation	9	12	656	3	nunnation
nutations	9	14	1176	3	nutations
nutrition	9	6	673	3	nutrition
oblation	10	3	986	3	oblation
obturation	12	9	714	3	obturation
operation	11	3	1400	3	operation
orations	8	15	1580	3	_orations
ovation	10	15	1002	3	_ovation
ovulation	12	3	898	3	ovulation
parathion	14	4	617	3	parathion
portion	9	6	1549	3	por_tion
potation	10	17	1678	3	potation
proration	11	4	1598	3	proration
pulsation	11	3	714	3	pulsation
punition	10	3	837	3	punition
pupations	13	3	812	3	pupations
purgations	13	4	674	3	purgations
question	17	4	582	3	question
quotation	18	14	697	3	quotation
ratio	5	52	2758	3	__ratio_
rations	7	41	2343	3	__rations
ratios	6	49	2267	3	__ratios
ratoon	6	44	1737	3	__ratoon
ratton	6	41	1612	3	__ratton
relation	8	26	1977	3	relation
rogation	9	16	1205	3	rogation
rotation	8	16	1545	3	rotation
ruction	9	36	1161	3	ru_ction
ruination	9	3	1127	3	ruination
saturation	10	4	980	3	saturation
sedation	9	3	1245	3	sedation
seriation	9	3	1806	3	seriation
serration	9	4	1406	3	serration
solation	8	9	1615	3	solation
sorption	10	3	751	3	sorption
station	7	27	1724	3	_station
striation	9	3	1348	3	striation
suasion	7	3	936	3	su_asion
sublation	11	3	1101	3	sublation
suction	9	37	1304	3	su_ction
sudations	10	3	990	3	sudations
sulcation	11	7	1073	3	sulcation
sulfation	12	8	878	3	sulfation
summation	13	4	780	3	summation
tarnation	9	3	1009	3	tarnation
taxation	15	3	799	3	taxation
titration	9	3	1054	3	titration
traction	10	4	1268	3	_traction
tuition	7	3	882	3	tu_ition
turion	6	3	1316	3	tur__ion
ululation	9	3	809	3	ululation
unction	9	3	1066	3	_unction
undulation	11	4	710	3	undulation
uratic	8	30	1635	3	_urati_c
urination	9	3	1217	3	_urination
usurpation	12	4	381	3	usurpation
vacation	13	19	1189	3	vacation
variation	12	3	1239	3	variation
venation	11	5	1350	3	venation
vernation	12	3	1108	3	vernation
vexation	18	3	878	3	vexation
vibration	14	13	820	3	vibration
vocation	13	23	1198	3	vocation
zonation	17	14	1072	3	zonation

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	146162	0.420	425454.8
2	DLD Change Limit	146162	224	7.453	19611.2
3	Display Results	224	224	0.093	2408.6
	(SQL Overall)	178691	224	7.966	22431.7