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

50 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
metallographies2362401metallographies_
metallographer2262333metallograph_e_r
metallographers2371843metallograph_ers
metallographic2462413metallographi__c
metallography2462944metallograph___y
calligraphies2153195__calligraphies_
ethnographies2254935_et_hnographies_
mammographies2253565m__ammographies_
mythographies2754555myt__hographies_
oscillographies2381775oscillographies_
paleographies2155735__paleographies_
petrographies2157145pet__rographies_
stylographies2254355_st_ylographies_
allographic1947436___allographi__c
allographs1648066___allograph__s_
arteriographies2172746arteriographies_
autobiographies2362336autobiographies_
autographies1856956___autographies_
bibliographies2463386_bibliographies_
cacographies2255726__ca_cographies_
calligraphist2182116__calligraphi_st
cartographies2156046__cartographies_
demographies2156416de___mographies_
filmographies2454306__filmographies_
geographies1856616ge____ographies_
hagiographies2354926__hagiographies_
holographies2148126___holographies_
lexicographies2962646le_xicographies_
lithographies2295276lit__hographies_
metallophones2061956metallo___phones_
metallurgies1561936metall_ur__gies_
metamorphism2084136meta_mo_r_phi_sm
oceanographies2263056ocea_nographies_
orthographies2255106ort__hographies_
planographies2164886_pla_nographies_
polarographies2253536pola_rographies_
radiographies2055826__radiographies_
renographies1866536re___nographies_
reprographies2196096re__prographies_
seismographies2253346se_ismographies_
stenographies19125316_st_enographies_
stereographies2054246_stereographies_
telegraphies1854776__t_elegraphies_
tomographies20127366__t_omographies_
topographies20116936__t_opographies_
typographies23105666__t_ypographies_
uranographies1954246_ura_nographies_
venographies2165676ve___nographies_
xerographies2586716xe___rographies_
xylographies2855266___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.310576422.6
2DLD Change Limit65874504.61014289.4
3Display Results50500.0331515.2
 (SQL Overall)178691504.95336077.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.