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

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

337 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
vision	9	3	1131	(None)
virion	9	3	1068	1	virion
visions	10	3	1102	1	visions
basion	8	43	1585	2	basion
bison	7	57	1698	2	bis_on
division	12	6	668	2	division
elision	7	23	1110	2	elision
envision	11	4	595	2	envision
evasion	10	3	675	2	evasion
fission	10	3	873	2	fission
fusion	9	3	977	2	fusion
inion	5	46	2017	2	_inion
lesion	6	47	1506	2	lesion
minion	8	34	1623	2	minion
mission	9	3	1274	2	mission
nasion	6	39	1408	2	nasion
pinion	8	38	1589	2	pinion
piston	8	35	1592	2	piston
revision	11	3	871	2	revision
version	10	3	1092	2	version
vibrion	12	4	525	2	vibrion
vidicon	13	4	378	2	vidicon
virions	10	3	987	2	virions
vising	10	39	1587	2	vising
visional	11	4	666	2	visional
visioned	12	4	700	2	visioned
visit	8	3	2096	2	visi_t
visitor	10	4	620	2	visitor
visits	9	3	1142	2	visits
visive	12	5	787	2	visive
visor	8	25	1283	2	vis_or
action	8	47	1968	3	action
amnion	8	48	1204	3	amnion
anion	5	50	2881	3	_anion
arsino	6	41	1351	3	arsino
arson	5	51	1883	3	ars_on
assign	7	3	678	3	assign
aversion	11	4	731	3	aversion
aviation	11	3	1274	3	aviation
avidin	10	35	1084	3	avidi_n
avion	8	42	1834	3	_avion
aviso	8	57	1396	3	avis_o_
avisos	9	54	1048	3	avis_os
avulsion	11	5	386	3	avulsion
axion	12	113	1691	3	_axion
basin	7	50	2692	3	basi_n
basions	9	42	1395	3	basions
bastion	9	3	1247	3	bastion
bicron	10	37	1077	3	bicron
billion	9	22	1216	3	billion
billon	8	37	1382	3	billon
bishop	13	3	694	3	bishop
bisons	8	39	1437	3	bis_ons
boson	7	60	1973	3	bos_on
boston	8	5	1304	3	boston
bunion	8	31	1131	3	bunion
caisson	9	3	659	3	caisson
camion	10	39	1719	3	camion
casino	8	43	1755	3	casino
cation	8	39	2550	3	cation
cession	9	3	981	3	cession
cion	6	133	3091	3	__cion
cisco	9	51	1213	3	cisco_
ciscos	10	47	1113	3	ciscos
cistron	9	29	988	3	cistron
citron	8	31	1298	3	citron
coition	9	3	1431	3	coition
cosign	9	5	878	3	cosign
cushion	12	3	640	3	cushion
decision	11	4	852	3	decision
derision	9	3	906	3	derision
design	8	40	893	3	design
diction	10	23	1305	3	diction
disco	8	56	1607	3	disco_
discos	9	49	1521	3	discos
disjoin	15	4	764	3	disjoin
dislimn	10	5	610	3	dislimn
disown	10	3	695	3	disown
disunion	9	5	611	3	disunion
diuron	7	3	857	3	diuron
divisions	13	9	628	3	divisions
durion	7	5	1096	3	durion
edition	8	3	1085	3	edition
eikon	9	3	946	3	ei_kon
elisions	8	22	1042	3	elisions
elusion	7	23	1095	3	elusion
emission	10	4	767	3	emission
ensign	7	3	752	3	ensign
envisions	12	4	561	3	envisions
eosin	5	52	2092	3	eosi_n
epsilon	9	4	429	3	epsilon
erasion	7	3	1196	3	erasion
erosion	7	3	1110	3	erosion
essoin	6	3	819	3	essoin
ethion	9	3	881	3	ethion
evasions	11	3	654	3	evasions
eversion	11	3	871	3	eversion
eviction	13	22	868	3	eviction
evulsion	11	5	506	3	evulsion
excision	17	4	627	3	excision
fanion	9	45	1432	3	fanion
fashion	13	3	784	3	fashion
ficin	10	35	1671	3	fici_n
fiction	12	20	1072	3	fiction
fissions	11	3	803	3	fissions
foison	9	4	893	3	fois_on
frisson	10	4	531	3	frisson
fusions	10	3	915	3	fusions
gabion	9	32	1102	3	gabion
gascon	9	33	972	3	gascon
gibbon	11	3	532	3	gibbon
gibson	9	3	512	3	gibson
gipon	8	42	1241	3	gi_pon
giron	6	61	1899	3	gi_ron
gismo	8	4	886	3	gismo_
gismos	9	5	718	3	gismos
gonion	7	36	1283	3	gonion
grison	7	3	1010	3	gris_on
hisn	7	96	2093	3	his__n
histone	10	3	1284	3	histone
hyson	11	3	869	3	hys_on
icon	6	69	2204	3	_i_con
idiom	8	9	995	3	_idiom
idiot	6	7	1885	3	_idiot
ikon	8	58	1495	3	_i_kon
imino	7	43	1521	3	_imino
incision	10	4	759	3	incision
inions	6	44	1700	3	_inions
invasion	11	11	547	3	invasion
ion	3	60	5102	3	___ion
iron	4	67	2846	3	_i_ron
isogon	7	22	754	3	_isogon
jillion	14	18	892	3	jillion
kation	10	43	1568	3	kation
kinin	9	49	1732	3	kini_n
legion	7	57	1298	3	legion
lesions	7	38	1386	3	lesions
lesson	6	44	1204	3	lesson
liaison	7	4	447	3	liaison
linin	5	80	2552	3	lini_n
lion	4	63	3444	3	__lion
lipin	7	55	1889	3	lipi_n
lissom	8	3	740	3	lissom
listen	6	48	1681	3	listen
logion	7	60	1372	3	logion
lotion	6	57	1652	3	lotion
lysin	8	45	1278	3	lysi_n
mansion	9	6	1154	3	mansion
mascon	10	36	1274	3	mascon
mason	7	48	2018	3	mas_on
mesian	8	43	1550	3	mesian
meson	7	41	1831	3	mes_on
micron	10	37	1428	3	micron
midiron	10	4	600	3	midiron
mignon	9	3	795	3	mignon
mikron	12	31	850	3	mikron
million	9	18	1313	3	million
minions	9	33	1462	3	minions
mirin	7	50	2314	3	miri_n
miscoin	11	3	1142	3	miscoin
misdo	8	54	1318	3	misdo_
misdone	10	3	1085	3	misdone
misjoin	16	3	769	3	misjoin
miso	6	72	2989	3	mis_o_
misos	7	65	2329	3	mis_os
mispen	10	3	1217	3	mispen
missions	10	3	1190	3	missions
misunion	10	8	494	3	misunion
morion	8	62	1773	3	morion
motion	8	52	1755	3	motion
nasions	7	31	1238	3	nasions
nation	6	43	2280	3	nation
ninon	5	55	1738	3	ni_non
nisi	4	58	2324	3	nisi__
niton	5	54	1828	3	ni_ton
notion	6	45	1658	3	notion
omission	10	4	653	3	omission
onion	5	43	2097	3	_onion
opinion	9	4	679	3	opinion
opsin	7	6	1347	3	opsi_n
option	8	36	1271	3	option
orison	6	4	1166	3	oris_on
ovation	10	15	1002	3	ovation
passion	9	3	1088	3	passion
pavilion	13	4	490	3	pavilion
pension	9	4	1220	3	pension
pigeon	9	4	941	3	pigeon
pillion	9	20	1169	3	pillion
pinions	9	34	1360	3	pinions
pinon	7	60	2453	3	pi_non
pinyon	11	45	976	3	pinyon
pion	6	72	3529	3	__pion
pisco	9	63	1498	3	pisco_
piscos	10	51	1259	3	piscos
piso	6	67	2756	3	pis_o_
pisos	7	60	2106	3	pis_os
pistol	8	33	1333	3	pistol
pistons	9	30	1637	3	pistons
pistou	8	32	1184	3	pistou
piton	7	61	2158	3	pi_ton
plosion	9	3	911	3	plosion
poison	8	3	1222	3	pois_on
potion	8	45	1957	3	potion
prevision	14	4	800	3	~~pre~~vision
prion	7	51	1999	3	_prion
prison	8	5	1402	3	pris_on
provision	14	4	763	3	~~pro~~vision
pulsion	9	3	839	3	pulsion
raisin	6	27	1692	3	raisi_n
ration	6	42	2601	3	ration
recision	10	3	1027	3	recision
region	7	46	1490	3	region
resign	7	42	1258	3	resign
resin	5	41	3105	3	resi_n
revisions	12	3	859	3	revisions
ribbon	10	3	653	3	ribbon
ricin	7	46	2021	3	rici_n
risen	5	46	2188	3	ris_en
rising	7	40	2588	3	rising
ronion	6	33	1564	3	ronion
rosin	5	53	2531	3	rosi_n
sasin	5	46	2657	3	sasi_n
scion	7	22	1499	3	_scion
scission	10	4	556	3	scission
seisin	6	37	1512	3	seisi_n
session	7	3	974	3	session
sign	5	55	2305	3	__sign
silicon	9	11	751	3	silicon
simian	8	8	1115	3	simian
simoon	8	5	806	3	simoon
sin	3	62	6589	3	__si_n
siphon	11	3	846	3	siphon
siskin	10	7	978	3	siskin
solion	6	6	1638	3	solion
son	3	77	6195	3	__s_on
soon	4	62	4050	3	__soon
suasion	7	3	936	3	suasion
talion	6	3	1771	3	talion
tension	7	3	1180	3	tension
teston	6	3	1330	3	teston
tiglon	7	3	791	3	tiglon
tigon	6	39	1444	3	ti_gon
titian	6	25	1266	3	titian
torsion	7	3	1080	3	torsion
tuition	7	3	882	3	tuition
turion	6	3	1316	3	turion
union	5	45	1979	3	_union
unison	6	4	903	3	unis_on
upsilon	9	4	358	3	upsilon
vain	7	52	3300	3	v_ai_n
vein	7	56	2575	3	v_ei_n
venin	8	51	1866	3	veni_n
venison	10	3	644	3	venison
versions	11	3	1035	3	versions
vesica	11	15	791	3	vesica
viator	9	32	1183	3	viator
vibist	11	6	1057	3	vibist
vibrio	11	3	622	3	vibrio_
vibrions	13	4	509	3	vibrions
vibrios	12	3	580	3	vibrios
vicing	12	40	1424	3	vicing
vicious	12	3	949	3	vicious
victor	11	32	1067	3	victor
video	9	60	1495	3	video_
videos	10	49	1137	3	videos
vidicons	14	4	386	3	vidicons
vigia	9	48	1327	3	vigi_a
vigias	10	41	1089	3	vigias
vigil	9	43	1300	3	vigi_l
vigils	10	42	1019	3	vigils
vigor	9	26	1242	3	vi_gor
viking	14	34	1461	3	viking
vilify	15	3	677	3	vilify
vimen	10	41	1475	3	vi_men
vimina	11	33	993	3	vimina
vinic	10	3	1497	3	vini_c
vinier	9	37	1674	3	vinier
vinify	15	3	692	3	vinify
vining	10	46	1946	3	vining
vino	7	61	2843	3	vi_no_
vinos	8	47	2307	3	vi_nos
viol	7	65	2359	3	v__iol
violin	9	3	1198	3	violin
violone	10	3	715	3	violone
vireo	8	48	1645	3	vireo_
vireos	9	42	1245	3	vireos
virgin	10	3	808	3	virgin
virid	9	41	1604	3	viri_d
virile	9	3	1343	3	virile
viroid	10	4	1152	3	viroid
vis	6	67	4761	3	vis___
visa	7	63	2387	3	vis__a
visaed	10	41	1050	3	visaed
visage	10	4	908	3	visage
visaing	11	27	933	3	visaing
visard	10	39	1012	3	visard
visas	8	43	1765	3	vis_as
viscid	12	3	747	3	viscid
viscoid	13	3	701	3	viscoid
viscose	12	3	786	3	viscose
viscount	13	9	678	3	viscount
viscous	12	3	883	3	viscous
viscus	11	42	850	3	viscus
vise	7	56	3267	3	vis__e
vised	9	55	1876	3	vis_ed
viseed	10	53	1098	3	viseed
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	402	3	vision~~ary~~
visioning	13	4	706	3	visioning
visitant	11	4	736	3	visitant
visited	11	6	877	3	visited
visiter	10	3	886	3	visiter
visiting	12	3	839	3	visiting
visitors	11	4	643	3	visitors
visors	9	29	1222	3	visors
vista	8	54	1660	3	vis_ta
vistas	9	45	1327	3	vistas
visual	9	3	880	3	visual
vitriol	10	4	569	3	vitriol
vivid	12	51	1231	3	vivi_d
vivify	18	3	470	3	vivify
vixen	15	30	1002	3	vi_xen
vizier	18	43	1102	3	vizier
vizir	17	35	939	3	vizi_r
vizirs	18	30	671	3	vizirs
vizor	17	30	1009	3	vi_zor
volition	11	7	917	3	volition
voudon	10	3	587	3	voudon
wanion	9	32	1306	3	wanion
wigeon	10	3	722	3	wigeon
wisdom	12	3	598	3	wisdom
wising	10	33	1822	3	wising
zillion	16	18	876	3	zillion
zircon	17	5	495	3	zircon

Search took 6 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	112716	0.140	1276364.3
2	DLD Change Limit	112716	337	5.110	22057.9
3	Display Results	337	337	0.110	3063.6
	(SQL Overall)	178691	337	5.360	33337.9