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

50 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
monogrammer155302(None) 
monogrammed1652761monogrammed
monogrammers1652601monogrammers
monogramed1644672monogra_med
monogamies1546193monog_amies
monogram1379183monogra_m__
monograming1754313monograming
monogramming1752783monogramming
monograms1478263monogra_m_s
monographed2046553monographed
nonprogrammer20121733nonprogrammer
programmer1794113_programmer
aerogramme1553554aerogramme_
aerogrammes1653774aerogrammes
anagrammed1652024_anagrammed
deprogrammer2062774deprogrammer
engramme1344054_en_gramme_
engrammes1444514_en_grammes
holographer2088394holographer
iconographer2054894iconographer
monocracies1755724monocracies
monodrama1444284monodra_m_a
monodramas1553704monodra_mas
monogamic1645914monog_a_mic
monogamist1555834monog_amist
monogamous1554364monog_amous
monogamy1645114monog_a_m_y
monogrammatic1962634monogrammatic
monograph1748644monogra__ph
monographic2148554monographic
monographs1848884monogra_phs
monolayer1444794mono_la_yer
monomer11311894mono____mer
monorhyme1953404mono_rhyme_
monorhymed2152304mono_rhymed
monorhymes2053524mono_rhymes
monotreme1343944monotr_eme_
monotremes1443924monotr_emes
nonprogrammers21131394nonprogrammers
phonogrammic2452684phonogrammic
phonographer2347864phonographer
pornographer2056014pornographer
programer1475604_progra_mer
programme1694784_programme_
programmed1883884_programmed
programmers1893534_programmers
programmes1784934_programmes
sonogram1167504sonogra_m__
sonograms1296304sonogra_m_s
topographer1946694topographer

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.423422437.4
2DLD Change Limit148819508.39017737.7
3Display Results50500.0331515.2
 (SQL Overall)178691508.84620200.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.