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

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
metallographies236240(None) 
metallographer2262332metallograph_er
metallographers2371842metallographers
metallographic2462412metallographi_c
metallography2462943metallograph__y
calligraphies2153194__calligraphies
ethnographies2254934_et_hnographies
mammographies2253564m__ammographies
mythographies2754554myt__hographies
oscillographies2381774oscillographies
paleographies2155734__paleographies
petrographies2157144pet__rographies
stylographies2254354_st_ylographies
allographic1947435___allographi_c
allographs1648065___allograph__s
arteriographies2172745arteriographies
autobiographies2362335autobiographies
autographies1856955___autographies
bibliographies2463385_bibliographies
cacographies2255725__ca_cographies
cartographies2156045__cartographies
demographies2156415de___mographies
filmographies2454305__filmographies
geographies1856615ge____ographies
hagiographies2354925__hagiographies
holographies2148125___holographies
lexicographies2962645le_xicographies
lithographies2295275lit__hographies
metallophones2061955metallo___phones
metallurgies1561935metall_ur__gies
oceanographies2263055ocea_nographies
orthographies2255105ort__hographies
planographies2164885_pla_nographies
polarographies2253535pola_rographies
radiographies2055825__radiographies
renographies1866535re___nographies
reprographies2196095re__prographies
seismographies2253345se_ismographies
stenographies19125315_st_enographies
stereographies2054245_stereographies
telegraphies1854775__t_elegraphies
tomographies20127365__t_omographies
topographies20116935__t_opographies
typographies23105665__t_ypographies
uranographies1954245_ura_nographies
venographies2165675ve___nographies
xerographies2586715xe___rographies
xylographies2855265___xylographies

Search took 5 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 Limit65874484.06316213.1
3Display Results48480.0301600.0
 (SQL Overall)178691484.41940437.0
 
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.