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

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

53 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
antitheoretical2071361antitheoretical_
antithetical1754884antith___etical_
atheoretical1763024a___theoretical_
nontheoretical1962024_nontheoretical_
untheoretical1861984un__theoretical_
antithetically2264515antith___etically
theoretical1653955____theoretical_
anticlerical1654246anticle_r__ical_
anticlericals1763156anticle_r__icals
antipolitical1764056anti__political_
antithetic1547406antith___etic___
arithmetical1962796a_rith__metical_
theoretically2186256____theoretically
aesthetical1655747a_esth___etical_
anchoritically2463597an__ch_oritically
anesthetically2254287anesth___etically
antheridial1553347an__the_ridi_al_
anthological1847517an__th_ological_
anthropical1855357an__th__ropical_
antibiotically2163457anti_bio__tically
anticlimactical2071057anticlimactical_
antiemetic1498267anti__e_metic___
antiemetics1586127anti__e_metic__s
antierotic1248627anti__e_rotic___
antiguerrilla1471017antigue_r_ri_lla
antiheroic1556387anti_he_r_oic___
antihistorical1972527anti_historical_
antilogical1447277anti__lo__gical_
antimonarchical2491437antimonarchical_
antiparticle1663047anti__par_tic_le
antipoetic1448227anti__po_etic___
antipyretic18144727anti__pyretic___
antipyretics19143977anti__pyretic__s
antiradical1455657anti____radical_
antirheumatic2062337antirheumatic___
antirheumatics2161897antirheumatic__s
antiseptically2163707anti_se__ptically
antitumoral1352757antitumor____al_
arithmetically2453867a_rith__metically
atheistical1654577a___the_istical_
epithetical1854617_epith___etical_
heretical1448637_____he_retical_
intercortical1764427int_ercor_tical_
metathetical1953767metath___etical_
meteoritical1652957__met_eoritical_
nontheological2063217_nontheological_
pantheistical2063007pan__the_istical_
pantisocratical2171937panti_socratical_
theocratical1963427____theocratical_
theoretic1446667____theoretic___
theoretician1762727____theoretician
theoreticians1862267____theoreticians
tritheistical1862007_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.360496363.9
2DLD Change Limit95024537.92311993.4
3Display Results53530.0461152.2
 (SQL Overall)178691538.32921454.1
 
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.