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

80 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
accelerations175419(None) 
acceleration1654811acceleration_
accelerating1753732accelerati_ng
accelerators1682942accelerat_ors
decelerations1646422decelerations
accelerandos17191293accelerando_s
accelerates1554443accelerat__es
accelerative1953453accelerati_ve
accelerator1573263accelerat_o_r
accentuations1753093accentuations
acceptations1864503acce_ptations
acclamations18164043acc_lamations
acclimations18146293acc_limations
acculturations18182903acculturations
asseverations1652593asseverations
celebrations1645743__celebrations
deceleration1547173deceleration_
aberrations1346694a_be_rrations
accelerando16141534accelerando__
accelerant1453734accelera___nt
accelerants1552544accelera__nts
accelerate1444914accelerat___e
accelerated1653944accelerat__ed
acceleratingly2261324acceleratingly
accentuation1653464accentuation_
acceptation1765324acce_ptation_
acclamation17144754acc_lamation_
acclimation17127094acc_limation_
accreditations19122624accreditations
accretions1444924acc___retions
acculturation17173344acculturation_
accumulations19143624accumulations
accusations1546004acc__usations
acetylations1743544a_cetylations
acylations1547604a_cyl__ations
adulterations1453174adulterations
aerations9317904a____erations
allegations1246044a__llegations
alliterations1384554alliterations
alterations11511664a__lterations
ameliorations1563194a_meliorations
appellations1643534appel_lations
asseveration1552894asseveration_
cancelations1657094cancel__ations
cancellations1754394cancel_lations
celebration1546464__celebration_
cerebrations1646964__cerebrations
chelations1539084_chel__ations
cogenerations1655914cogenerations
colorations13911894__colorations
concelebrations21103164concelebrations
cooperations1659194_cooperations
crenelations1446184_crenelations
deaerations12311674__deaerations
decelerating1645594decelerati_ng
decelerators1553494decelerat_ors
decerebrations1993744decerebrations
declarations1546804dec_larations
degenerations1546354degenerations
delegations1348034__delegations
elevations1338634___elevations
federations1548884__federations
generations12311424__generations
incinerations1545684incinerations
intenerations1347464intenerations
lacerations1348334lac__erations
macerations1548474mac__erations
noncelebrations19122824noncelebrations
nucleations1345314nuc_le_ations
occultations1644374occul_tations
reaccelerating19101844reaccelerati_ng
recuperations1746084recuperations
regenerations1447144regenerations
relegations1248974__relegations
sacculations1646664saccul__ations
scatterations1552544scatterations
tolerations1158134__tolerations
ulcerations1346364ulc__erations
venerations14411314__venerations
vociferations2153114vociferations

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 Filter178691950240.360496363.9
2DLD Change Limit95024807.14013308.7
3Display Results80800.0461739.1
 (SQL Overall)178691807.54623680.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.