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

128 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
prorogations155672(None) 
prorogation1447391prorogation_
arrogations12126482ar_rogations
prolongations1673352prolongations
propagations1745552propagations
prorations12314462pror__ations
prorogating1556062prorogati_ng
protonations1449072protonations
provocations1956872provocations
abrogations14116463_abrogations
arrogation11107443ar_rogation_
coronations13410703_coronations
corotations1349763_corotations
corrugations1565483corrugations
derogations1349393_derogations
irrigations1246943ir_rigations
perorations13314063p_erorations
prerogatives1853433prerogatives
probations14311083p__robations
procreations1647273procreations
procurations1647403procurations
profanations17175253profanations
prolongation1563713prolongation_
promotions1448783promo__tions
promulgations1892833promulgations
pronations12314033p__ronations
propagation1646443propagation_
proportions1548463propo_rtions
propositions16108313propositions
proration11415983pror__ation_
prorogates1347313prorogat__es
prostrations1449763prostrations
protonation13510433protonation_
provocation1847353provocation_
purgations1346743p_ur_gations
rogations101510823___rogations
subrogations1545453subrogations
abrogation13107334_abrogation_
adorations11310234ador__ations
aggregations1553844aggregations
approbations1854244approbations
arborizations2447424arborizations
arrogating121778394ar_rogati_ng
arrogators1145374ar_rogat_ors
autorotations1354554autorotations
brominations1646754brominations
colorations13911894_colorations
coronation12412074_coronation_
corotation12410974_corotation_
corporations16129484corporations
correlations1447864correlations
corrugation1445994corrugation_
derogation12410394_derogation_
elongations1244664elo_ngations
embrocations1843984embrocations
erotizations21411004erotizations
floriations1476914flor_iations
formations1538204_for_mations
homologations19102354homologations
irrigation1147804ir_rigation_
irritations1147834ir_ritations
morulations13148164_morulations
orations81515804__or__ations
ozonations1945144__ozonations
percolations1648054percolations
perforations1747874perforations
permeations1549884p_ermeations
peroration12316004p_eroration_
personations1448394personations
phonations1538314p__honations
populations15148714p_opulations
portions10514414p_or___tions
potations111615074p___otations
precognitions1853594precognitions
predations13812154p__redations
predications17411184predications
preformations2045714preformations
prelibations16127624prelibations
premonitions1646854premonitions
prenotions1248294preno__tions
preoptions1447644pr_eo_ptions
preordinations1765714preordinations
preparations1648314preparations
preportions1548264prepo_rtions
prepositions16108304prepositions
prerogative1755354prerogati_ve
prerogatived1952634prerogatived
privations15310104p__rivations
proactions1449344p__roactions
probation13412184p__robation_
proclamations1952694proclamations
procreation1547954procreation_
procuration1548294procuration_
productions1647534pro_ductions
profanation16186104profanation_
prohibitions1953834prohibitions
projections2258474pro_jections
promotion1359504promo__tion_
promulgation17123244promulgation_
pronation11415704p__ronation_
propagating1754884propagati_ng
propagators1654224propagat_ors
propitiations1756204propitiations
proportion1448994propo_rtion_
proposition1588744proposition_
prorating12314284pror__ati_ng
prorogate1247694prorogat___e
prorogated1445724prorogat__ed
proroguing1443124prorog_ui_ng
prosecutions1645614prosecutions
prostration13410794prostration_
protections15510704pro_tections
protestations1555814protestations
protonating1448594protonati_ng
protractions1646644protractions
provocatives2253374provocatives
purgation1247394p_ur_gation_
relegations1248974_relegations
relocations13311144_relocations
renovations1448424_renovations
reprobations1647774reprobations
revocations16410314_revocations
rogation91612054___rogation_
rotations91613844___rotations
segregations1445804segregations
sporulations1445684sporulations
subrogation1446004subrogation_
supererogations1862834supererogations

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 Filter1786911247900.610292936.1
2DLD Change Limit1247901287.62616363.8
3Display Results1281280.0761684.2
 (SQL Overall)1786911288.31221498.0
 
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.