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

97 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
paleobiologist1915634(None) 
paleobiologists20115731paleobiologists
paleobiologic2064782paleobiologi_c
paleobiologies1954902paleobiologies
paleoecologist19114722paleoecologist
paleontologist1765142paleontologist
paleozoologist2664192paleozoologist
paleobiological2264733paleobiological
paleobiology2053533paleobiolog__y
paleoecologists20124173paleoecologists
paleontologists1884523paleontologists
paleozoologists2763853paleozoologists
photobiologist2266223photobiologist
radiobiologist18154673radiobiologist
astrobiologist1784194astrobiologist
cryobiologist2154524_cryobiologist
exobiologist2256204__exobiologist
hydrobiologist24204504hydrobiologist
malariologist1693924mal_ariologist
microbiologist21135494microbiologist
neurobiologist17124924neurobiologist
paleobotanist1772324paleob_otanist
paleoecologic2063324paleoecologi_c
paleoecologies1963554paleoecologies
paleontologic1863694paleontologi_c
paleontologies17103884paleontologies
paleozoologies2663184paleozoologies
palynologist1856304pal__ynologist
pathobiologies2274194pathobiologies
photobiologists2365174photobiologists
psychobiologist2874364psychobiologist
radiobiologists19174264radiobiologists
sociobiologist1964044sociobiologist
aerobiologies1655055_aerobiologies
algologist1248245_al___gologist
astrobiologists1873765astrobiologists
audiologist1347245_a__udiologist
bacteriologist1963695bacteriologist
biologist12412345_____biologist
cardiologist1656625ca__rdiologist
chronobiologist2392795chronobiologist
cryobiologists2254105_cryobiologists
deontologist1457415__deontologist
dialectologist1882685diale_ctologist
ecclesiologist1962605eccle_siologist
electrologist1657055_electrologist
epidemiologist2062765epide_miologist
exobiologists2355325__exobiologists
glaciologist1654895_gl_aciologist
hydrobiologists25134045hydrobiologists
lexicologist2294915__lexicologist
malacologist1755635mal__acologist
malariologists1773355mal_ariologists
meteorologist1654875meteo_rologist
microbiologists22134815microbiologists
neurobiologists18114315neurobiologists
nonbiologist1555915__nonbiologist
paleobotanists1871985paleob_otanists
paleoecological2263555paleoecological
paleoecology2062995paleoecolog__y
paleologies1448585pale___ologies
paleontological2063845paleontological
paleontology1853305paleontolog__y
paleozoological2963265paleozoological
paleozoology2762625paleozoolog__y
palynologists1954995pal__ynologists
papyrologist2055095pa__pyrologist
parasitologist1763255parasitologist
pathobiology2362965pathobiolog__y
pathologist17410665pa___thologist
pedologist14410865p__e__dologist
penologist13412845p__e__nologist
petrologist14711885p__e_trologist
phlebologies2054655phle_b_ologies
phlebotomist2162555phle_b_otomist
phonologist17411565p__ho_nologist
photobiologic2365205photobiologi_c
photobiologies2265155photobiologies
photogeologist21134675photogeologist
phrenologist1857915phre__nologist
physiologist21157325p__hysiologist
planetologist1664505p_lanetologist
pomologist15412045p___o_mologist
prebiologic1884735p_re_biologi_c
proctologist1758965p__roctologist
protozoologist2663885protozoologist
psephologist2056605p_se_phologist
pteridologist17144605p_teridologist
radiobiologic1963535radiobiologi_c
radiobiologies1863655radiobiologies
radiologist1399495ra___diologist
selenologist1357005sele__nologist
semiologist14410715__se_miologist
sociobiologists2063625sociobiologists
sociologist1449885___sociologist
speleologist1555745spele___ologist
teleologist1249385tele___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.343520965.0
2DLD Change Limit95024976.65614276.4
3Display Results97970.0631539.7
 (SQL Overall)178691977.06225303.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.