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

181 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
cessions103985(None) 
cession939811cession_
sessions839721sessions
accessions1445242accessions
cassinos10309352cassinos
cessations1256472cessations
cessing103814812cessi_ng
cushions1335692cushions
essoins737602_essoins
fissions1138032fissions
hessians1145052hessians
lesions73813862le_sions
lessons73811012less_ons
missions10311902missions
passions10310582passions
pensions10311692pensions
recessions1248932recessions
scissions1145432scissions
secessions1246462secessions
session739762session_
tensions8310222tensions
versions11310352versions
accession1345233accession_
ascensions1244613ascensions
assigns836193_assigns
aversions1247053aversions
basions94213953_basions
bassoons1036543bassoons
bastions10411693bastions
benisons1037043benisons
caissons1036283caissons
camions113916133c_amions
campions143511293campions
captions123813223captions
carrions10312453carrions
caseins93115053casei_ns
casinos93512833c_asinos
cassations1276873cassations
cassias93514343cassi_as
cassina94113163cassi_na
cassinas103610633cassinas
cassine93817283cassi_ne
cassines103116613cassines
cassino93512433cassi_no
cassis84818853cassi__s
cassises103811743cassises
cations94524143c_ations
cautions103313183cautions
ceasing104118263ceasi_ng
celadons1137003celadons
censing104215263censi_ng
censors93611833cens_ors
cesarians1146363cesarians
cesiums1136303ce_siums
cessation1176853cessation_
cesses84221363cess__es
cesspits1243663cesspits
cesspool1242583cesspool
cesspools1342103cesspools
cestoids11308273cestoids
cestos84718093ce_sto_s
chorions13310663chorions
cions75222853c___ions
cissies94116153cissi_es
cissoids1145363cissoids
cistrons102710623cistrons
clarions10310493clarions
classons1037703classons
coercions1346203coercions
cohesions1447093cohesions
coitions10312853coitions
concessions15128103concessions
confessions16136633confessions
consigns1137533consigns
cosigns1047513c_osigns
cousins9516003cousi_ns
creations112614543creations
cullions10219223cullions
cushion1236403cushion_
cushiony1642583cushiony
cussing103814273cussi_ng
cussos84210003cuss_o_s
decisions1248383decisions
delusions1037053delusions
demissions1345663demissions
derisions1038843derisions
designs9328313de_signs
eclosions1146203eclosions
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
obsessions1244263obsessions
occasions1344063occasions
omissions1146153omissions
passion9310883passion_
pension9412203pension_
pensione1039773pensione
pensiones11410003pensiones
pepsins11310433pepsi_ns
pereions10310853pereions
persons93717013pers_ons
plosions1038023plosions
precessions1548553precessions
processions1548153processions
pulsions1037713pulsions
questions1845523questions
reasons72514943reas_ons
reassigns1074353reassigns
recensions1248483recensions
recession1149103recession_
recisions1139913recisions
regions83613473re_gions
remissions1246613remissions
resigns83910963re_signs
resins64528773re_si_ns
reunions837273reunions
revisions1238593revisions
scansions1145323scansions
scions82612243__scions
scission1045563scission_
seasons72614233seas_ons
secession1146703secession_
sections102714703sections
seisins73614393seisi_ns
sessional946113sessional
suasions838783suasions
successions1553973successions
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 Limit1461621817.31319986.6
3Display Results1811810.0632873.0
 (SQL Overall)1786911817.53223724.2
 
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.