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

53 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
diagramming185267(None) 
diagraming1544381diagra_ming
anagramming1752152anagramming
diagrammed1752623diagramm_ed
diaphragming2261213diaphragming
disgracing1586743disgra_cing
dramming14347563d___ramming
programming1954203programming
begrimming1842574_begrimming
cramming15339434___cramming
damming133812744d____amming
deaerating12311564deaera_ting
degrading13137374d_egra_ding
degumming1643134d_eg_umming
deprogramming2262554deprogramming
diademing1454324dia__deming
diagnosing1343714diag_nosing
diagram1147364diagra_m___
diagramed1454454diagra_m_ed
diagrammable2061934diagrammable
diagrammatic2062344diagrammatic
diagrams1246134diagra_m__s
diapausing1442874dia_pausing
diffracting2143344diffracting
digressing1345794di_gressing
dimming13339594di____mming
disagreeing1453864disagr_eeing
disarming1338804di__sarming
disarranging1573124disarranging
disarraying1644054disarra_ying
disclaiming1744324disclaiming
dispraising1546044dispraising
disrating11714554di_sra_ting
distracting1569254distracting
distraining1346984distraining
divagating1644004divag_a_ting
drumming14265784d___rumming
gamming133112624___g_amming
ingrafting1544894_ingrafting
ingraining1245624_ingraining
logjamming2351474_logjamming
migrating13910534mi_gra_ting
misframing1846234misfra_ming
misgrading1546824misgra_ding
misgrafting1844084misgrafting
monogramming1752784monogramming
programing1646314progra_ming
programmings2052544programmings
ramming123115064____ramming
scramming1634884__scramming
telegramming1852194telegramming
tramming13279344___tramming
windjamming2751284windjamming

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.436409841.7
2DLD Change Limit148819538.28317966.8
3Display Results53530.0301766.7
 (SQL Overall)178691538.74920424.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.