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

95 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
heliographic235694(None) 
hagiographic2495722hagiographic
heliograph1946902heliograph__
heliographed2275512heliographed
heliographing2353322heliographing
heliographs2047122heliograph_s
holographic2269522hol_ographic
allographic1947433_allographic
angiographic2155253angiographic
bibliographic2553293bibliographic
biographic2047443__biographic
demographic2247863de_mographic
epigraphic2055333_epi_graphic
flexographic3063993flexographic
geographic1947753ge__ographic
heliotropic1854643heliotrop_ic
homographic24410073h_omographic
hydrographic2756353hydrographic
idiographic2046793_idiographic
lexicographic3062803lexicographic
paleographic2276553paleographic
petrographic2278023petrographic
phlebographic2853653phlebographic
physiographic2954643physiographic
radiographic2156363radiographic
renographic1947403re_nographic
reprographic2296653reprographic
telegraphic1954933tel_egraphic
thermographic2655653thermographic
xerographic2667923xe_rographic
xylographic2946103xyl_ographic
aortographic2056454aortographic
arteriographic2272814arteriographic
autographic1948044_autographic
barographic2146564_barographic
calligraphic2252874calligraphic
cardiographic2454214cardiographic
cartographic2266754cartographic
chirographic2556374chirographic
choreographic2655874choreographic
chorographic2548554chorographic
chronographic2655514chronographic
cosmographic2455784cosmographic
demographics2355764de_mographics
digraphic1845514__di_graphic
discographic2354664discographic
ethnographic2355314ethnographic
hagiographer2255014hagiographer
hagiographical2663214hagiographical
hagiographies2354924hagiographies
hagiography2445504hagiograph_y
hectograph2146264hectograph__
hectographed2454544hectographed
hectographing2562824hectographing
hectographs2256204hectograph_s
heliogram1545574heliogra___m
heliograms1644854heliogra__ms
hemimorphic2573654hemimor_phic
holograph1879664hol_ograph__
holographed21107624hol_ographed
holographer2088394hol_ographer
holographies2148124hol_ographies
holographing2275044hol_ographing
holographs1979984hol_ograph_s
holography2278614hol_ograph_y
iconographic2255614iconographic
ideographic2056874_ideographic
kymographic2845734_kymographic
lithographic2355694lithographic
logographic2047064_logographic
mammographic2354184mammographic
metallographic2462414metallographic
micrographic2467124micrographic
monographic2148554_monographic
nomographic2147924_nomographic
oceanographic2353404oceanographic
orographic1849074__orographic
orthographic2355634orthographic
pantographic2256574pantographic
phonographic2548434phonographic
photographic25410314photographic
pictographic2456384pictographic
planographic2255464planographic
polarographic2394134polarographic
polygraphic2464714pol_ygraphic
pornographic2286654pornographic
reprographics2395174reprographics
scenographic2275194scenographic
seismographic2373784seismographic
stenographic2055904stenographic
stereographic2154884stereographic
tomographic2148774_tomographic
topographic2167714_topographic
trigraphic1854764_tri_graphic
typographic2456454_typographic

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.1401276364.3
2DLD Change Limit124790957.08017625.7
3Display Results95950.0601583.3
 (SQL Overall)178691957.28024545.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.