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

108 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
prepublications237266(None) 
prepublication2252921prepublication_
republications2074451_republications
republication1964632_republication_
prefabrications2492433prefabrications
publications1845833___publications
reduplications1964533_reduplications
relubrications1854193_relubrications
replications16811053_rep__lications
predications17411184pre___dications
prefabrication2392824prefabrication_
prelibations16127624pre___libations
prettifications22135184prettifications
prevarications2154744pre_varications
publication1746574___publication_
reapplications2054254_reapplications
reduplication1855044_reduplication_
relubrication1754504_relubrication_
replication15712014_rep__lication_
republicanisms2271104_republicanisms
republicanizes2961344_republicanizes
republicans1752194_republica___ns
repudiations1597034_repu_di_ations
rubrications1646264_r__ubrications
triplications1795074trip__lications
applications1846775__ap_plications
cephalizations3087595_cephalizations
complications2147435comp__lications
crenulations1446495crenu_l__ations
creolizations2457885cre__olizations
crepitations1647475crep___itations
deputizations2546745_depu_tizations
duplications1746285___duplications
equalizations3149045__equalizations
explications2347535__e_xplications
implications1847025_imp__lications
lubrications1645735___lubrications
nebulizations2446675_nebu_lizations
peculations15310285p_ecu_l__ations
penalizations24511635p_e_nalizations
petrifications2148025p_etrifications
plications14310495___p__lications
populations15148715p_opu_l__ations
precipitations2085395pre_cipitations
preconvictions2353355preconvic_tions
predestinations1865005predestinations
predication16412435pre___dication_
predictions1649655pre___dic_tions
predilections1853555pre_dilec_tions
predominations19105545pre_dominations
prefabricating2461735prefabricati_ng
prelections151210465pre___lec_tions
prelibation15128665pre___libation_
premeditations1955015pre_meditations
premunitions1644985premu_ni__tions
prenominations18105765pre_nominations
preordinations1765715pre_ordinations
preparations1648315prep___arations
preponderations20112875preponderations
prepositions16108305prep_osi__tions
preproductions2153945preproduc_tions
preselections17144445pre_selec_tions
pressurizations2692715pressurizations
preterminations1954305preterminations
prettification21115715prettification_
preunification2154305preunification_
prevarication2055245pre_varication_
promulgations1892825promu_l_gations
pronunciations18122785pronunci_ations
propitiations1756205prop_iti_ations
realizations21415535_re__alizations
reallocations1553805_re_allocations
reapplication1954725_reapplication_
rectifications2148915_rectifications
rededications1746125_re_dedications
reduplicating1953505_reduplicati_ng
regulations12310715_regu_l__ations
regurgitations16133145_regurgitations
rehabilitations2053035_rehabilitations
reifications17411825_re__ifications
relictions12310025_re___lic_tions
relocations13311145_re___locations
relubricating1863095_relubricati_ng
remobilizations2855495_remobilizations
renunciations1554855_renunci_ations
repatriations15136515_repatri_ations
replicating1649095_rep__licati_ng
republican1652325_republica___n_
republicanism2161335_republicani_sm
republicanize2861485_republicani_ze
republicanized3061275_republicanized
republicanizing3181215_republicanizing
repudiation14107605_repu_di_ation_
repunctuations1852265_repunctuations
reputations13410735_repu___tations
resuscitations1673785_resuscitations
retaliations12511405_re_tali_ations
reunifications19136915_reunifications
reutilizations2348715_reutilizations
revalidations1747115_re_validations
ritualizations2357985_ritualizations
rubrication1547125_r__ubrication_
rustications1448565_r__ustications
sublimations1646085___sublimations
supplications1954915_sup_plications
trephinations1853555trep__hinations
trepidations1554935trep___idations
triplication1695385trip__lication_

Search took 5 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 Filter178691658740.0931921408.6
2DLD Change Limit658741084.07616161.4
3Display Results1081080.0801350.0
 (SQL Overall)1786911084.24942054.8
 
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.