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

83 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
programming195420(None) 
programing1646311progra_ming
programmings2052541programmings
deprogramming2262552deprogramming
programings1753422progra_mings
reprogramming2172922reprogramming
anagramming1752153anagramming
deprograming1963363deprogra_ming
diagramming1852673diagramming
logjamming2351473_logjamming
misprogramming2161323misprogramming
monogramming1752783monogramming
pogroming1544733p_ogr_oming
preprogramming2461843preprogramming
pretrimming1843033pretrimming
proclaiming1843873proclaiming
programme1694783programm__e
programmed1883883programm_ed
programmer1794113programm_er
programmers1893533programmers
programmes1784933programm_es
progressing1545773progressing
prorating12314283pro_ra_ting
protracting1646933protracting
reprograming1863903reprogra_ming
begrimming1842574_begrimming
cramming15339434___cramming
diagraming1544384diagra_ming
dramming14347564___dramming
gamming133112624___g_amming
goddamming1851074_goddamming
isografting1651814isografting
misprograming2161874misprogra_ming
monograming1754314monogra_ming
orgasming1343114or_g_asming
overprogramming2671714overprogramming
paragraphing2152354paragraphing
perorating13313134pero_ra_ting
portraying1645164portra_ying
prearming14139224pr__earming
prefranking2143314prefranking
preprograming2162484preprogra_ming
prestamping1863654prestamping
pretraining1446504pretraining
prewarming18145174pr_ewarming
prewrapping1842394prewrapping
primming15268174p___rimming
probating14311194pro_ba_ting
procreating1647694procreating
profaning1537294pro_fa_ning
progging132610384prog___ging
prognosing1444424prog_nosing
program12311694progra_m___
programed1585894progra_m_ed
programer1475604progra_m_er
programers1584404progra_mers
programmable2162044programmable
programmatic2163144programmatic
programs1339784progra_m__s
prolamin12139754pro_la_min_
prolamine131510564pro_la_mine
prolamins13159704pro_la_mins
prolapsing1543874pro_lapsing
promoing13310464pro___moing
pronating12313764pro_na_ting
proroguing1443124pro_roguing
prostrating1449394prostra_ting
protamin121210544pro_ta_min_
protamine131310914pro_ta_mine
protamins131410774pro_ta_mins
protruding1453634protr_uding
ramming123115064____ramming
reframing1538624_refra_ming
regrading121210204_regra_ding
regrafting1545994_regrafting
regranting1238324_regranting
regrating111316214_regra_ting
regrooming1464164_regrooming
retrimming1544264_retrimming
roaming103215794_ro__a_ming
scramming1634884__scramming
telegramming1852194telegramming
tramming13279344___tramming

Search took 10 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 Limit148819839.44015764.7
3Display Results83830.0461804.3
 (SQL Overall)178691839.92218009.6
 
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.