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

172 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
sessions83972(None) 
cessions1039851cessions
session739761session_
cession939812cession_
essoins737602_essoins
fissions1138032fissions
hessians1145052hessians
lesions73813862le_sions
lessons73811012less_ons
missions10311902missions
obsessions1244262obsessions
passions10310582passions
pensions10311692pensions
scissions1145432scissions
seasons72614232seas_ons
secessions1246462secessions
sections102714702sections
seisins73614392seisi_ns
sessional946112sessional
suasions838782suasions
tensions8310222tensions
versions11310352versions
accessions1445243accessions
ascensions1244613ascensions
aspersions1246103aspersions
assigns836193_assigns
aversions1247053aversions
basions94213953_basions
bassoons1036543bassoons
bastions10411693bastions
benisons1037043benisons
cassinos10309353cassinos
cessations1256473cessations
cessing103814813cessi_ng
cushions1335693cushions
decisions1248383decisions
delusions1037053delusions
demissions1345663demissions
derisions1038843derisions
designs9328313de_signs
egestions1046703egestions
egressions1146203egressions
elisions82210423elisions
elusions82610083elusions
emersions1147283emersions
emissions1146923emissions
ensigns836353_ensigns
eosins64419163_eosi_ns
epsilons1044223_epsilons
erasions8310983erasions
erosions8310343erosions
essoin638193_essoin_
ethions1038483_ethions
evasions1136543evasions
eversions1238363eversions
fashions1437243fashions
fermions1336203fermions
fessing113812863fessi_ng
festoons1136433festoons
fission1038733fission_
fusions1039153_fusions
gessoes838293gess_oes
gossoons944893gossoons
hellions11310023hellions
hessian1035853hessian_
hessites1138613hessites
jessing153710623jessi_ng
kelsons1137323kels_ons
lections102413843lections
legions84611783le_gions
lesbians1043603lesbians
lesion64715063le_sion_
lessens7409383less_ens
lesson64412043less_on_
lessors73610523less_ors
mansions1069793mansions
mentions10312893mentions
mesons83215843me_s_ons
messans92710463mess_ans
messiahs1343963messiahs
messing103916393messi_ng
mestinos1048163mestinos
mission9312743mission_
nasions73112383_nasions
nelsons738003nels_ons
neustons836833neustons
obsession1144153obsession_
omissions1146153omissions
passion9310883passion_
pension9412203pension_
pensione1039773pensione
pensiones11410003pensiones
pepsins11310433pepsi_ns
pereions10310853pereions
persons93717013pers_ons
plosions1038023plosions
possessions1265023possessions
pulsions1037713pulsions
questions1845523questions
reasons72514943reas_ons
reassigns1074353reassigns
recessions1248933recessions
recisions1139913recisions
regions83613473re_gions
remissions1246613remissions
resigns83910963re_signs
resins64528773re_si_ns
reunions837273reunions
revisions1238593revisions
sasins64923103s_asi_ns
sassies74719263sassi_es
sassing84615553sassi_ng
scansions1145323scansions
scions82612243__scions
scission1045563scission_
seasides938743seasides
season62714903seas_on_
secession1146703secession_
seclusions1244633seclusions
section92515663section_
sedations10311253sedations
seditions1039013seditions
seisin63715123seisi_n_
seising84018863seisi_ng
seisings9398523seisings
seisors73212833seis_ors
seizins164010133seizi_ns
selsyns1092943sels_yns
seniors73413613se_niors
sensations1059853sensations
sensing84116953sensi_ng
sensors73514633sens_ors
sensuous845903sensuous
sepsis83011293sepsi__s
sequins1637863sequi_ns
sereins73716113serei_ns
serins64029673se_ri_ns
serious73616283se_rious
sermons9311783se_rmons
sessile739523sessi_le
sesspool1042873sesspool
sesspools1142393sesspools
sestina72711973sesti_na
sestinas8249133sestinas
sestine73017923sesti_ne
sestines82717243sestines
setons64620173se__tons
sextons143710413se_xtons
siskins1159583siski_ns
sissies73716603sissi_es
solions7513753s_olions
sponsions1145223sponsions
stations82415223stations
stemsons1045003stems_ons
stepsons1045663steps_ons
stetsons845623stets_ons
suasion739363suasion_
successions1553973successions
suctions103012903suctions
sussing84013703sussi_ng
symbions1563933symbions
telsons739213tels_ons
tension7311803tension_
ternions838813ternions
testons7313553te_stons
testoons837303testoons
torsions839183torsions
venisons1136133venisons
version10310923version_
visions10311023_visions
weasons102310583weas_ons
yessing113210063yessi_ng

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621727.00020880.3
3Display Results1721720.0762263.2
 (SQL Overall)1786911727.23224708.4
 
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.