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

84 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
microbiologies216498(None) 
microbiologic2264522microbiologi_c
microbiologist21135492microbiologist
microbiologists22134812microbiologists
aerobiologies1655053_aerobiologies
astrobiologies1763263astrobiologies
cryobiologies2153613__cryobiologies
hydrobiologies2473803hydrobiologies
microbiological2464373microbiological
microbiology2263773microbiolog__y
neurobiologies1763913neurobiologies
sociobiologies19103343sociobiologies
craniologies1545374__craniologies
exobiologies2254404__exobiologies
iconologies1447094_ic_o_nologies
missiologies1553314mi__ssiologies
paleobiologies1954904paleobiologies
pathobiologies2274194pathobiologies
photobiologies2265154photobiologies
psychobiologies2873724psychobiologies
radiobiologies1863654radiobiologies
astrobiologist1784195astrobiologist
astrobiologists1873765astrobiologists
bacteriologies1952825bacteriologies
bibliologies1753375bi__bliologies
biologies12311185_____biologies
cardiologies1644965__cardiologies
chronobiologies2362105chronobiologies
chronologies1846415_chro_nologies
codicologies1853665__c_odicologies
coprologies1646945__c_oprologies
cosmologies1646705__c_osmologies
criminologies1852955__criminologies
cryobiologist2154525__cryobiologist
cryobiologists2254105__cryobiologists
cryptologies2055425__cryptologies
ecclesiologies19141995ecclesiologies
epizootiologies2771255epizootiologies
garbologies1544885_gar_b_ologies
gerontologies1584435_gerontologies
herbologies1746565_her_b_ologies
hierologies1547065hier___ologies
hydrobiologist24204505hydrobiologist
hydrobiologists25134045hydrobiologists
ichnologies1746365_ic__hnologies
ichthyologies2552295_ichthyologies
iridologies1344585_i_r_idologies
kinesiologies1851835ki_nesiologies
lichenologies1952915lic_henologies
liturgiologies1661215liturgiologies
malariologies1652745m_alariologies
martyrologies1952335m_artyrologies
meteorologies1653585meteo_rologies
methodologies2053485metho_dologies
metrologies1449585metr___ologies
microanatomies2062755microanatomies
microbalances2162535microb_alances
microbreweries2392185microbreweries
microcopies19117855micr___ocopies
microeconomics2172465microeconomics
microgrooves2082995microgro_o_ves
microimages1854735micro_i_mag_es
micromoles1648425micro_mol___es
microscopies20167245micro__scopies
microtomies1748555micr___otomies
microvillous1962245microvillo__us
misologies13139065mi____sologies
mixologies20136585mi____xologies
monologies13312545m___o_nologies
morphologies2044525m_or_phologies
mycologies1848865myc____ologies
myrmecologies2352435m_yrmecologies
necrologies1447985necr___ologies
neurobiologist17124925neurobiologist
neurobiologists18114315neurobiologists
proctologies1746315__proctologies
radiologies1347805___radiologies
sociobiologist1964045sociobiologist
sociobiologists2063625sociobiologists
sociologies1447805___sociologies
tribologies1446125__trib_ologies
tropologies1447735__tro_pologies
victimologies2151765vic_timologies
virologies1447215vi_r___ologies

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.360496363.9
2DLD Change Limit95024847.00013574.9
3Display Results84840.0461826.1
 (SQL Overall)178691847.40624127.9
 
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.