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 “paleontological” 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
paleontological206384(None) 
paleobiological2264732paleobiological
paleoecological2263552paleoecological
paleontologic1863692paleontologic__
paleozoological2963262paleozoological
deontological1755173__deontological
paleontologies17103883paleontologi_es
paleontologist1765143paleontologi_st
paleontologists1884523paleontologists
palynological2154673pal_yn_ological
dialectological2162094diale_ctological
gerontological1854174_gerontological
ontological1448314____ontological
paleobiologic2064784paleobiologic__
paleoecologic2063324paleoecologic__
paleontology1853304paleontolog___y
parasitological2062774parasitological
penological1648874p__e_n_ological
phenological2068054p_he_n_ological
phonological2058374p__hon_ological
phrenological2156334phre_n_ological
planetological1953174p_lanetological
proctological2055824p__roctological
selenological1654664sele_n_ological
aerobiological1955135_aerobiological
algological1545975_al___gological
anthological1847505_a___nthological
antilogical1447265_a___ntilogical
chronological2175955_chron_ological
climatological2162615_climatological
demonological1954965_demon_ological
enological1348885___e_n_ological
hematological2155945__hematological
iconological1756025__icon_ological
limnological1745075__limn_ological
malacological2053975mal__acological
meteorological1953785meteo_rological
narratological1763095na_rratological
nematological1855665__nematological
oncological1647255____oncological
paleobiologies1954905paleobiologi_es
paleobiologist19156345paleobiologi_st
paleobiologists20115735paleobiologists
paleobotanical2071335paleo_botanical
paleoecologies1963555paleoecologi_es
paleoecologist19114725paleoecologi_st
paleoecologists20124175paleoecologists
paleozoologies2663185paleozoologi_es
paleozoologist2664195paleozoologi_st
paleozoologists2763855paleozoologists
palynologic1953665pal_yn_ologic__
palynologically26123195pal_yn_ologically
pathological2047975pa___thological
pedological1757615p__e__dological
petrological1758595p__e_trological
photobiological2564455photobiological
photogeological2463105photogeological
pomological1848035p___o_mological
praxeological2554435praxe___ological
prebiological2055975p_re_biological
primatological2183215p_rimatological
psephological2354985p_se_phological
pteridological2053595p_teridological
radiobiological2163345radiobiological
speleological1853915spele___ological
tautological1555485ta___utological
teleological1546575tele___ological
teratological1656115__teratological
volcanological2262225volcan_ological

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.326548131.9
2DLD Change Limit65874694.87313518.2
3Display Results69690.0501380.0
 (SQL Overall)178691695.24934042.9
 
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.