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

119 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
propagation164644(None) 
propagations1745551propagations
preparation1549272preparation
profanation16186102profanation
propagating1754882propagating
propagative1954502propagative
propagator1554302propagat_or
prorogation1447392prorogation
population14810023p_opulation
preparations1648313preparations
proaction13410103pro_a_ction
probation13412183pro__bation
proclamation1853413proclamation
procreation1547953procreation
procuration1548293procuration
profanations17175253profanations
prolongation1563713prolongation
promulgation17123243promulgation
pronation11415703pro__nation
propagate1446123propagat__e
propagated1644633propagat_ed
propagates1556143propagat_es
propagators1654223propagators
propitiation1656913propitiation
proportion1448993prop_ortion
proposition1588743proposition
proration11415983pro__ration
prorogations1556723prorogations
prostration13410793prostration
protonation13510433protonation
provocation1847353provocation
reparation12612723_reparation
rogation91612053_ro__gation
trepanation1345483trepanation
abrogation13107334abro__gation
appropriation1653824appropriation
arrogation11107444ar_rogation
bromination1547814bromination
coaptation1448344_coaptation
cooperation15410024cooperation
copulation141111954_copulation
corporation151210654corporation
corrugation1445994corrugation
crepitation1548394crepitation
derogation12410394dero__gation
divagation15104374_divagation
elongation1145354elo_ngation
erotization20412064erotization
expropriation2453994expropriation
floatation1344684flo_atation
gradation11107714gr__adation
indagation1246154_indagation
irrigation1147804ir_rigation
operation11314004__operation
palpation1339074palp__ation
palpitation1546244palpitation
peroration12316004pero__ration
perspiration1656834perspiration
phonation1439394pho__nation
placation1339774p__lacation
planation11310124p__lanation
populations15148714p_opulations
potation101716784p_o__tation
precaution1447244preca_ution
predation12313464pr__edation
predication16412434predication
prelibation15128664prelibation
premigration1755694premigration
preoption1348084preop___tion
preparative1846354preparative
preparator1445244preparat_or
preportion1448874prep_ortion
preposition15108584preposition
privation14311174pr__ivation
proabortion1553164proabortion
proactions1449344pro_a_ctions
probations14311084pro__bations
proclamations1952694proclamations
procreations1647274procreations
procurations1647404procurations
production1547894pro_duction
prohibition1854264prohibition
projection2158764pro_jection
prolactin1347774prola_cti_n
prolongations1673354prolongations
promotion1359504pro__motion
promulgations1892834promulgations
pronations12314034pro__nations
propagable1743354propaga_ble
propaganda1651864propaga_nda
propagandas1751694propagandas
propagandist1862114propagandist
propagandize2771744propagandize
propitiations1756204propitiations
proportions1548464prop_ortions
propositions16108314propositions
propulsion1453854prop_ulsion
prorations12314464pro__rations
prorogating1556064prorogating
prosecution1546074prosecution
prostrations1449764prostrations
protection14511474pro_tection
protestation1456364protestation
prothalamion1961734prothalamion
protonations1449074protonations
protraction1547214protraction
provocations1956874provocations
pupation1269504p_up__ation
purgation1247394p__urgation
relaxation1746454_relaxation
relegation11610024_relegation
reoperation13410904reoperation
reparations13611664_reparations
reputation12411884_reputation
rogations101510824_ro__gations
rotation81615454_ro__tation
separation12510434_separation
trepanations1444574trepanations
trepidation1445494trepidation

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191198.96616598.1
3Display Results1191190.0631888.9
 (SQL Overall)1786911199.45218905.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.