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

40 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
hydrobiological276358(None) 
aerobiological1955133_aerobiological
hydrobiologies2473803hydrobiologi_es
hydrobiologist24204503hydrobiologi_st
hydrobiologists25134043hydrobiologists
hydrological2246483hydr___ological
microbiological2464373microbiological
neurobiological20123923neurobiological
radiobiological2163343radiobiological
cryobiological2463924_cryobiological
exobiological2554724__exobiological
hydrobiology2562784hydrobiolog___y
paleobiological2264734paleobiological
photobiological2564454photobiological
prebiological2055974__prebiological
sociobiological2273514sociobiological
abiological1647835____abiological
audiological1665665aud___iological
biological15128885_____biological
cardiological1954975_car_diological
chronological2175955_chro_nological
deontological1755175__deontological
gerontological1854175_gerontological
hagiological1955815h___agiological
herpetological2253325h_erpetological
homological1948455h___o_mological
horological1748285h___o_rological
hydrocolloidal247915hydro_colloidal
hydrologic2046675hydr___ologic__
hydrologically27104505hydr___ologically
microbiologic2264525microbiologic__
myrmecological2662645my_rmecological
nonbiological1855265__nonbiological
physiological2455575phy___siological
proctological2055825__proctological
radiobiologic1963535radiobiologic__
radiological1646985___radiological
sociological1747505___sociological
tribological1745985__trib_ological
tropological1746635__tro_pological

Search took 6 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.360496363.9
2DLD Change Limit65874404.61014289.4
3Display Results40400.0301333.3
 (SQL Overall)178691405.00035738.2
 
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.