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

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

311 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
visions	10	3	1102	(None)
virions	10	3	987	1	virions
vision	9	3	1131	1	vision_
basions	9	42	1395	2	basions
bisons	8	39	1437	2	bis_ons
divisions	13	9	628	2	divisions
elisions	8	22	1042	2	elisions
envisions	12	4	561	2	envisions
evasions	11	3	654	2	evasions
fissions	11	3	803	2	fissions
fusions	10	3	915	2	fusions
inions	6	44	1700	2	_inions
lesions	7	38	1387	2	lesions
minions	9	33	1462	2	minions
missions	10	3	1190	2	missions
nasions	7	31	1238	2	nasions
pinions	9	34	1360	2	pinions
pistons	9	30	1637	2	pistons
revisions	12	3	859	2	revisions
versions	11	3	1035	2	versions
vibrions	13	4	509	2	vibrions
vicious	12	3	949	2	vicious
vidicons	14	4	386	2	vidicons
virion	9	3	1068	2	virion_
viscous	12	3	883	2	viscous
vising	10	39	1587	2	visi_ng
visional	11	4	666	2	visional
visioned	12	4	701	2	visioned
visitors	11	4	643	2	visitors
visits	9	3	1142	2	visi_ts
visors	9	29	1222	2	vis_ors
actions	9	42	1851	3	actions
amnions	9	37	1091	3	amnions
anions	6	41	2303	3	_anions
arsons	6	39	1721	3	ars_ons
assigns	8	3	619	3	assigns
aversions	12	4	705	3	aversions
aviations	12	3	1155	3	aviations
avidins	11	34	900	3	avidi_ns
avions	9	41	1439	3	_avions
avisos	9	54	1048	3	avis_o_s
avulsions	12	4	326	3	avulsions
axions	13	47	1348	3	_axions
basins	8	57	2276	3	basi_ns
basion	8	43	1585	3	basion_
bastions	10	4	1169	3	bastions
bicrons	11	34	1047	3	bicrons
bilious	9	3	1093	3	bilious
billions	10	22	1179	3	billions
billons	9	30	1336	3	billons
bishops	14	3	703	3	bishops
bison	7	57	1698	3	bis_on_
bosons	8	50	1665	3	bos_ons
bostons	9	3	1290	3	bostons
bunions	9	22	1047	3	bunions
caissons	10	3	628	3	caissons
camions	11	39	1613	3	camions
casinos	9	35	1283	3	casinos
cations	9	45	2414	3	cations
cessions	10	3	985	3	cessions
cions	7	52	2285	3	__cions
ciscoes	11	36	1073	3	ciscoes
ciscos	10	47	1113	3	cisco_s
cistrons	10	27	1064	3	cistrons
citrons	9	29	1322	3	citrons
coitions	10	3	1285	3	coitions
cosigns	10	4	751	3	cosigns
cushions	13	3	569	3	cushions
decisions	12	4	838	3	decisions
derisions	10	3	884	3	derisions
designs	9	32	831	3	designs
dictions	11	18	1267	3	dictions
discos	9	49	1521	3	disco_s
disjoins	16	4	762	3	disjoins
dislimns	11	4	481	3	dislimns
disowns	11	3	673	3	disowns
disunions	10	5	597	3	disunions
diurons	8	3	882	3	diurons
division	12	6	668	3	division_
durions	8	3	996	3	durions
editions	9	3	1040	3	editions
eikons	10	3	850	3	ei_kons
elision	7	23	1110	3	elision_
elusions	8	26	1008	3	elusions
emissions	11	4	692	3	emissions
ensigns	8	3	635	3	ensigns
envision	11	4	595	3	envision_
eosins	6	44	1916	3	eosi_ns
epsilons	10	4	422	3	epsilons
erasions	8	3	1098	3	erasions
erosions	8	3	1034	3	erosions
essoins	7	3	760	3	essoins
ethions	10	3	848	3	ethions
evasion	10	3	675	3	evasion_
eversions	12	3	836	3	eversions
evictions	14	22	862	3	evictions
evulsions	12	5	457	3	evulsions
excisions	18	4	638	3	excisions
fanions	10	37	1307	3	fanions
fashions	14	3	724	3	fashions
ficins	11	35	1398	3	fici_ns
fictions	13	24	1074	3	fictions
fission	10	3	873	3	fission_
foisons	10	4	761	3	fois_ons
frissons	11	4	504	3	frissons
fusion	9	3	977	3	fusion_
gabions	10	24	1005	3	gabions
gascons	10	28	910	3	gascons
gibbons	12	3	498	3	gibbons
gibsons	10	4	504	3	gibsons
gipons	9	38	960	3	gi_pons
girons	7	50	1437	3	gi_rons
gismos	9	5	718	3	gismo_s
grisons	8	3	899	3	gris_ons
histone	10	3	1284	3	histone
histones	11	3	1280	3	histones
hysons	12	3	763	3	hys_ons
icons	7	65	1649	3	_i_cons
idioms	9	5	641	3	_idioms
idiots	7	6	864	3	_idiots
ikons	9	63	1101	3	_i_kons
incisions	11	4	735	3	incisions
inion	5	46	2018	3	_inion_
invasions	12	11	541	3	invasions
ions	4	67	3785	3	___ions
irons	5	53	2413	3	_i_rons
isogons	8	21	761	3	_isogons
jillions	15	17	828	3	jillions
kations	11	40	1366	3	kations
kinins	10	40	1458	3	kini_ns
legions	8	46	1178	3	legions
lesion	6	47	1506	3	lesion_
lessons	7	38	1102	3	lessons
liaisons	8	4	429	3	liaisons
linins	6	59	2214	3	lini_ns
lions	5	59	2321	3	__lions
lipins	8	50	1688	3	lipi_ns
listens	7	40	1413	3	listens
logions	8	62	1129	3	logions
lotions	7	46	1476	3	lotions
lysins	9	46	1095	3	lysi_ns
mansions	10	6	979	3	mansions
mascons	11	34	1158	3	mascons
masons	8	39	1651	3	mas_ons
mesons	8	32	1584	3	mes_ons
microns	11	38	1478	3	microns
midirons	11	4	588	3	midirons
mignons	10	3	786	3	mignons
mikrons	13	42	841	3	mikrons
millions	10	17	1243	3	millions
minion	8	34	1624	3	minion_
mirins	8	39	1890	3	miri_ns
miscoins	12	3	1108	3	miscoins
misdoes	10	3	1249	3	misdoes
misdone	10	3	1086	3	misdone
misjoins	17	3	691	3	misjoins
misos	7	65	2329	3	mis_o_s
mispens	11	3	1107	3	mispens
mission	9	3	1274	3	mission_
misunions	11	5	453	3	misunions
morions	9	40	1464	3	morions
motions	9	42	1500	3	motions
nasion	6	39	1408	3	nasion_
nations	7	47	2056	3	nations
nimious	9	3	766	3	nimious
ninons	6	49	1377	3	ni_nons
nitons	6	46	1490	3	ni_tons
notions	7	40	1448	3	notions
omissions	11	4	615	3	omissions
onions	6	40	1643	3	_onions
opinions	10	4	593	3	opinions
opsins	8	4	1171	3	opsi_ns
options	9	38	1060	3	options
orisons	7	3	1056	3	oris_ons
ovations	11	14	926	3	ovations
passions	10	3	1058	3	passions
pavilions	14	4	481	3	pavilions
pensions	10	3	1169	3	pensions
pigeons	10	3	918	3	pigeons
pillions	10	16	1093	3	pillions
pinion	8	38	1589	3	pinion_
pinons	8	60	1994	3	pi_nons
pinyons	12	29	900	3	pinyons
pions	7	58	2639	3	__pions
piscos	10	51	1259	3	pisco_s
pisos	7	60	2106	3	pis_o_s
pistols	9	32	1398	3	pistols
piston	8	35	1592	3	piston_
pistous	9	27	1438	3	pistous
pitons	8	53	1904	3	pi_tons
plosions	10	3	802	3	plosions
poisons	9	3	1035	3	pois_ons
potions	9	34	1742	3	potions
previsions	15	4	773	3	~~pre~~visions
prions	8	43	1778	3	_prions
prisons	9	3	1322	3	pris_ons
provisions	15	4	721	3	~~pro~~visions
pulsions	10	3	771	3	pulsions
raisins	7	27	1534	3	raisi_ns
rations	7	41	2343	3	rations
recisions	11	3	991	3	recisions
regions	8	36	1347	3	regions
resigns	8	39	1096	3	resigns
resins	6	45	2877	3	resi_ns
revision	11	3	871	3	revision_
ribbons	11	3	625	3	ribbons
ricins	8	36	1870	3	rici_ns
rising	7	40	2588	3	risi_ng
risings	8	32	1189	3	risings
ronions	7	33	1334	3	ronions
rosins	6	45	2186	3	rosi_ns
sasins	6	49	2310	3	sasi_ns
scions	8	26	1224	3	_scions
scissions	11	4	543	3	scissions
seisins	7	36	1439	3	seisi_ns
sessions	8	3	972	3	sessions
signs	6	55	1632	3	__signs
silicons	10	10	716	3	silicons
simians	9	5	920	3	simians
simious	9	3	980	3	simious
simoons	9	3	794	3	simoons
sins	4	67	5528	3	__si_ns
siphons	12	3	935	3	siphons
siskins	11	5	958	3	siskins
solions	7	5	1375	3	solions
sons	4	60	4955	3	__s_ons
suasions	8	3	878	3	suasions
talions	7	3	1411	3	talions
tensions	8	3	1022	3	tensions
testons	7	3	1356	3	testons
tiglons	8	3	734	3	tiglons
tigons	7	41	1226	3	ti_gons
titians	7	27	1045	3	titians
torsions	8	3	918	3	torsions
tuitions	8	3	828	3	tuitions
turions	7	3	1157	3	turions
unions	6	42	1675	3	_unions
unisons	7	4	842	3	unis_ons
upsilons	10	4	317	3	upsilons
various	10	31	1310	3	various
veins	8	46	2049	3	v_ei_ns
venins	9	38	1670	3	veni_ns
venisons	11	3	613	3	venisons
version	10	3	1092	3	version_
viators	10	27	1202	3	viators
vibists	12	5	648	3	vibists
vibrion	12	4	525	3	vibrion_
vibrios	12	3	580	3	vibrio_s
vicing	12	40	1424	3	vici_ng
victors	12	33	1118	3	victors
videos	10	49	1137	3	video_s
vidicon	13	4	378	3	vidicon_
vigias	10	41	1089	3	vigi_as
vigils	10	42	1019	3	vigi_ls
vigors	10	29	1148	3	vi_gors
viking	14	34	1461	3	viki_ng
vikings	15	38	662	3	vikings
villous	10	28	1002	3	villous
vimina	11	33	994	3	vimi_na
vining	10	46	1946	3	vini_ng
vinos	8	47	2307	3	vi_no_s
vinous	9	39	1417	3	vi_nous
violins	10	3	1145	3	violins
violone	10	3	715	3	violone
violones	11	3	738	3	violones
viols	8	61	1810	3	v__iols
vireos	9	42	1245	3	vireo_s
virgins	11	3	786	3	virgins
viroids	11	3	792	3	viroids
visages	11	3	869	3	visages
visaing	11	27	933	3	visaing
visards	11	32	815	3	visards
visas	8	43	1765	3	vis__as
viscoid	13	3	702	3	viscoid
viscose	12	3	786	3	viscose
viscoses	13	3	834	3	viscoses
viscount	13	9	678	3	viscount
viscounts	14	8	458	3	viscounts
viscus	11	42	850	3	vis_cus
viseing	11	29	916	3	viseing
vises	8	44	2777	3	vis__es
visible	12	3	692	3	visible
visibly	15	3	504	3	visibly
visionary	15	4	403	3	visionary
visioning	13	4	706	3	visioning
visionless	13	4	296	3	vision~~les~~s
visit	8	3	2096	3	visi__t
visitant	11	4	736	3	visitant
visitants	12	4	476	3	visitants
visited	11	6	877	3	visited
visiter	10	3	886	3	visiter
visiters	11	3	741	3	visiters
visiting	12	3	839	3	visiting
visitor	10	4	620	3	visitor
visive	12	5	787	3	visi_ve
visor	8	25	1283	3	vis_o_r
vistas	9	45	1327	3	vis_tas
visuals	10	3	686	3	visuals
vitriols	11	4	505	3	vitriols
vixens	16	28	620	3	vi_xens
viziers	19	33	620	3	viziers
vizirs	18	30	671	3	vizi_rs
vizors	18	32	890	3	vi_zors
volitions	12	8	866	3	volitions
voudons	11	3	532	3	voudons
wanions	10	40	1137	3	wanions
wigeons	11	3	698	3	wigeons
wisdoms	13	3	545	3	wisdoms
wising	10	33	1822	3	wisi_ng
zillions	17	16	807	3	zillions
zircons	18	5	496	3	zircons

Search took 7 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	134027	0.393	454684.5
2	DLD Change Limit	134027	311	5.966	22465.1
3	Display Results	311	311	0.110	2827.3
	(SQL Overall)	178691	311	6.469	27622.7