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

84 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
criminological2110277(None) 
climatological2162613climatological
criminologies1852953criminologi_es
criminologist1863643criminologi_st
criminologists1952973criminologists
limnological1745073_lim_nological
primatological2183213primatological
terminological1953643terminological
cardiological1954974cardi_ological
chronological2175954c_hronological
codicological1853894c_odicological
cosmological1946084cosm__ological
criminology1952424criminolog___y
cryobiological2463924cryobiological
cryptological2354794cr_yptological
demonological1954964_demonological
iconological1756024__iconological
immunological2054014_immunological
orismological1853624ori_smological
prebiological2055974prebi_ological
radiological1646984_radi_ological
semiological1747784_semi_ological
sinological1447134___sinological
tribological1745984tr__ibological
abiological1647835__abi_ological
aerobiological1955135aerobi_ological
archaeological22152935archaeological
audiological1665665_audi_ological
axiological2146875__axi_ological
biological15128885___bi_ological
bryological1945375br___yological
cohomological2354085c_ohomological
cytological1947455c___ytological
dermatological2053855dermatological
enological1348885____enological
epidemiological23172605epidemi_ological
ethnological1846815__ethnological
etiological1448415__eti_ological
etymological2045875etym__ological
exobiological2554725exobi_ological
gemological1747025_gem__ological
glaciological1963915glaci_ological
graphological2253525gr_aphological
hagiological1955815_hagi_ological
hematological2155945_hematological
histological1846085_hi_stological
homological1948455_hom__ological
ideological15106645__i_deological
lichenological22112835lichenological
limnologic1553535_lim_nologic__
lithological1845895_li_thological
microbiological2464375microbi_ological
musicological2053545_musicological
mycological2147115___mycological
myrmecological2662645myrmecological
nematological1855665_nematological
nomological1648075_nom__ological
nonbiological1855265nonbi_ological
numerological1854015_numerological
ornithological2082455ornithological
palynological2154675_palynological
parasitological2062775parasitological
penological1648875___penological
phenological2068055__phenological
philological2046375__philological
phonological2058375__phonological
phrenological2156335_phrenological
physiological2455575physi_ological
pomological1848035_pom__ological
praxeological2554435pr_axeological
proctological2055825pr_octological
pteridological2053595pteridological
rheological17127475_r__heological
seismological1873965sei_smological
selenological1654665_selenological
sociological1747505_soci_ological
somatological1854885_somatological
technological2155145_technological
toxicological2553985_toxicological
tropological1746635tr__opological
unideological1763335uni_deological
urological1347755ur____ological
virological1746305___virological
volcanological2262225volcanological

Search took 7 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 Limit95024845.59316989.8
3Display Results84840.0631333.3
 (SQL Overall)178691846.01629702.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.