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

55 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
bacteriological228286(None) 
bacteriologic2062342bacteriologic__
bacteriologies1952823bacteriologi_es
bacteriologist1963693bacteriologi_st
bacteriologists2063253bacteriologists
soteriological1763893_soteriological
astrological1547024_ast_r_ological
autecological1854434_aute_cological
bacteriology2052884bacteriolog___y
bacteriolytic2261644bacteriolytic__
ecclesiological1992314ecclesiological
pteridological2053594__pteridological
stereological1655674__stereological
abiological1647835_a___biological
aerobiological1955135_aerobiological
anthological1847515_ant__hological
anthropological2373105_anthropological
antilogical1447275_ant__i_logical
audiological1665665_a__udiological
axiological2146875_a___xiological
bactericidal1981765bacteri___cidal
bacteriolysis2061805bacteriolysi__s
biological15128885b_____iological
bryological1945375b____ryological
cardiological1954975__cardiological
epidemiological23172605epidemiological
etiological1448415____etiological
futurological1952985_futur_ological
glaciological1963915glac___iological
hagiological1955815ha___giological
karyological2274735ka___ryological
lichenological22112835liche_nological
meteorological1953785_meteorological
metrological1748375_met_r_ological
microbiological2464375microbiological
necrological1747285nec__r_ological
numerological1854015_numer_ological
osteological1546375_oste__ological
paleobiological2264735paleobiological
pathological2047985pa_t__hological
petrological1758595_pet_r_ological
photobiological2564455photobiological
prebiological2055975__prebiological
radiobiological2163345radiobiological
radiological1646985ra___diological
scatological1745545scat___ological
semiological1747785___semiological
serological1468775___ser_ological
sociobiological2273515sociobiological
sociological1747505soc___iological
tautological1555485taut___ological
teleological1546575___teleological
teratological1656115___teratological
terminological1953645___terminological
tribological1745985___t_ribological

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.313570897.8
2DLD Change Limit65874554.57614395.5
3Display Results55550.0331666.7
 (SQL Overall)178691554.92236304.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.