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 “successions” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
successions155397(None) 
succession1454011succession_
accessions1445252_accessions
secessions1246462s_ecessions
successional1672742successional
successors1453012success_ors
accession1345233_accession_
cessions1039853___cessions
concessions15128103concessions
precessions1548553precessions
processions1548153processions
reaccessions1652763reaccessions
recessions1248933_recessions
scissions1145433s__cissions
secession1146703s_ecession_
sessions839723s___essions
submersions1544473submersions
submissions1553693submissions
subversions1654493subversions
successes1345643success__es
successive1753193successi_ve
successor1343063success_o_r
succussing1543013succussi_ng
suggestions1353053suggestions
suppressions1674043suppressions
suspensions1353843suspensions
abscissions1552404abscissions
accessing1445834_accessi_ng
accessional15103604_accessional
accessioned1652504_accessioned
aggressions1353854aggressions
ascensions1244614_ascensions
cession939814___cession_
concession14148134concession_
concussions15125324concussions
confessions16136634confessions
declensions1443334declensions
depressions1447314depressions
descensions1444374descensions
digressions1344744digressions
discussions1444244discussions
egressions1146204_egressions
expressions2086364expressions
impressions1546824impressions
ingressions1245494ingressions
nucleations1345314nucleations
obsessions1244274_obsessions
occasions1344064_occ_asions
occlusions1443714_occlusions
oppressions1545724oppressions
percussions1544874percussions
possessions1265024possessions
precession1448824precession_
procession1448414procession_
professions1646634professions
questions1845524qu__estions
reaccession1552954reaccession_
recensions1248484_recensions
recession1149104_recession_
regressions1247104regressions
repressions1348964repressions
rescissions1344594rescissions
scansions1145324s__cansions
scission1045564s__cission_
secessionism1653444s_ecessionism
secessionist1454754s_ecessionist
seclusions1244634s_eclusions
secretions12117854secre_tions
session739764s___ession_
suasions838784su___asions
subdecisions1752864subdecisions
subjections2296354subjections
sublessors1243374subless_ors
submersion1444344submersion_
submission1453744submission_
subregions1344424subre_gions
subreptions1545884subreptions
subsections1597104subsections
subventions1674844subventions
subversion1544504subversion_
succeeding1642684succeedi_ng
success1146404succe_s___s
successful1752024success_ful
successionally2161444successionally
successively2282444successively
successiveness2072814successiveness
succusses1344424succuss__es
suctions103012904su_c__tions
suffusions1652734su_ffusions
suggestion1253014suggestion_
sulcations1289584sulc_ations
supersessions1454774supersessions
suppression1564334suppression_
surceasing1345074surceasi_ng
surjections2075284surjections
suspension1253804suspension_

Search took 9 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 Filter1786911488190.420425454.8
2DLD Change Limit148819968.19018170.8
3Display Results96960.0601600.0
 (SQL Overall)178691968.67020610.3
 
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.