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

47 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
reprographics239517(None) 
reprographic2296651reprographic_
reprographies2196091reprographies
reprographers2154662reprographers
demographics2355763de_mographics
micrographics2555643micrographics
petrographic2278023petrographic_
petrographies2157143petrographies
renographic1947403re_nographic_
renographies1866533re_nographies
reprographer2056253reprograph_er
reprography2246523reprograph__y
xerographic2667923xe_rographic_
xerographies2586713xe_rographies
barographic2146564_barographic_
chirographic2556374chirographic_
chirographies2465894chirographies
chorographic2548554chorographic_
chorographies2487434chorographies
cryptographic2864464cryptographic_
cryptographies2754084cryptographies
demographic2247864de_mographic_
demographies2156414de_mographies
epigraphic2055334_ep_igraphic_
epigraphies1954934_ep_igraphies
geographic1947754ge__ographic_
geographies1856614ge__ographies
heliographic2356944heliographic_
hydrographic2756354hydrographic_
hydrographies2675774hydrographies
micrographic2467124micrographic_
orographic1849074__orographic_
orographies1767794__orographies
petrographers2155074petrographers
petrographical2463874petrographical
radiographic2156364radiographic_
radiographies2055824radiographies
reprograming1863904reprogra_ming
reprogramming2172924reprogramming
reprograms1556224reprogra___ms
serigraphies18114764se_rigraphies
supergraphics2362054supergraphics
topographic2167714top_ographic_
topographies20116934top_ographies
typographic2456454typ_ographic_
typographies23105664typ_ographies
venographies2165674ve_nographies

Search took 6 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 Filter178691950240.1261418182.5
2DLD Change Limit95024475.23318158.6
3Display Results47470.0331424.2
 (SQL Overall)178691475.39233140.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.