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 “session” 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.

175 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
session73976(None) 
cession939811cession
sessions839721sessions
cessions1039852cessions
essoin638192_essoin
fission1038732fission
hessian1035852hessian
lesion64715062le_sion
lesson64412042less_on
mission9312742mission
obsession1144152obsession
passion9310882passion
pension9412202pension
scission1045562scission
season62714902seas_on
secession1146702secession
section92515662section
seisin63715122seisi_n
sessile739522sessile
sessional946112sessional
suasion739362suasion
tension7311802tension
version10310922version
accession1345233accession
ascension1144703ascension
aspersion1146163aspersion
assign736783_assign
aversion1147313aversion
basion84315853_basion
bassoon937613bassoon
bastion9312473bastion
benison937123benison
cassino93512433cassino
cessation1176853cessation
cessing103814813cessing
cushion1236403cushion
decision1148523decision
delusion937433delusion
demission1246033demission
derision939073derision
design8408933de_sign
egestion946863egestion
egression1046193egression
elision72311103elision
elusion72310953elusion
emersion1047733emersion
emission1047673emission
ensign737523_ensign
eosin55220923_eosi_n
epsilon944293_epsilon
erasion7311963erasion
erosion7311113erosion
essoins737603_essoins
ethion938813_ethion
evasion1036753evasion
eversion1138713eversion
fashion1337843fashion
fermion1236763fermion
fessing113812863fessing
festoon1037673festoon
fissions1138033fissions
fusion939773_fusion
gesso649603gess_o_
gossoon865663gossoon
hellion10311133hellion
hessians1145053hessians
hessite1038993hessite
jessing153710623jessing
kelson1038153kels_on
lection92614863lection
legion75712983le_gion
lesbian944463lesbian
lesions73813873le_sions
lessen64212433less_en
lessons73811023less_ons
lessor64010603less_or
mansion9611543mansion
mention9314373mention
mesian84315503me_sian
meson74118313me_s_on
messan83912063mess_an
messiah1246793messiah
messier93412923messier
messily12298813messily
messing103916393messing
messman1137283messman
messmen1137393messmen
mestino9411643mestino
missions10311903missions
nasion63914083_nasion
nelson638423nels_on
neuston736083neuston
obsessions1244273obsessions
omission1046533omission
passions10310583passions
pensione1039773pensione
pensions10311693pensions
pepsin10310853pepsi_n
pereion9312053pereion
person83517873pers_on
plosion939113plosion
possession1264843possession
pulsion938393pulsion
question1745823question
reason62616333reas_on
reassign955423reassign
recession1149103recession
recision10310273recision
region74614903re_gion
remission1147333remission
resign74212583re_sign
resin54131053re_si_n
reunion737673reunion
revision1138713revision
sasin54626573s_asi_n
sassier73413233sassier
sassies74719263sassies
sassily1038723sassily
sassing84615553sassing
scansion1045693scansion
scion72214993__scion
scissions1145433scissions
seasick1346193seasick
seaside839693seaside
seasons72614233seas_ons
secessions1246463secessions
seclusion1144943seclusion
sections102714703sections
sedation9312453sedation
sedition939333sedition
seising84018863seising
seisins73614393seisins
seisor63712343seis_or
seizin153610853seizi_n
selsyn983843sels_yn
senior63214053se_nior
sensation9510583sensation
sensing84116953sensing
sensor63813843sens_or
sepsis83011293sepsi_s
sequin1538523sequi_n
serein63318463serei_n
serin55434443se_ri_n
sermon8413553se_rmon
sesspool1042873sesspool
sestina72711973sestina
sestine73017923sestine
seton55223543se__ton
sexton133610793se_xton
siskin1079783siski_n
sissier73711363sissier
sissies73716603sissies
solion6616383s_olion
sponsion1045623sponsion
stasimon1042743stasimon
station72717243station
stemson945163stems_on
stepson945673steps_on
stetson745783stets_on
suasions838783suasions
succession1454013succession
suction93713043suction
sussing84013703sussing
symbion1464043symbion
telson6310293tels_on
tensions8310223tensions
ternion739493ternion
teston6313303te_ston
testoon748373testoon
torsion7310803torsion
venison1036443venison
versions11310353versions
vision9311313_vision
weason93210823weas_on
yessing113210063yessing

Search took 7 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.393454684.5
2DLD Change Limit1340271756.11021935.7
3Display Results1751750.0602916.7
 (SQL Overall)1786911756.56327227.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.