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

43 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
epidemiological23172601epidemiological_
epidemiologic2162003epidemiologic___
epidemiologies2062294epidemiologi__es
epidemiologist2062764epidemiologi__st
epidemiologists2162494epidemiologi_sts
epistemological22101944epistem_ological_
ecclesiological1992315ecclesiological_
epidemiology2161965epidemiolog____y
ideological15106645__ide__ological_
prebiological2055975_p_rebiological_
semiological1747785___semiological_
unideological1763335unide__ological_
audiological1665666_aud__iological_
bacteriological2282876bacteriological_
cardiological1954976card__iological_
criminological21102776cri__minological_
demonological1954966___demonological_
entomological1855036e_ntom_ological_
epidemical1753816epidem_____ical_
etiological1448416____etiological_
etymological2045876e__tym_ological_
exobiological2554726e__xobiological_
gemological1747026___gem_ological_
ideologically2055036__ide__ologically
limnological1745076_li__mnological_
nonideological1862526nonide__ological_
orismological1853626ori_sm_ological_
paleobiological2264736_paleobiological_
pedological1757616_p__e_dological_
penological1648876_p__e_nological_
petrological1758596_p__etrological_
phenological2068056_p_he_nological_
phrenological2156336_phre_nological_
physiological2455576_p_hysiological_
pomological1848036_p__om_ological_
psephological2354986_p_sephological_
pteridological2053596_p_teridological_
radiobiological2163346radiobiological_
radiological1646996_rad__iological_
seismological1873966sei_sm_ological_
semiologically2254996___semiologically
soteriological1763896_soteriological_
speleological1853916sp__eleological_

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 Limit65874435.09312934.2
3Display Results43430.0331303.0
 (SQL Overall)178691435.45232775.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.