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

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

91 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
recession114910(None) 
precession1448821precession
recension1148861recension
recessions1248931recessions
secession1146701secession
accession1345232accession
cession939812__cession
precessions1548552precessions
procession1448412procession
reaccession1552952reaccession
recensions1248482recensions
reception13410322reception
recessing12611012recessing
recessional1354982recessional
recessive1447262recessive
recision10310272rec_ision
reclusion1146502reclusion
recursion1146152recursion
regression1146952regression
remission1147332remission
repression1249042repression
rescission1244862rescission
reversion1248092reversion
secessions1246462secessions
accessions1445253accessions
ascension1144703ascension
cessions1039853__cessions
concession14148133concession
deception1448323deception
decision1148523dec_ision
declension1343513declension
demission1246033demission
depression1347503depression
descension1344543descension
eclosion1046893_eclosion
egestion946863_egestion
egression1046193egression
emersion1047733_emersion
emission1047673_emission
eversion1138713_eversion
necessity1453413necessity
obsession1144153obsession
percussion1444993percussion
precessing1598743precessing
precessional1655123precessional
precision13410053prec_ision
preclusion1445213preclusion
prehension1546313prehension
prerecession1683573prerecession
pretension1247533pretension
processions1548153processions
profession1546593profession
reaccessions1652763reaccessions
reassign955423re_assign
rebellion1144723rebellion
recaution1148093recaution
recensor1045543recens_or
receptions1449743receptions
recess8314263recess___
recessed1139713recess_ed
recesses10312323recess_es
recessionals1453613recessionals
recessionary1753063recessionary
recessives1545673recessives
recisions1139913rec_isions
reclusions1246243reclusions
reconsign1245243reconsign
recreation12413613recreation
recursions1245403recursions
redesign1045073rede_sign
reemission1244333reemission
refashion1543353refashion
refection141512283refection
regressions1247103regressions
rejection181710253rejection
remissions1246613remissions
repressions1348963repressions
repulsion1145193repulsion
rescissions1344593rescissions
reseason844933reseas_on
resection111613273resection
retention91611483retention
retorsion946503retorsion
retrocession1494453retrocession
reversions1347573reversions
revision1138713re_vision
revulsion1244353revulsion
scission1045563_scission
seclusion1144943seclusion
session739763__session
succession1454013succession

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 Filter1786911486410.406440125.6
2DLD Change Limit148641917.36020195.8
3Display Results91910.0461978.3
 (SQL Overall)178691917.81222873.9
 
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.