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

97 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
decimation1541162(None) 
decimations16410161decimations
decimating1648752decimating
decimator1447732decimat_or
declamation1646102declamation
declination14411872declination
decoration13314422decoration
dedication14311962dedication
defamation1646842defamation
depilation13312032depilation
derivation14712782derivation
deviation13312392devi_ation
recitation12315942recitation
acclimation17127093acclimation
animation11313683_animation
citation10314363__citation
deactivation18156083deactivation
deaeration11313013deaeration
dealation10313003de_alation
deamination14411543deamination
decantation1448943decantation
decapitation1748683decapitation
deception1448323dec_eption
decillion1245833deci_llion
decimalize2446603decimalize
decimate13411123decimat__e
decimated1548953decimat_ed
decimates14410693decimat_es
decimators1547503decimators
decision1148523deci__sion
declamations1745303declamations
declaration1447833declaration
declinations15410223declinations
decoction1447523dec_oction
decollation1448193decollation
decorations14312883decorations
decryption1843733decryption
decussation1444303decussation
dedications15310873dedications
defamations1745893defamations
defecation1679803defecation
definition1445963definition
deflation13310653de_flation
deformation1747663deformation
deification17411663deification
delation92318083de__lation
delegation1238883delegation
delimitation1597263delimitation
delineation1247763delineation
demotion1169073de__motion
denegation1249413denegation
denigration1348463denigration
denotation11311083denotation
dentation10315243de_ntation
denudation1247303denudation
deoxidation2045953deoxidation
depiction1437273depi_ction
depilations14310903depilations
deprivation1788773deprivation
deputation1339393deputation
deracination1548863deracination
derivations15611493derivations
derogation12410393derogation
desiccation1646383desiccation
designation1347483designation
desolation11311403desolation
destination12413843destination
detonation11310943detonation
deviations14311163devi_ations
dictation12810563dic_tation
dilation92215463d__ilation
divination14139233divination
domination13712373domination
dubitation1377333dubitation
epilation11312963_epilation
estimation12410843estimation
excitation19410173excitation
gemination131410653gemination
gemmation1445963ge_mmation
hesitation1349633hesitation
himation1339753__himation
incitation12312223incitation
intimation12413043intimation
lacrimation1546263lacrimation
levigation1447023levigation
levitation1349443levitation
mediation12312293medi_ation
medication15411173medication
meditation13410743meditation
pectination15410333pectination
peculation14311993peculation
reanimation1359633reanimation
recitations13314203recitations
reclamation1546353reclamation
recreation12413613recreation
seriation9318063seri_ation
speciation1449393speci_ation

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603975.59325139.1
3Display Results97970.0601616.7
 (SQL Overall)178691976.05929491.8
 
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.