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 “chronobiologist” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

34 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
chronobiologist239279(None) 
chronobiologic2472012chronobiologi_c
chronobiologies2362102chronobiologies
chronobiology2481793chronobiolog__y
chronologist1857623chron___ologist
cryobiologist2154523c_r_yobiologist
photobiologist2266223ph_otobiologist
chronologists1966114chron___ologists
cryobiologists2254104c_r_yobiologists
hydrobiologist24204504_hydrobiologist
nonbiologist1555914__non_biologist
photobiologists2365174ph_otobiologists
astrobiologist1784195_astrobiologist
cardiologist1656615car___diologist
chronologic1955785chron___ologi_c
chronologies1846415chron___ologies
conchologist2055815c__on_chologist
cryobiologies2153615c_r_yobiologies
exobiologist2256205___exobiologist
gerontologist1555985geron__tologist
hydrobiologists25134045_hydrobiologists
microbiologist21135495_microbiologist
neurobiologist17124925_neurobiologist
nonbiologists1664725__non_biologists
paleobiologist19156345_paleobiologist
phonologist17411565ph_on___ologist
photobiologic2365205ph_otobiologi_c
photobiologies2265155ph_otobiologies
photogeologist21134675ph_otogeologist
phrenologist1857915phren___ologist
protozoologist2663885_protozoologist
psychobiologist2874365psychobiologist
radiobiologist18154675_radiobiologist
sociobiologist1964045_sociobiologist

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.330541487.9
2DLD Change Limit65874343.76617491.8
3Display Results34340.0301133.3
 (SQL Overall)178691344.12643308.5
 
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.