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

99 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
antispeculation1910200(None) 
antispeculative2271622antispeculative
articulation1447974arti___culation
overspeculation2263334overspeculation
speculation1547544____speculation
anticipation1668285anti___cipation
antidefamation2061495anti_defamation
antievolution1662685anti__evolution
antipollution1562565anti_p_ollution
antiquation2047425anti___qu_ation
antisegregation1771915antisegregation
articulations1546735arti___culations
denticulation1654565denti___culation
inosculation1445275in_os__culation
interpellation1665615interpe_llation
interpopulation1963595interpopulation
intrapopulation19181835intrapopulation
manipulation1654665man_i_p__ulation
nonspeculative2161995_nonspeculative
peculation14311995_____peculation
reticulation1448055reti___culation
speculations1646395____speculations
spiculation1547035____spiculation
stipulation1356335_sti_p__ulation
acidulation14105406a_ci___dulation
angulation1149556an_____gulation
annihilation1594506anni___hilation
annulation1068956an_____nulation
antepenultima17131506ant_epenul_tima
anticipations1757496anti___cipations
anticorruption1871926anticorru_ption
antidilution1383846anti___dilution
antieducational18101536anti__educational
antielectron1463456antielec___tron
antifriction1773986antifric___tion
antineutron11102656anti_ne_u__tron
antipollutions1662016anti_p_ollutions
antiquations2146246anti___qu_ations
antirecession1562676anti_rec_ession
antireflection19102416anti_reflection
antiregulatory1891236anti_regulatory
antirejection2283216anti_re_jection
antireligion1362916anti_re__ligion
antirheumatic2062336antirhe_umati_c
antirheumatics2161896antirhe_umatics
antiseparatist1673516antis_eparatist
antisexualities2263486antis_exualities
antisexuality2364366antis_exu_ality
appellation1564126a___ppe_llation
articulating1556766arti___culating
articulative1755756arti___culative
articulator1376656arti___culat_or
attenuation1144186a_t__tenu_ation
auscultation1453476a__us__cultation
cantillation1446696canti____llation
circulation1549396__ci__rculation
denticulations1753916denti___culations
dispensation1555606__dispe_nsation
disputation14116746__disp__utation
disrelation1248816__disre__lation
dissimulation1655376__dissimulation
emasculation1655236_emas__culation
encapsulation1752296en_cap_sulation
fantastication1962236fantastic__ation
fasciculation20133566__fasciculation
gesticulation1694696__gesticulation
inoculation1358716___i_noculation
inosculations1554426in_os__culations
inspection1446666in__spec___tion
insulation10311666in__s___ulation
intercalation1557086int__ercalation
intermodulation1893066intermodulation
interpellations1774706interpe_llations
interpolation1558556interp__olation
interrelation1358736interre__lation
introspection1764626introspec___tion
manipulations1754116man_i_p__ulations
matriculation17125386mat__riculation
miscalculation2083036__miscalculation
miseducation1793456__mis_education
nonregulation1473906_n_onregulation
osculation1249676___os__culation
overspeculating2362776overspeculating
peculations15310286_____peculations
postinoculation1961846posti_noculation
recirculation1764906reci__rculation
reinoculation1554426_rei_noculation
reticulations1556616reti___culations
sacculation1547846____sacculation
speciation1449396____spec_iation
speculating1645946____speculating
speculative1844276____speculative
speculator1484886____speculat_or
spiculations1646176____spiculations
sporulation1346406____sporulation
stimulation1377226_sti___mulation
stipulations1455446_sti_p__ulations
tessellation1252756__tesse_llation
vesiculation1746116__ves_iculation

Search took 8 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.1261418182.5
2DLD Change Limit95024997.57612542.8
3Display Results99990.0761302.6
 (SQL Overall)178691997.77822973.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.