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 “micrographics” 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
micrographics255564(None) 
micrographic2467121micrographic_
micrographing2463732micrographing
micrographs2147782micrograph__s
micrograph2047563micrograph___
micrographed2365943micrograph_ed
pictographic2456383pictographic_
pictographies2355633pictographies
reprographics2395173reprographics
barographic2146564_barographic_
biographic2047444bi__ographic_
biographies1996494bi__ographies
cacographies2255724cac_ographies
chirographic2556374chirographic_
chirographies2465894chirographies
chorographic2548554chorographic_
chorographies2487434chorographies
demographics2355764_demographics
discographic2354664discographic_
discographies2284584discographies
filmographies2454304filmographies
hieroglyphics2781264hieroglyphics
hydrographic2756354hydrographic_
hydrographies2675774hydrographies
iconographic2255614_iconographic_
iconographies2155054_iconographies
ideographic2056874_ideographic_
ideographies1955774_ideographies
idiographic2046794_idiographic_
lithographic2355694lithographic_
lithographies2295274lithographies
mammographic2354184mammographic_
mammographies2253564mammographies
micrograms1747784microgra___ms
microgravities2262494microgravities
microgravity2382714microgra_vity
mimeographing2462274mimeographing
mimeographs2184764mimeograph__s
monographic2148554m_onographic_
mythographies2754554mythographies
orographic1849074__orographic_
orographies1767794__orographies
petrographic2278024petrographic_
petrographies2157144petrographies
pictographs2146554pictograph__s
reprographic2296654reprographic_
reprographies2196094reprographies
videographies2354424videographies
xerographic2667924_xerographic_
xerographies2586714_xerographies

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.1061685764.2
2DLD Change Limit95024505.55017121.4
3Display Results50500.0301666.7
 (SQL Overall)178691505.68631426.5
 
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.