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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
capitulation164459(None) 
capitulations1754061capitulations
capitation14311362capit__ation
capitulating1773972capitulating
recapitulation1862492recapitulation
acidulation14105403_acidulation
calculation1548293ca_lculation
cantillation1446693cantillation
capitalization2756193capitalization
capitations1549853capit__ations
capitularies1652743capitularies
capitulate1445103capitulat__e
capitulated1644153capitulat_ed
capitulates1554423capitulat_es
captivation1846173cap_tivation
cavitation1549133cavit__ation
copulation141111953cop__ulation
habituation1643593habitu_ation
manipulation1654663manipulation
recapitulations1972393recapitulations
spiculation1547033_spiculation
accumulation18153804accumulation
acetylation1643784_acetylation
acidulations15104814_acidulations
actuation11310334_a_ctu_ation
adulation10311014_a__dulation
agitation10311224_agit__ation
ambulation1447874_a_mbulation
angulation1149554_a_ngulation
annulation1068954_a_nnulation
appellation1564124_appellation
articulation1447974articulation
blastulation1452594blastulation
calculations1647074ca_lculations
calibration1545994cali_bration
cancelation1547784ca_ncelation
cancellation1655024cancellation
cantillations1545734cantillations
capacitation1854164capacitation
capitalizations2856054capitalizations
capitula1244984capitula____
capitular1343774capitula___r
capitulary1752554capitula__ry
caprification2256054caprification
captivations1945344cap_tivations
castigation1447974ca_stigation
castration12410804ca_st_ration
catenation1249524ca__tenation
caudation1269994ca___udation
causation1199524ca___usation
cavitations1647844cavit__ations
circulation1549394c_irculation
citation10314364c__it__ation
coagulation1447274c_oagulation
coaptation1448344coap_t__ation
cogitation13410084cogit__ation
compilation1749314compi__lation
copulations151111114cop__ulations
crenulation1347574c_renulation
crepitation1548394crepit__ation
cumulation1448174c__umulation
cupellation1544144cup_ellation
decapitation1748684decapit__ation
depilation13312034depi__lation
depopulation1765064depopulation
encapsulation1752294encap_sulation
epilation11312964_epi__lation
expostulation2262614expostulation
fasciculation20133564fasciculation
gastrulation1353844gastrulation
gratulation1245994_gratulation
habitation1547914habit__ation
habituations1743114habitu_ations
maculation14510984ma__culation
manipulations1754114manipulations
matriculation17125384matriculation
maturation1249514ma__turation
palpitation1546244palpit__ation
peculation14311994__peculation
pixilation1945914__pixilation
population14810024__population
postulation13119134_postulation
pustulation13116624_pustulation
recapitulating1962054recapitulating
repopulation1656104repopulation
reticulation1448054reticulation
sacculation1547844sa_cculation
sanitation10412044sanit__ation
sanitization2149154sanitization
saturation1049804sa__turation
simulation1269584__simulation
situation949424__situ_ation
speculation1547544_speculation
spiculations1646174_spiculations
sporulation1346404_sporulation
stimulation1377224_stimulation
stipulation1356334_stipulation
stridulation1354774stridulation
tabulation1247814ta__bulation
tribulation1346494_tribulation
trituration1146654_trituration
vacillation1645324vaci_llation
vesiculation1746114vesiculation

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901036.84618228.2
3Display Results1031030.0601716.7
 (SQL Overall)1786911037.29624491.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.