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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

51 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
atheistical165457(None) 
theistical1545131_theistical
atheistic1447352atheistic__
atheistically2166352atheistically
pantheistical2063002pantheistical
alchemistical2261843alchemistical
atheoretical1763023atheoretical
deistical1246673__deistical
mathematical2153803mathematical
pathetical1747513pathe__tical
patristical1555553pat_ristical
statistical1354203statistical
theistic1348153_theistic__
theistically2067363_theistically
thetical1349123_the__tical
tritheistical1862003tritheistical
acoustical1454034a_coustical
acritical1348144a_cri_tical
acrostical1445834a_crostical
aesthetical1655744aesthe__tical
aestival1145484a__e_stival
ahistorical1654054a_h_istorical
albitical1345294a_lbi_tical
apolitical1446294apoli_tical
ascetical1346284asce__tical
atavistic1445984atavistic__
atavistically2175524atavistically
atheist10314064atheist____
atheists1138714atheist___s
athetotic1455404athetotic__
atomistic1347774atomistic__
atomistically2056454atomistically
casuistical1553004casuistical
egoistical1354334_egoistical
egotistical1453164egotistical
ekistical1544804__ekistical
eristical1148434__eristical
gestical1138994__ge_stical
hectical1547934__he_ctical
heretical1448634__heretical
logistical1355044_logistical
monotheistical2171694monotheistical
pantheistic1855164pantheistic__
pantheistically2563604pantheistically
phthisical2053484phthis_ical
polytheistical24131524polytheistical
seismical1344644__seismical
sophistical1854844sophistical
theatrical1544484_theatrical
theoretical1653954_theoretical
theurgical1652354_theurgical

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819519.25016088.5
3Display Results51510.0163187.5
 (SQL Overall)178691519.68918442.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.