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

113 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
prepublication225292(None) 
prepublications2372661prepublications
republication1964631_republication
republications2074452_republications
prefabrication2392823prefabrication
publication1746573___publication
reduplication1855043_reduplication
relubrication1754503_relubrication
replication15712013_rep__lication
predication16412434pre___dication
prefabrications2492434prefabrications
prelibation15128664pre___libation
prettification21115714prettification
preunification2154304preunification
prevarication2055244pre_varication
publications1845834___publications
reapplication1954724_reapplication
reduplications1964534_reduplications
relubrications1854194_relubrications
replications16811054_rep__lications
republican1652324_republica___n
republicanism2161334_republicanism
republicanize2861484_republicanize
repudiation14107604_repu_di_ation
rubrication1547124_r__ubrication
triplication1695384trip__lication
application1747475__ap_plication
cephalization2988185_cephalization
complication2048205comp__lication
crenulation1347575crenu_l__ation
creolization2348815cre__olization
crepitation1548395crep___itation
deputization2447225_depu_tization
duplication1647295___duplication
equalization3049815__equalization
explication2248455__e_xplication
implication1747775_imp__lication
lubrication1546345___lubrication
nebulization2347195_nebu_lization
peculation14311995p_ecu_l__ation
penalization23512665p_e_nalization
petrification2048815p_etrification
plication13311685___p__lication
population14810025p_opu_l__ation
precipitation1966225pre_cipitation
preconviction2253705preconvic_tion
predestination1765485predestination
predications17411185pre___dications
prediction15410305pre___dic_tion
predilection1754105pre_dilec_tion
predomination1896535pre_domination
preelection15136485pre__elec_tion
prefabricating2461735prefabricating
prelection141511295pre___lec_tion
prelibations16127625pre___libations
premeditation1855705pre_meditation
premodification2582975premodification
premunition1545575premu_ni__tion
prenomination17126755pre_nomination
prenotification2253605prenotification
preordination1656155pre_ordination
preparation1549275prep___aration
preponderation19103225preponderation
preposition15108585prep_osi__tion
preproduction2054395preproduc_tion
preselection16154885pre_selec_tion
pressurization2593125pressurization
pretermination1854775pretermination
prettifications22135185prettifications
prevarications2154745pre_varications
promulgation17123245promu_l_gation
pronunciation17113225pronunci_ation
propitiation1656915prop_iti_ation
realization20417225_re__alization
reallocation1454495_re_allocation
reapplications2054255_reapplications
rectification2049515_rectification
rededication1646505_re_dedication
reduplicating1953505_reduplicating
reduplicative2172835_reduplicative
regulation11312055_regu_l__ation
regurgitation15143405_regurgitation
rehabilitation1953275_rehabilitation
reification16412905_re__ification
reliction11310695_re___lic_tion
relocation12312115_re___location
relubricating1863095_relubricating
remobilization2755695_remobilization
renunciation1455315_renunci_ation
repatriation14126975_repatri_ation
replicating1649095_rep__licating
replicative1846085_rep__licative
republicanisms2271105_republicanisms
republicanized3061275_republicanized
republicanizes2961345_republicanizes
republicanizing3181215_republicanizing
republicans1752195_republica__ns
repudiations1597035_repu_di_ations
repunctuation1752525_repunctuation
reputation12411885_repu___tation
resuscitation1554295_resuscitation
retaliation11612325_re_tali_ation
reunification18147455_reunification
reutilization2249195_reutilization
revalidation1657945_re_validation
ritualization2258535_ritualization
rubrications1646265_r__ubrications
rustication1349225_r__ustication
sublimation1557185___sublimation
supplication1855395_sup_plication
trephination1754035trep__hination
trepidation1445495trep___idation
triplications1795075trip__lications

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.360496363.9
2DLD Change Limit950241136.76614044.3
3Display Results1131130.0761486.8
 (SQL Overall)1786911137.20224811.3
 
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.