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

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

208 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
illation	8	3	1194	(None)
illations	9	3	1139	1	illations
ablation	10	3	1243	2	ablation
alation	7	29	2055	2	_alation
ciliation	11	11	1249	2	ciliation
collation	11	3	1399	2	collation
delation	9	23	1808	2	delation
dilation	9	22	1546	2	dilation
elation	7	36	2045	2	_elation
fellation	12	3	884	2	fellation
filiation	12	11	1024	2	filiation
gelation	9	30	1443	2	gelation
halation	11	3	1385	2	halation
ideation	9	3	1049	2	ideation
illative	11	4	718	2	illative
illusion	8	4	657	2	illusion
inflation	12	3	1109	2	inflation
iodation	9	3	1038	2	iodation
isolation	9	3	1164	2	isolation
lallation	9	3	949	2	lallation
libation	10	24	1136	2	libation
ligation	9	23	1309	2	ligation
oblation	10	3	986	2	oblation
relation	8	26	1977	2	relation
siltation	9	3	921	2	siltation
solation	8	9	1615	2	solation
ululation	9	3	809	2	ululation
vallation	12	3	974	2	vallation
violation	12	3	844	2	violation
ablations	11	3	1150	3	ablations
ablution	10	4	722	3	ablution
acylation	14	4	864	3	acylation
adnation	9	3	1078	3	adnation
adulation	10	3	1101	3	adulation
aeration	8	3	1993	3	aeration
agnation	9	3	1171	3	agnation
alations	8	25	1889	3	_alations
alkylation	17	4	382	3	alkylation
allantoin	9	8	453	3	allantoin
allegation	11	4	681	3	allegation
allocation	12	4	857	3	allocation
allusion	8	4	657	3	allusion
alluvion	11	4	473	3	alluvion
aviation	11	3	1274	3	aviation
bilection	13	15	680	3	bilection
billion	9	22	1216	3	bill__ion
bilocation	14	4	612	3	bilocation
cation	8	39	2550	3	__cation
chelation	14	3	996	3	chelation
ciliations	12	11	1099	3	ciliations
citation	10	3	1436	3	citation
clarion	9	3	1166	3	_clarion
clavation	14	4	700	3	clavation
collations	12	3	1284	3	collations
conation	10	14	2088	3	conation
creation	10	28	1651	3	creation
dealation	10	3	1300	3	dealation
deflation	13	3	1065	3	deflation
delations	10	26	1659	3	delations
deletion	9	20	1197	3	deletion
dictation	12	8	1056	3	dictation
dilatation	11	4	739	3	dilatation
dilations	10	26	1445	3	dilations
dilution	9	23	914	3	dilution
donation	9	15	1378	3	donation
dotation	9	14	1273	3	dotation
duration	9	3	1269	3	duration
elations	8	37	1912	3	_elations
election	10	20	1535	3	election
elevation	12	3	923	3	elevation
elution	7	29	1382	3	_elution
emulation	11	3	1239	3	emulation
enation	7	34	1923	3	_enation
epilation	11	3	1296	3	epilation
equation	17	3	1048	3	equation
etiolation	10	4	853	3	etiolation
fellatio	11	4	568	3	fellatio_
fellations	13	3	806	3	fellations
fellatios	12	4	550	3	fellatios
fetation	11	6	1314	3	fetation
filiations	13	11	909	3	filiations
filtration	13	4	643	3	filtration
fixation	18	3	707	3	fixation
flatiron	11	4	462	3	_flatiron
flection	13	23	956	3	flection
flotation	12	6	781	3	flotation
foliation	12	11	1079	3	foliation
gelatin	8	35	1473	3	gelati_n
gelations	10	25	1309	3	gelations
gyration	12	3	776	3	gyration
halations	12	3	1239	3	halations
himation	13	3	974	3	himation
ideations	10	3	990	3	ideations
ignition	9	4	653	3	ignition
illatives	12	4	552	3	illatives
illitic	9	3	925	3	illiti_c
illusions	9	4	621	3	illusions
illuviation	14	5	357	3	ill~~uvi~~ation
imitation	11	5	1085	3	imitation
immolation	14	4	610	3	immolation
impaction	15	4	573	3	impaction
impletion	13	4	540	3	impletion
inaction	10	3	962	3	inaction
incaution	11	4	658	3	incaution
inflations	13	3	1032	3	inflations
inhalation	13	10	765	3	inhalation
insolation	10	4	1021	3	insolation
insulation	10	3	1166	3	insulation
invasion	11	11	547	3	invasion
iodations	10	3	911	3	iodations
isatin	6	4	1221	3	i_sati_n
isolations	10	3	1068	3	isolations
iteration	9	5	1503	3	iteration
jillion	14	18	892	3	jill__ion
kation	10	43	1568	3	__kation
lallations	10	3	874	3	lallations
latino	6	41	2047	3	__latino
lavation	11	3	997	3	lavation
laxation	15	3	842	3	laxation
lection	9	26	1486	3	_lection
legation	9	24	1293	3	legation
libations	11	25	1044	3	libations
libration	11	15	1016	3	libration
ligations	10	21	1198	3	ligations
lineation	9	3	1076	3	lineation
liquation	18	4	655	3	liquation
lobation	10	21	1055	3	lobation
location	10	21	1391	3	location
lotion	6	57	1652	3	__lotion
lunation	8	3	1192	3	lunation
luxation	15	3	823	3	luxation
malathion	14	4	451	3	malathion
migration	12	17	969	3	migration
million	9	18	1313	3	mill__ion
mutation	10	14	1288	3	mutation
natation	8	15	1393	3	natation
nation	6	43	2280	3	__nation
negation	9	29	1302	3	negation
nictation	11	8	927	3	nictation
nidation	9	4	1058	3	nidation
nitration	9	3	1344	3	nitration
notation	8	14	1460	3	notation
novation	11	17	1001	3	novation
nutation	8	15	1310	3	nutation
oblations	11	3	936	3	oblations
olfaction	14	6	423	3	olfaction
oration	7	16	1771	3	_oration
oscillation	13	4	549	3	~~osc~~illation
ovation	10	15	1002	3	_ovation
ovulation	12	3	898	3	ovulation
palliation	12	4	850	3	palliation
palmation	13	3	1022	3	palmation
palpation	13	3	907	3	palpation
peltation	11	3	1296	3	peltation
pillion	9	20	1169	3	pill__ion
pinnation	11	3	801	3	pinnation
pixilation	19	4	591	3	pixilation
placation	13	3	977	3	placation
planation	11	3	1012	3	planation
platoon	9	3	895	3	_platoon
plication	13	3	1168	3	plication
pollution	11	4	600	3	pollution
potation	10	17	1678	3	potation
pulsation	11	3	714	3	pulsation
pupation	12	6	950	3	pupation
ration	6	42	2601	3	__ration
reflation	12	4	1233	3	reflation
relations	9	24	1833	3	relations
rogation	9	16	1205	3	rogation
rotation	8	16	1545	3	rotation
saltation	9	3	1200	3	saltation
salvation	12	3	929	3	salvation
scalation	11	3	1107	3	scalation
sedation	9	3	1245	3	sedation
sibilation	12	12	877	3	sibilation
siltations	10	3	854	3	siltations
simulation	12	6	958	3	simulation
sinuation	9	3	1041	3	sinuation
situation	9	4	942	3	situation
solations	9	8	1462	3	solations
solution	8	8	959	3	solution
solvation	12	3	777	3	solvation
spallation	12	4	702	3	spallation
station	7	27	1724	3	_station
sublation	11	3	1101	3	sublation
sudation	9	3	1080	3	sudation
sulcation	11	7	1073	3	sulcation
sulfation	12	8	878	3	sulfation
taxation	15	3	799	3	taxation
titillation	11	4	504	3	~~tit~~illation
titration	9	3	1054	3	titration
ululations	10	3	714	3	ululations
vacation	13	19	1189	3	vacation
vacillation	16	4	529	3	~~vac~~illation
vallations	13	3	908	3	vallations
valuation	12	4	997	3	valuation
venation	11	5	1350	3	venation
vexation	18	3	878	3	vexation
vibration	14	13	820	3	vibration
villain	10	3	847	3	villa_i_n
villatic	13	4	622	3	villati_c
violations	13	3	796	3	violations
vitiation	12	3	956	3	vitiation
vocation	13	23	1198	3	vocation
volition	11	7	917	3	volition
volution	11	9	860	3	volution
zillion	16	18	876	3	zill__ion
zonation	17	14	1072	3	zonation

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	146162	0.186	960704.3
2	DLD Change Limit	146162	208	9.063	16127.3
3	Display Results	208	208	0.076	2736.8
	(SQL Overall)	178691	208	9.325	19162.6