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

99 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
metallographers2371841metallographers_
metallographer2262332metallographer__
metallographies2362403metallographies_
metallographic2462414metallograph__ic
metallography2462944metallograph___y
calligraphers2162225__calligraphers_
ethnographers2293585_et_hnographers_
mythographers2793635myt__hographers_
paleographers21114245__paleographers_
petrographers2155075pet__rographers_
allographs1648066___allograph__s_
autobiographers2372046autobiographers_
bibliographers2462536_bibliographers_
calligrapher2052586__calligrapher__
cartographers2194466__cartographers_
demographers2154566de___mographers_
ethnographer2184786_et_hnographer__
geographers1854786ge____ographers_
hagiographers2353746__hagiographers_
holographers2166226___holographers_
lexicographers29172196le_xicographers_
lithographers2253906lit__hographers_
metalworkers2161566metalwo_r__kers_
mythographer26124516myt__hographer__
oceanographers2262296ocea_nographers_
paleographer20115736__paleographer__
petrographer2057286pet__rographer__
reprographers2154666re__prographers_
seismographers22142686se_ismographers_
stenographers19104096_st_enographers_
telegraphers1853796__t_elegraphers_
topographers2055076__t_opographers_
typographers2354076__t_ypographers_
xylographers2853816___xylographers_
allograph1547537___allograph____
allographic1947437___allograph__ic
autobiographer2262567autobiographer__
bibliographer2362947_bibliographer__
biogeographers2382917_biogeographers_
biographers19155117____biographers_
calligraphies2153197__calligraphies_
calligraphist2182117__calligraph_ist
cartographer2096117__cartographer__
chirographers2494697__chirographers_
choreographers2594537_choreographers_
chorographers24106127__chorographers_
cosmographers2353597__cosmographers_
cryptographers2762917_cryptographers_
demographer2046377de___mographer__
discographers2253197__discographers_
epigraphers1953407_e___pigraphers_
ethnographies2254937_et_hnographies_
geographer1746167ge____ographer__
glossographers2161767_glossographers_
hagiographer2255017__hagiographer__
heliographed2275517he__liographe__d
heliographs2047127he__liograph__s_
holographer2088397___holographer__
hydrographers2654167__hydrographers_
iconographers2153637__iconographers_
lexicographer28152577le_xicographer__
lithographer2155027lit__hographer__
mammographies2253567m__ammographies_
metalanguages1761357metalangua_ge_s_
metallophone1962057metallo___ph_one
metallophones2061947metallo___phones
metallurgies1561937metall_ur_gie_s_
metalworker2051687metalwo_r__ker__
metamorphism2084137meta_mo_r_ph_ism
metamorphose2182737meta_mo_r_ph_ose
metathoraces1973197metatho_ra_ce_s_
metathoraxes2462687metatho_ra_xe_s_
mythographies2754557myt__hographies_
oceanographer2162967ocea_nographer__
oscillographies2381777oscillographies_
oscillographs2162097oscillograph__s_
paleographies2155737__paleographies_
paragraphers2093037__pa_ragraphers_
petrographies2157147pet__rographies_
phonographers2465807__phonographers_
photographers2457177__photographers_
physiographers2863407_physiographers_
polygraphers2353407___polygraphers_
pornographers2164497__pornographers_
reprographer2056257re__prographer__
scenographers2173637__scenographers_
seismographer21143407se_ismographer__
serigraphers1853577se___rigraphers_
stenographer1875307_st_enographer__
stylographies2254357_st_ylographies_
tallgrasses1252357__tall_grasse_s_
telegrapher1754507__t_elegrapher__
telegraphese1852477__t_elegraphe_se
thermographers2553687_thermographers_
topographer1946697__t_opographer__
typographer2255347__t_ypographer__
videographers2353407__videographers_
xylographer2754837___xylographer__
zoogeographers3062377_zoogeographers_

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.343520965.0
2DLD Change Limit95024998.75010859.9
3Display Results99990.0761302.6
 (SQL Overall)178691999.16919488.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.