Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

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

226 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
version1031092(None) 
aversion1147311aversion
eversion1138711eversion
versions11310351versions
aversions1247052aversions
cession939812cession
derision939072derision
diversion1346452diversion
emersion1047732emersion
erasion7311962_erasion
erosion7311122_erosion
evasion1036752evasion
eversions1238362eversions
fermion1236762fermion
inversion1247212inversion
lesion64715062le_sion
obversion1444732obversion
oversoon1138302oversoon
pension9412202pension
pereion9312052pereion
person83517872pers_on
reversion1248092reversion
session739762session
tension7311802tension
ternion739492ternion
torsion7310802torsion
venison1036442venison
verdin103113022verdi_n
vermian12329712vermian
vermin113414522vermi_n
versify1636332versify
versine102515172versine
versing112314192versing
versional1245862versional
verso85314632vers_o_
versos93812802vers_os
virion9310682vir_ion
vision9311312v_ision
abrasion1046623abrasion
aeration8319933aeration
arsino64113513_arsino
arson55118833_ars_on
aspersion1146163aspersion
aversive1447443aversive
avulsion1153863avulsion
basion84315853_basion
benison937123benison
berlin83116373berli_n
carrion9312673carrion
cessions1039853cessions
coercion1246573coercion
conversion1548423conversion
decision1148523decision
delusion937433delusion
deraign936573deraign
derisions1038843derisions
design8408933de_sign
detrusion1044383detrusion
diversions1446533diversions
durion7510963dur_ion
elision72311103elision
elusion72310953elusion
emersions1147283emersions
ensign737523_ensign
eosin55220923_eosi_n
epsilon944293_epsilon
erasions8310983_erasions
erosions8310343_erosions
essoin638193_essoin
ethion938813_ethion
evasions1136543evasions
evection131910833evection
evulsion1155063evulsion
exertion15310083exertion
fermions1336203fermions
fission1038733fission
fusion939773_fusion
grison7310103_grison
hellion10311133hellion
herein93717793herei_n
hereon93914363her_eon
heriot9422343her_iot
heroin94420593heroi_n
heron85025503her__on
hessian1035853hessian
immersion1344283immersion
inversions1347003inversions
jerkin17258113jerki_n
kelson1038153kels_on
lection92614863lection
legion75712983le_gion
lesions73813873le_sions
lesson64412043le_sson
mansion9611543mansion
mention9314373mention
merino8315093mer_ino
merlin83916683merli_n
merlon83012353mer_lon
mesian84315503me_sian
meson74118313me_s_on
mission9312743mission
morion86217733mor_ion
morrion959003morrion
nasion63914083_nasion
nelson638423nels_on
neuston736083neuston
obversions1544513obversions
orison6411663_orison
overseen112612173overseen
oversewn14266933oversewn
overshoe1438563overshoe
overshot1449433overshot
oversick1736983oversick
overside122013933overside
oversize201812513oversize
overslow1435693overslow
overspin1338203overspin
parson83817903pars_on
passion9310883passion
pensione1039773pensione
pensions10311693pensions
pepsin10310853pepsi_n
pereions10310853pereions
pereon83517453per_eon
perfusion14105883perfusion
perigon1039853perigon
period9314983per_iod
permian112612283permian
pernio8513143pernio_
perron83216623per_ron
persimmon1552083persimmon
persist9315853persist
persona92812453pers_ona
persons93717013pers_ons
pervasion1446073pervasion
perversion1545853perversion
plosion939113plosion
portion9615493portion
prion75119993_pr_ion
prison8514023_prison
pulsion938393pulsion
reason62616333reas_on
recision10310273recision
recursion1146153recursion
region74614903re_gion
rerisen73613643rerisen
resign74212583re_sign
resin54131053re_si_n
retorsion946503retorsion
reunion737673reunion
reversions1347573reversions
revision1138713revision
season62714903seas_on
section92515663section
seisin63715123seisi_n
serein63318463serei_n
serin55434443ser_i_n
sermon8413553ser_mon
sessions839723sessions
suasion739363suasion
subversion1544503subversion
telson6310293tels_on
tensions8310223tensions
ternions838813ternions
tertian7511193tertian
teston6313303te_ston
thermion1345933thermion
torsions839183torsions
turion6313163tur_ion
varsity1356673varsity
vein75625753ve__i_n
venation11513503venation
venin85118663ve_ni_n
venisons1136133venisons
verbid122311313verbi_d
verbids13259203verbids
verbify1834993verbify
verbile1249863verbile
verdict1339583verdict
verdins112812333verdins
verging123812303verging
verier94620963ver_ier
verify153110163ver_ify
verily122616053ver_ily
verism113214263ver_ism
verismo12276393verismo
verismos13284693verismos
verisms123011253verisms
verist93823893ver_ist
verists103613673verists
verite94323443ver_ite
verity123714853ver_ity
vermilion1444333vermilion
vermis114214963vermi_s
vernation12311083vernation
vernier102711273vernier
vernix1636633verni_x
versal93013753vers_al
versant10313833versant
verse84723583vers__e
versed104515523vers_ed
verseman1345383verseman
versemen1346853versemen
verser94516963vers_er
versers103813523versers
verses94223763vers_es
verset94327323vers_et
versets103913103versets
versicle1366583versicle
versines112213823versines
verst84429373vers__t
verste94515633vers_te
verstes104014283verstes
versts93914733vers_ts
versus94211143vers_us
vertigo1146133vertigo
vertigos1254973vertigos
vervain1335563vervain
vesica11157913ve_sica
vexation1838783vexation
vibrion1245253vibrion
virgin1038083virgi_n
virions1039873vir_ions
visions10311023v_isions
warison1037083warison
weason93210823weas_on

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.860207780.2
2DLD Change Limit1340272266.98319193.3
3Display Results2262260.0962354.2
 (SQL Overall)1786912267.93922508.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.