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

69 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
paleoecologist1911472(None) 
paleoecologists20124171paleoecologists
paleobiologist19156342paleobiologist
paleoecologic2063322paleoecologi_c
paleoecologies1963552paleoecologies
paleontologist1765142paleontologist
paleozoologist2664192paleozoologist
paleobiologists20115733paleobiologists
paleoecological2263553paleoecological
paleoecology2062993paleoecolog__y
paleontologists1884523paleontologists
paleozoologists2763853paleozoologists
lexicologist2294914__lexicologist
malacologist1755634mal__acologist
paleobiologic2064784paleobiologi_c
paleobiologies1954904paleobiologies
paleontologic1863694paleontologi_c
paleontologies17103884paleontologies
paleozoologies2663184paleozoologies
palynologist1856304pal__ynologist
planetologist1664504p_lanetologist
algologist1248245_al___gologist
angelologist1454165_a_ngelologist
deontologist1457415__deontologist
dialectologist1882685diale_ctologist
ecologist12314145_____ecologist
electrologist1657045_electrologist
gynecologist1954575__gynecologist
lexicologists2374155__lexicologists
malacologists1854405mal__acologists
malariologist1693925mal_ariologist
meteorologist1654875meteo_rologist
myrmecologist2353315_myrmecologist
oncologist13410415____oncologist
paleobiological2264735paleobiological
paleobiology2053535paleobiolog__y
paleobotanist1772325paleo_botanist
paleologies1448585pal__e_ologies
paleontological2063845paleontological
paleontology1853305paleontolog__y
paleozoological2963265paleozoological
paleozoology2762625paleozoolog__y
palynologists1954995pal__ynologists
papyrologist2055095pa__pyrologist
parasitologist1763255parasitologist
pathologist17410665pa___thologist
pedologist14410865p____edologist
penologist13412845p____enologist
petrologist14711885p__e_trologist
pharmacologist2464175pharmacologist
phenomenologist2382685phenomenologist
phonologist17411565p__ho_nologist
photobiologist2266225photobiologist
photogeologist21134675photogeologist
phraseologist1954195phrase_ologist
phrenologist1857915p__hrenologist
phycologist2259185p___hycologist
planetologists1763625p_lanetologists
pomologist15412045p___o_mologist
proctologist1758965p__roctologist
protozoologist2663885protozoologist
psephologist2056605p_se_phologist
pteridologist17144605p_teridologist
radiobiologist18154675radiobiologist
radioecologies1882705radioecologies
selenologist1357005__selenologist
speleologist1555745_spele_ologist
teleologist1249385__tele_ologist
watercolorist18182545wate_rcolorist

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.360496363.9
2DLD Change Limit95024696.84313886.3
3Display Results69690.0461500.0
 (SQL Overall)178691697.24924650.4
 
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.