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 “lichenologist” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
lichenologist197391(None) 
lichenologists2063031lichenologists
lichenologies1952912lichenologies
lichenological22112833lichenological
lichenology2052383lichenolog__y
limnologist1446683li__mnologist
technologist18137403tech_nologist
archaeologist19113494archaeologist
cetologist13412254__c_etologist
chronologist1857624__chronologist
diabetologist17133144diabetologist
enologist10314124____enologist
ethnologist1549264_eth_nologist
ichnologies1746364_ich_nologies
ichthyologist2562784_ichthyologist
ideologist1248534_i_de_ologist
immunologist17135324_immunologist
limnologists1545324li__mnologists
oceanologist1555684_oceanologist
penologist13412844___penologist
phonologist17411564__phonologist
phrenologist1857914_phrenologist
rheologist1449534__rhe_ologist
selenologist1357004_selenologist
sinologist11510664si___nologist
technologists19125704tech_nologists
trichologist1856744trich__ologist
victimologist2162624victimologist
angelologist1454165_angelologist
anthologist15410465anth__ologist
archaeologists20122815archaeologists
archeologies1845005arche_ologies
bacteriologist1963695bacteriologist
biologist12412345bi____ologist
biotechnologist2371565biotechnologist
campanologist2053385campanologist
cetologists1449165__c_etologists
chronologists1966115__chronologists
climatologist1873945cli_matologist
conchologist2055815conch__ologist
cosmetologist1853975cosmetologist
cosmologist1648375__cosmologist
criminologist1863645criminologist
cytologist16410535__c_ytologist
demonologist1657055_demonologist
diabetologists18122815diabetologists
dialectologist1882685dialectologist
dichotomist1974185dich__otomist
ecclesiologist1962605ecclesiologist
ecologist12314145____ecologist
electrologist1657045elec_trologist
enologists11310625____enologists
epistemologist1972515epistemologist
escapologist1754485esc_apologist
ethnologists1647045_eth_nologists
ethologist14411895_eth__ologist
fetologist14410405___fetologist
gemologist141010285___gemologist
geochronologist2272305geochronologist
geologist11611785___ge_ologist
glaciologist1654895glac__iologist
gynecologist1954575_gynecologist
herpetologist1984795herpetologist
histologist1547985hi__stologist
horologist14412365___horologist
ichnology1844995_ich_nolog__y
ichthyologists2662315_ichthyologists
iconologies1447095_ic_onologies
ideologists1346655_i_de_ologists
immunologists18124495_immunologists
iridologist1345795_i_ridologist
lexicologist2294915l_exicologist
lichenose1443365lichen__o__se
lichenous1444315lichen__o_us_
limnologic1553535li__mnologi_c
limnologies1445535li__mnologies
lithologic1645015lith__ologi_c
lithologies1546835lith__ologies
liturgiologist16131855liturgiologist
methodologist2054315methodologist
microbiologist21135495microbiologist
mineralogist1553265mi_neralogist
mixologist2047695mi___xologist
monologist13413615___monologist
museologist1445805_muse_ologist
mycologist18410355myc___ologist
myrmecologist2353315myrmecologist
mythologist2058995myth__ologist
necrologist14410125nec__rologist
neologist10712815___ne_ologist
nephrologist1856305neph_rologist
numerologist1574915_numerologist
oceanologists1654305_oceanologists
oncologist13410415onc___ologist
osteologist1248565_oste_ologist
palynologist1856305_palynologist
pathologist17410665path__ologist
pedologist14410865___pedologist
penologists1449595___penologists
phenologies1749355__phenologies
philologist1768435__philologist
phonologists1848775__phonologists
phrenologists1956295_phrenologists
phycologist2259185__phycologist
piccoloist1654045pic__colo_ist
planetologist1664505planetologist
psychologist23109115psych__ologist
rheologists1547315__rhe_ologists
selenologists1455335_selenologists
serologist11413155___serologist
sexologist1849515___sexologist
sinologists1257675si___nologists
sociologist1449885soc__iologist
speleologist1555745spele_ologist
technologic1954485tech_nologi_c
technologies1845975tech_nologies
technologize2753445tech_nologize
teleologist1249385_tele_ologist
theologise14117745__the_ologise
trichologists1955425trich__ologists
urbanologist1554045_urbanologist
victimologists2262255victimologists
virologist1448815vi___rologist
volcanologist1993165volcanologist
vulcanologist1982705vulcanologist

Search took 9 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 Filter1786911247900.436409841.7
2DLD Change Limit1247901258.45614757.6
3Display Results1251250.0931344.1
 (SQL Overall)1786911258.98519887.7
 
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.