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

78 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
paleobiological2264731paleobiological_
paleobiologic2064783paleobiologic___
paleoecological2263553paleoecological_
paleontological2063843paleontological_
paleozoological2963263paleozoological_
aerobiological1955134_aerobiological_
paleobiologies1954904paleobiologi__es
paleobiologist19156344paleobiologi__st
paleobiologists20115734paleobiologi_sts
photobiological2564454photobiological_
prebiological2055974p_re_biological_
radiobiological2163344radiobiological_
abiological1647835_a___biological_
cryobiological2463925_cryobiological_
exobiological2554725__exobiological_
hydrobiological2763585hydrobiological_
microbiological2464375microbiological_
neurobiological20123925neurobiological_
paleobiology2053535paleobiolog____y
paleobotanical2071345paleob_otanical_
paleoecologic2063325paleoecologic___
paleontologic1863695paleontologic___
palynological2154675pal__ynological_
sociobiological2273515sociobiological_
algological1545976_al___gological_
audiological1665666_a__udiological_
axiological2146876_a___xiological_
bacteriological2282866bacteriological_
biological15128886_____biological_
biologicals16105026_____biologicals
cardiological1954976ca__rdiological_
deontological1755176__deontological_
dialectological2162096diale_ctological_
ecclesiological1992316eccle_siological_
epidemiological23172606epide_miological_
etiological1448416___e_tiological_
glaciological1963916_gl_aciological_
hagiological1955816ha___giological_
malacological2053976mal__acological_
meteorological1953786meteo_rological_
nonbiological1855266__nonbiological_
paleoecologies1963556paleoecologi__es
paleoecologist19114726paleoecologi__st
paleoecologists20124176paleoecologi_sts
paleontologies17103886paleontologi__es
paleontologist1765146paleontologi__st
paleontologists1884526paleontologi_sts
paleozoologies2663186paleozoologi__es
paleozoologist2664196paleozoologi__st
paleozoologists2763856paleozoologi_sts
palynologically26123196pal__ynologically
parasitological2062776parasitological_
pathobiologies2274196pathobiologi__es
pathological2047986pa___thological_
pedological1757616p__e__dological_
penological1648876p__e__nological_
petrological1758596p__e_trological_
phenological2068056p_he__nological_
phonological2058376p__ho_nological_
photobiologic2365206photobiologic___
photogeological2463106photogeological_
phrenological2156336phre__nological_
physiological2455576p__hysiological_
planetological1953176p_lanetological_
pomological1848036p___o_mological_
praxeological2554436praxe___ological_
prebiologic1884736p_re_biologic___
proctological2055826p__roctological_
psephological2354986p_se_phological_
pteridological2053596p_teridological_
radiobiologic1963536radiobiologic___
radiological1646986ra___diological_
selenological1654666sele__nological_
semiological1747786__se_miological_
sociological1747506___sociological_
soteriological1763896sote_riological_
speleological1853916spele___ological_
teleological1546576tele___ological_

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 Limit65874784.39015005.5
3Display Results78780.0631238.1
 (SQL Overall)178691784.78337359.6
 
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.