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.

83 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
cardiologist1656625car___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
aerobiologies1655056aer__obiologies
astrobiologists1873766_astrobiologists
biologist12412346______biologist
cardiologists1765146car___diologists
chronologer1753496chron___olog_er
chronologers1852486chron___ologers
chronological2175956chron___ological
chronology1945546chron___olog__y
conchologists2154566c__on_chologists
cosmetologist1853976c__osmetologist
cosmologist1648376c____osmologist
craniologies1545376c_ran__iologies
criminologist1863646c_r_iminologist
cryobiological2463926c_r_yobiological
cryobiology2252736c_r_yobiolog__y
cryptologist2056436c_r__yptologist
cryptozoologist3271796cryptozoologist
demonologist1657056demon___ologist
deontologist1457416_deon__tologist
exobiologists2355326___exobiologists
geochronologist2272306geochron___ologist
gerontologists1654856geron__tologists
horologist14412366_h___o_rologist
hydrobiologies2473806_hydrobiologies
microbiologists22134816_microbiologists
monologist13413616__mon___ologist
neonatologist14135356_neon_atologist
neurobiologists18114316_neurobiologists
oncologist13410416___on__cologist
onomatologist1654406___onomatologist
ontologist11411366___on__tologist
ornithologist1753326_or_nithologist
paleobiologists20115736_paleobiologists
phenomenologist2382686phenomenologist
phonologists1848776ph_on___ologists
photobiological2564456ph_otobiological
photobiology2384016ph_otobiolog__y
photogeologists22173646ph_otogeologists
phraseologist1954196phr__aseologist
phrenologists1956296phren___ologists
physiologist21157326ph___ysiologist
proctologist1758966_pr__octologist
protozoologists2763036_protozoologists
radiobiologists19174266_radiobiologists
radiologist1399496__r__adiologist
sociobiologists2063626_sociobiologists
sociologist1449886____sociologist
thanatologist1753616th_an_atologist
tribologist1447726_tr__ib_ologist

Search took 8 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.346516448.0
2DLD Change Limit95024836.96613641.1
3Display Results83830.0631317.5
 (SQL Overall)178691837.37524229.3
 
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.