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

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

44 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
misprogrammed206169(None) 
misprogramed2051901misprogra_med
deprogrammed2152633_deprogrammed
misprogram1752753misprogra_m__
misprograming2161873misprograming
misprogramming2161323misprogramming
misprograms1852683misprogra_m_s
preprogrammed2362013preprogrammed
programmed1883883___programmed
reprogrammed2063013_reprogrammed
unprogrammed2062013_unprogrammed
deprogramed1863214_deprogra_med
deprogrammer2062774_deprogrammer
micrographed2365944mi_crographed
monogrammed1652764m__onogrammed
nonprogrammer20121734nonprogrammer
overprogrammed2561854overprogrammed
preprogramed2062504preprogra_med
programed1585894___progra_med
programme1694784___programme_
programmer1794114___programmer
programmes1784934___programmes
reprogramed1763764_reprogra_med
aerogramme1553555__aerogramme_
aerogrammes1653775__aerogrammes
deprogrammers2162425_deprogrammers
diagrammed1752625di___agrammed
isografted15121985_is__ografted
microgram1648025mi_crogra_m__
micrograms1747785mi_crogra_m_s
mimeographed2353735mi_meographed
misformed1745245mis_fo_r__med
misframed1745625mis___fra_med
misgraded1446235mis___gra_ded
misgrafted1743795mis___grafted
misogamies1545265mis__og_amies
misphrased1843865misp__hra_sed
mispronounced206805mispronounced
monogramed1644675m__onogra_med
monogrammer1553025m__onogrammer
nonprogrammers21131395nonprogrammers
overprogramed2282585overprogra_med
programer1475605___progra_mer
programmers1893535___programmers

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 Filter1786911247900.406440125.6
2DLD Change Limit124790448.36014927.0
3Display Results44440.0301466.7
 (SQL Overall)178691448.79620315.0
 
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.