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

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

78 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
cholangiography3081511cholangiography_
cholangiogram2271334cholangiogra___m
cholangiograms2371324cholangiogra__ms
angiography2154515____angiography_
hagiography2445505_h__a_giography_
angiographic2155256____angiographic
cardiography2454246c___ardiography_
choreography2656006cho___reography_
chorography2548456cho____rography_
chromatography30134386chroma__tography_
chronography26125746ch_ron__ography_
hagiographer2255016_h__a_giographer
hagiographic2495726_h__a_giographic
holography2278616_hol____ography_
phonography2568306pho__n__ography_
planography2255166__plan__ography_
polarography2353906_pola__rography_
angiographies2054367____angiographies
autoradiography25152477autora_diography_
bibliography2553037bibl___iography_
biogeography2453717bio___geography_
cacography2345837c___a__cography_
calligraphy2262567c___alli_graphy_
cardiograph2054767c___ardiograph__
cardiographic2454217c___ardiographic
cardiographs2164547c___ardiograph_s
cartography2246787c___a_rtography_
chirography2546137ch____irography_
choreograph2256157cho___reograph__
choreographed25104827cho___reographed
choreographer2495747cho___reographer
choreographic2655877cho___reographic
choreographs2356197cho___reograph_s
chorographer23118247cho____rographer
chorographic2548557cho____rographic
chromatograph26134557chroma__tograph__
chromatographed29163367chroma__tographed
chromatographer28213587chroma__tographer
chromatographic3073447chroma__tographic
chromatographs27134377chroma__tograph_s
chronograph22146077ch_ron__ograph__
chronographic2655517ch_ron__ographic
chronographs23145847ch_ron__ograph_s
coronograph19124937c_oron__ograph__
coronographs20124927c_oron__ograph_s
cosmography2445597c_o___smography_
hagiographers2353747_h__a_giographers
hagiographical2663217_h__a_giographical
hagiographies2354927_h__a_giographies
heliograph1946907_hel___iograph__
heliographed2275517_hel___iographed
heliographic2356947_hel___iographic
heliographs2047127_hel___iograph_s
historiography2672337_historiography_
holograph1879667_hol____ograph__
holographed21107627_hol____ographed
holographer2088397_hol____ographer
holographic2269527_hol____ographic
holographs1979987_hol____ograph_s
iconography2245457ico__n__ography_
oceanography2353417_ocean__ography_
paleogeography2682207_paleogeography_
phlebography2853617ph_l__ebography_
phonograph2148817pho__n__ograph__
phonographer2347867pho__n__ographer
phonographic2548437pho__n__ographic
phonographs2248907pho__n__ograph_s
photography25410077pho____tography_
physiography2954497ph___ysiography_
phytogeography3262737ph_ytogeography_
planographic2255467__plan__ographic
polarographic2394137_pola__rographic
pornography2246217_po_rn__ography_
radiography2165947___ra_diography_
sonography1947207_so__n__ography_
uranography2054187__uran__ography_
xeroradiography3271837xerora_diography_
zoogeography3152977_zo__ogeography_

Search took 10 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.1101624463.6
2DLD Change Limit95024788.83010761.5
3Display Results78780.0601300.0
 (SQL Overall)178691789.00019854.6
 
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.