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
antitheoretical2071341antitheoretical_
antithetical1754864antith___etical_
atheoretical1763004a___theoretical_
nontheoretical1962004_nontheoretical_
untheoretical1861964un__theoretical_
antithetically2264505antith___etically
theoretical1653945____theoretical_
anticlerical1654226anticle_r__ical_
anticlericals1763136anticle_r__icals
antipolitical1764036anti__political_
antithetic1547406antith___etic___
arithmetical1962796a_rith__metical_
theoretically2186256____theoretically
aesthetical1655747a_esth___etical_
anchoritically2463587an__ch_oritically
anesthetically2254277anesth___etically
antheridial1553347an__the_ridi_al_
anthological1847507an__th_ological_
anthropical1855347an__th__ropical_
antibiotically2163447anti_bio__tically
anticlimactical2071037anticlimactical_
antiemetic1498267anti__e_metic___
antiemetics1586127anti__e_metic__s
antierotic1248617anti__e_rotic___
antiguerrilla1471007antigue_r_ri_lla
antiheroic1556387anti_he_r_oic___
antihistorical1972517anti_historical_
antilogical1447257anti__lo__gical_
antimonarchical2491417antimonarchical_
antiparticle1663027anti__par_tic_le
antipoetic1448217anti__po_etic___
antipyretic18144717anti__pyretic___
antipyretics19143967anti__pyretic__s
antiradical1455637anti____radical_
antirheumatic2062337antirheumatic___
antirheumatics2161897antirheumatic__s
antiseptically2163687anti_se__ptically
antitumoral1352757antitumor____al_
arithmetically2453867a_rith__metically
atheistical1654577a___the_istical_
epithetical1854617_epith___etical_
heretical1448637_____he_retical_
intercortical1764407int_ercor_tical_
metathetical1953757metath___etical_
meteoritical1652947__met_eoritical_
nontheological2063217_nontheological_
pantheistical2062987pan__the_istical_
pantisocratical2171917panti_socratical_
theocratical1963407____theocratical_
theoretic1446667____theoretic___
theoretician1762727____theoretician
theoreticians1862267____theoreticians
tritheistical1862007_trithe_istical_

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 Filter178691950240.1231452772.4
2DLD Change Limit95024539.37610134.8
3Display Results53530.0461152.2
 (SQL Overall)178691539.54518720.9
 
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.