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

45 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
antitheoretical207136(None) 
antithetical1754883antith___etical
atheoretical1763023a___theoretical
nontheoretical1962023_nontheoretical
untheoretical1861983un__theoretical
theoretical1653954____theoretical
anticlerical1654245anticle_r__ical
antipolitical1764055anti__political
antithetic1547405antith___etic__
antithetically2264515antith___etically
arithmetical1962795a_rith__metical
aesthetical1655746a_esth___etical
antheridial1553346an__the_ridi_al
anthological1847516an__th_ological
anthropical1855356an__th__ropical
anticlericals1763156anticle_r__icals
anticlimactical2071056anticlimactical
antiemetic1498266anti__e_metic__
antiemetics1586126anti__e_metic_s
antierotic1248626anti__e_rotic__
antiheroic1556386anti_he_r_oic__
antihistorical1972526anti_historical
antilogical1447276anti__lo__gical
antimonarchical2491436antimonarchical
antipoetic1448226anti__po_etic__
antipyretic18144726anti__pyretic__
antipyretics19143976anti__pyretic_s
antiradical1455656anti____radical
antirheumatic2062336antirheumatic__
antirheumatics2161896antirheumatic_s
antitumoral1352756antitumor____al
atheistical1654576a___the_istical
epithetical1854616_epith___etical
heretical1448636_____he_retical
intercortical1764426int_ercor_tical
metathetical1953766metath___etical
meteoritical1652956__met_eoritical
nontheological2063216_nontheological
pantheistical2063006pan__the_istical
pantisocratical2171936panti_socratical
theocratical1963426____theocratical
theoretic1446666____theoretic__
theoretically2186256____theoretically
theoretician1762726____theoretician
tritheistical1862006_trithe_istical

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 Filter178691950240.436409841.7
2DLD Change Limit95024458.09311741.5
3Display Results45450.0331363.6
 (SQL Overall)178691458.56220870.2
 
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.