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

63 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
micrometeorites2113228(None) 
micrometeorite20122541micrometeorite_
micrometeoritic2381712micrometeoritic
micrometeoroids22151723micrometeoroids
micrometeoroid21141864micrometeor_oid
micrometers1749074micromete_r___s
meteorites1247615_____meteorites
microbreweries2392185microbrewe_ri_es
micromeres1648485microm__e_r__es
micrometer16410145micromete_r____
micromethods22122845micrometho___ds
microtomies1748555micro__t_omi_es
aerometries1348396_aeromet__ri_es
astrometries1455516astromet__ri_es
barometries1547696_baromet__ri_es
biometries1448936bi__omet__ri_es
cemeteries1447386__c_emete_ri_es
crematories1546856__cremat_ori_es
excretories2052906excr__et_ori_es
hydrometeors2162716hydrometeor___s
iodometries1455936_iodomet__ri_es
isometries1248376_i_somet__ri_es
macromeres1645756macrom__e_r__es
madreporites1751776madr__e_porites
manometries1547256m_anomet__ri_es
marqueteries2352636m_arquete_ri_es
meteorite1148176_____meteorite_
microamperes2053206microampe_r__es
microanatomies2062756microanatomi_es
microbiologies2164986microbiologi_es
microcephalies2573416microcephali_es
microcopies19117856micro___copi_es
microcuries1756726micro___curi_es
microelectrodes2281776micro_electrodes
microelements1963856micro_element_s
microgametes1964796microgame___tes
microgametocyte2781356microgamet_ocyte_
microliters1545806microlite_r___s
micromere1547876microm__e_r__e_
micromethod21113306micrometho____d
micromoles1648426microm___o__les
micropipettes2182636micropipe__ttes
micropores16610176micro___por__es
microporosities2182786micro_porosities
microscopies20167246micro__scopi_es
microspheres2154926microsphe_r__es
microspores1747416micro__spor__es
microsporocytes2682246microsporocytes
microstates1547446micro_st___ates
microsurgeries1962396microsurgeri_es
microtomes1649056micro__t_o__mes
microtones1449806micro__t_o__nes
mimetites1346826mi___met___ites
parameterizes26153016_paramete_rizes
picometers1648286pic_omete_r___s
picometres1647226pic_omet__r__es
preterites12411796__pr__ete_rites
pyrometries1898126_pyromet__ri_es
secretories1345946secr__et_ori_es
sociometries1654996sociomet__ri_es
spirometries1655326spiromet__ri_es
stromatolites1562106_stromat_olites
viscometries1954476viscomet__ri_es

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 Limit95024637.58012536.1
3Display Results63630.0461369.6
 (SQL Overall)178691637.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.