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

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

107 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
recapitulation186249(None) 
recapitulations1972391recapitulations
capitulation1644592__capitulation
recapitulating1962052recapitulating
capitulations1754063__capitulations
decapitation1748683decapit__ation
recalculation17114593reca_lculation
recapitulate1652543recapitulat__e
recapitulated1852433recapitulat_ed
recapitulates1752683recapitulat_es
capitation14311364__capit__ation
capitulating1773974__capitulating
decapitations1847664decapit__ations
encapsulation1752294encap_sulation
precipitation1966224precipit__ation
recalculations18104034reca_lculations
recalibration1754434recali_bration
recantation1349864reca_nt__ation
recirculation1764904rec_irculation
recitation12315944rec__it__ation
recompilation1955154recompi__lation
renaturation1256754rena__turation
repopulation1656104re__population
restimulation1555384re_stimulation
reticulation1448054re__ticulation
acidulation14105405___acidulation
blastulation1452595_bla_stulation
calculation1548295__ca_lculation
cantillation1446695__cantillation
capitalization2756195__capitalization
capitations1549855__capit__ations
capitularies1652745__capitularies
capitulate1445105__capitulat__e
capitulated1644155__capitulat_ed
capitulates1554425__capitulat_es
captivation1846175__cap_tivation
cavitation1549135__cavit__ation
copulation141111955__cop__ulation
crepitation1548395cre__pit__ation
decantation1448945deca_nt__ation
decapitating1854955decapit__ating
decapitator1653805decapit__at_or
decrepitation1884805decrepit__ation
denaturation1345885dena__turation
denticulation1654565de_nticulation
depilation13312035de__pi__lation
depopulation1765065de__population
ejaculation2096135_eja__culation
emasculation1655235_ema_sculation
encapsulations1851995encap_sulations
epilation11312965_e__pi__lation
expostulation2262615_expostulation
gesticulation1694705ge_sticulation
gratulation1245995_gra__tulation
habituation1643595__habitu_ation
manipulation1654665__manipulation
peculation14311995pec____ulation
perambulation1953485pera_mbulation
perpetuation1655345pe_rpetu_ation
precancellation2161165precancellation
precipitations2085395precipit__ations
reactivation17176955re_a_ctivation
realization20417225re_ali__zation
reanimation1359635re_ani__mation
reapplication1954725re_application
recalculating1853645reca_lculating
recalibrations1853695recali_brations
recanalization2557675recanalization
recantations1448875reca_nt__ations
recapitalize25125235recapit__alize
recapitalizing2863665recapitalizing
recaution1148095reca___u__tion
reciprocation19183495recip_rocation
recirculations1884225rec_irculations
recitations13314205rec__it__ations
recodification22125665recodification
recompilations2054955recompi__lations
recomputation1974395rec_omputation
reconfiguration2162055reconfiguration
recrimination1757405rec_rimination
rectification2049515rec_tification
recuperation1656725recup__eration
redistillation1563035redistillation
reformulation1853975re_formulation
regulation11312055re____gulation
rehabilitation1953275rehabilitation
reinflation1447205re___inflation
reinoculation1554425re_inoculation
reiteration11412165re___iteration
renaturations1355965rena__turations
repatriation14126975re__patriation
repopulations1765335re__populations
repunctuation1752525repunctu_ation
reputation12411885re__p__utation
reradiation12410155reradi___ation
reregulation1346415re__regulation
respiration13511195re_spi__ration
restimulations1654645re_stimulations
restitution1175975re_stitu__tion
retaliation11612325retali___ation
reticulations1556615re__ticulations
revalidation1657945revali__dation
revaluation1458145reva__lu_ation
securitization2554315securitization
spiculation1547035___spiculation
vermiculation2054595ve_rmiculation
vesiculation1746115ve__siculation

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.673265514.1
2DLD Change Limit950241076.82613920.9
3Display Results1071070.0801337.5
 (SQL Overall)1786911077.57923577.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.