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

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

48 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
historiographic2672041historiographic_
historiographer2471933historiograph_er
historiography2672333historiograph__y
arteriographic2272815_arteriographic_
autobiographic2462785_autobiographic_
stereographic2154885__stereographic_
aortographic2056456___aortographic_
arteriographies2172746_arteriographies
autobiographies2362336_autobiographies
bibliographic2553296bi__bliographic_
bibliographical2772466bi__bliographical
biogeographic2453956bi__ogeographic_
biogeographical2682736bi__ogeographical
chirographic2556376chi___r_ographic_
chirographical2783506chi___r_ographical
choreographic2655876__choreographic_
chorographic2548556__chor_ographic_
discographic2354666dis___cographic_
discographical2562836dis___cographical
fluorographic24113226_fluor_ographic_
hagiographic2495726h___agiographic_
hagiographical2663216h___agiographical
heliographic2356946h___eliographic_
holographic2269526h___o_lographic_
homographic24410076h___o_mographic_
hydrographic2756366h__ydr_ographic_
iconographic2255616_i_co_nographic_
iconographical2463286_i_co_nographical
idiographic2046796_i___diographic_
lithographic2355696li_t__hographic_
micrographic2467126mi__cr_ographic_
micrographics2555646mi__cr_ographics
orographic1849076____or_ographic_
orographical2054396____or_ographical
petrographic2278026_pet_r_ographic_
petrographical2463886_pet_r_ographical
physiographic2954646phys___iographic_
physiographical3172856phys___iographical
phytogeographic3292246phytogeographic_
pictographic2456386pict___ographic_
pornographic2286656___pornographic_
stenographic2055906__st_enographic_
stereographies2054246__stereographies
stereographing21112426__stereographing
tomographic2148776___to_mographic_
topographic2167716___to_pographic_
topographical2354216___to_pographical
trigraphic1854766___t_ri_graphic_

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 Filter178691658740.326548131.9
2DLD Change Limit65874485.23612581.0
3Display Results48480.0301600.0
 (SQL Overall)178691485.59231954.8
 
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.