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

55 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
cholangiography308151(None) 
cholangiogram2271333cholangiogra__m
cholangiograms2371323cholangiogra_ms
angiography2154514____angiography
hagiography2445504_h__a_giography
cardiography2454245c___ardiography
choreography2656005cho___reography
chorography2548455cho____rography
chromatography30134385chroma__tography
chronography26125745ch_ron__ography
holography2278615_hol____ography
phonography2568305pho__n__ography
planography2255165__plan__ography
polarography2353905_pola__rography
angiographic2155256____angiographic
autoradiography25152476autora_diography
bibliography2553036bibl___iography
biogeography2453716bio___geography
cacography2345836c___a__cography
calligraphy2262566c___alli_graphy
cardiograph2054766c___ardiograph_
cardiographs2164546c___ardiographs
cartography2246786c___a_rtography
chirography2546136ch____irography
choreograph2256156cho___reograph_
choreographs2356196cho___reographs
chromatograph26134556chroma__tograph_
chromatographs27134376chroma__tographs
chronograph22146076ch_ron__ograph_
chronographs23145846ch_ron__ographs
coronograph19124936c_oron__ograph_
coronographs20124926c_oron__ographs
cosmography2445596c_o___smography
hagiographer2255016_h__a_giographer
hagiographic2495726_h__a_giographic
heliograph1946906_hel___iograph_
heliographs2047126_hel___iographs
historiography2672336_historiography
holograph1879666_hol____ograph_
holographs1979986_hol____ographs
iconography2245456ico__n__ography
oceanography2353416_ocean__ography
paleogeography2682206_paleogeography
phlebography2853616ph_l__ebography
phonograph2148816pho__n__ograph_
phonographs2248906pho__n__ographs
photography25410076pho____tography
physiography2954496ph___ysiography
phytogeography3262736ph_ytogeography
pornography2246216_po_rn__ography
radiography2165946___ra_diography
sonography1947206_so__n__ography
uranography2054186__uran__ography
xeroradiography3271836xerora_diography
zoogeography3152976_zo__ogeography

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 Filter178691950240.343520965.0
2DLD Change Limit95024557.58012536.1
3Display Results55550.0461195.7
 (SQL Overall)178691557.96922423.3
 
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.