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

67 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
bacteriologist196370(None) 
bacteriologists2063251bacteriologists
bacteriologic2062352bacteriologi_c
bacteriologies1952832bacteriologies
bacteriological2282873bacteriological
bacteriology2052893bacteriolog__y
bacteriolysis2061813bacteriolysis_
bacteriolyses2061834bacteriolyses_
bacteriolytic2261654bacteriolyti_c
ecclesiologist1962604ecclesiologist
malariologist1693924ma_lariologist
martyrologist1953324martyr_ologist
pteridologist17144604__pteridologist
watercolorist18182544wa_tercolorist
angelologist1454165_ange_lologist
anthologist15410465_ant__hologist
anthropologist2064425_anthropologist
astrobiologist1784205_astrobiologist
audiologist1347245_a__udiologist
bacterials1446355bacterial___s_
bacteriocin1762665bacteri__oci_n
bacteriocins1862495bacteri__ocins
bacteriophages24191645bacteriophages_
bacteriophagies2571355bacteriophagies
bacteriostasis18151435bacteriostasis
bacteriostat16112245bacteri__ostat
bacteriostats17161715bacteriostats_
biologist12412345b_____iologist
biotechnologist2371565biotechnologist
bryologist1647385b____ryologist
cardiologist1656625__cardiologist
cetologist13412255__c_e_tologist
ecclesiologists2062355ecclesiologists
electrologist1657055elect_r_ologist
epidemiologist2062765epidemiologist
futurologist1673505_futur_ologist
glaciologist1654895glac___iologist
lichenologist1973915liche_nologist
liturgiologist16131855_liturgiologist
malariologists1773355ma_lariologists
martyrologists2062895martyr_ologists
materialist1349525ma_terial__ist
meteorologist1654875_meteorologist
metrologist14511235_met_r_ologist
microbiologist21135495microbiologist
necrologist14410135nec__r_ologist
numerologist1574915_numer_ologist
oceanologist1555685_oc_eanologist
osteologist1248565_oste__ologist
paleobiologist19156345paleobiologist
papyrologist2055095pa_pyr_ologist
pathologist17410665pa_t__hologist
petrologist14711885_pet_r_ologist
photobiologist2266225photobiologist
pteridologists18133725__pteridologists
radiobiologist18154685radiobiologist
radiologist1399505ra___diologist
semiologist14410715___semiologist
serologist11413155___ser_ologist
sociobiologist1964045sociobiologist
sociologist1449885soc___iologist
soteriologies1453875_soteriologies
teleologist1249385___teleologist
teratologist13108575___teratologist
tribologist1447725___t_ribologist
victimologist2162625vict_imologist
watercolorists19152035wa_tercolorists

Search took 9 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.376475242.0
2DLD Change Limit95024677.96611928.7
3Display Results67670.0461456.5
 (SQL Overall)178691678.38821303.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.