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

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
bacteriologists206325(None) 
bacteriologist1963691bacteriologist_
bacteriologies1952822bacteriologi_es
bacteriologic2062343bacteriologi__c
bacteriological2282863bacteriological
bacteriology2052884bacteriolog___y
bacteriolyses2061824bacteriol__yses
bacteriolysis2061804bacteriol__ysis
ecclesiologists2062354ecclesiologists
malariologists1773354ma_lariologists
martyrologists2062894martyr_ologists
pteridologists18133724__pteridologists
watercolorists19152034wa_tercolorists
angelologists1553375_ange_lologists
anthologists1648035_ant__hologists
anthropologists2183415_anthropologists
astrobiologists1873765_astrobiologists
audiologists1445615_a__udiologists
bacteriocins1862485bacteri__oci_ns
bacteriolytic2261645bacteriolyti__c
bacteriophagies2571355bacteriophagi_es
bacteriostases18171385bacterio_stases
bacteriostasis18151425bacterio_stasis
bacteriostats17161705bacteri__ostats
biologists1349435b_____iologists
bryologists1745705b____ryologists
cardiologists1765145__cardiologists
cetologists1449165__c_e_tologists
ecclesiologist1962605ecclesiologist_
electrologists1765645elect_r_ologists
epidemiologists2162495epidemiologists
futurologists1773075_futur_ologists
glaciologists1753945glac___iologists
lichenologists2063035liche_nologists
liturgiologists17141805_liturgiologists
malariologist1693925ma_lariologist_
martyrologist1953325martyr_ologist_
materialists1456985ma_terial__ists
meteorologists1754185_meteorologists
metrologists1588835_met_r_ologists
microbiologists22134815microbiologists
necrologists1547875nec__r_ologists
numerologists1664015_numer_ologists
oceanologists1654305_oc_eanologists
osteologists1346765_oste__ologists
paleobiologists20115735paleobiologists
papyrologists2154085pa_pyr_ologists
pathologists1848375pa_t__hologists
petrologists1559145_pet_r_ologists
photobiologists2365175photobiologists
pteridologist17144605__pteridologist_
radiobiologists19174265radiobiologists
radiologists1497365ra___diologists
semiologists1548225___semiologists
serologists12410125___ser_ologists
sociobiologists2063625sociobiologists
sociologists1547945soc___iologists
soteriologies1453875_soteriologi_es
teleologists1347225___teleologists
teratologists1496595___teratologists
tribologists1546165___t_ribologists
victimologists2262255vict_imologists
watercolorist18182545wa_tercolorist_

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.0931921408.6
2DLD Change Limit65874634.62314249.2
3Display Results63630.0461369.6
 (SQL Overall)178691634.76237524.4
 
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.