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

71 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
chirographer2310606(None) 
chirographers2494691chirographers
chorographer23118241chorographer
chirographic2556372chirographic
chirographies2465902chirographies
chirography2546132chirograph_y
choreographer2495742choreographer
chorographers24106122chorographers
biographer18126513_bi_ographer
cartographer2096113cartographer
choreographed25104823choreographed
choreographers2594533choreographers
chorographic2548553chorographic
chorographies2487433chorographies
chorography2548453chorograph_y
cosmographer2254883cosmographer
holographer2088393_holographer
hydrographer2555803hydrographer
petrographer2057283petrographer
phonographer2347863phonographer
photographer2349693photographer
reprographer2056253reprographer
thermographer2464883thermographer
biographee18155544_bi_ographee
biographers19155114_bi_ographers
calligrapher2052584calligrapher
cartographers2194464cartographers
chirographical2783504chirographical
chiromancer2052944chiro_mancer
chiropractor2171774chiropractor
chiropter1644834chiro___pter
choreograph2256154choreograph__
choreographic2655874choreographic
choreographies2555274choreographies
choreographs2356194choreograph_s
choreography2656004choreograph_y
cosmographers2353594cosmographers
cryptographer2663744cryptographer
demographer2046374_demographer
discographer2154164discographer
epigrapher1854064epi__grapher
ethnographer2184784ethnographer
geographer1746164__geographer
hagiographer2255014hagiographer
holographed21107624_holographed
holographers2166224_holographers
hydrographers2654164hydrographers
iconographer2054894iconographer
lexicographer28152574lexicographer
lithographer2155024lithographer
micrographed2365944micrographed
mythographer26124514mythographer
oceanographer2162964oceanographer
paleographer20115734paleographer
paragrapher1973654_paragrapher
petrographers2155074petrographers
phonographers2465804phonographers
photographed2458664photographed
photographers2457174photographers
physiographer2754344physiographer
pornographer2056014pornographer
reprographers2154664reprographers
scenographer2064704scenographer
seismographer21143404seismographer
serigrapher1754464_serigrapher
stenographer1875304stenographer
thermographers2553684thermographers
topographer1946694_topographer
typographer2255344_typographer
videographer2254324videographer
xylographer2754834_xylographer

Search took 8 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.390458182.1
2DLD Change Limit124790716.75018487.4
3Display Results71710.0461543.5
 (SQL Overall)178691717.18624866.5
 
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.