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

129 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
expectorations255219(None) 
expectoration2452561expectoration_
expectations2365842expect__ations
expectorating2552062expectorati_ng
execrations2048923ex_ec__rations
exenterations2054483ex_enterations
expectation2266483expect__ation_
expectorates2352993expectorat__es
explorations2185613exp__lorations
decorations14312884__dec_orations
effectuations2151954effect_uations
excoriations2147524ex__c_oriations
execration1949834ex_ec__ration_
exenteration1955294ex_enteration_
expatiations2146134exp_at_iations
expatriations2253764exp_atriations
expectational2452494expect__ational
expectorant2252264expectora___nt
expectorants2361334expectora__nts
expectorate2253304expectorat___e
expectorated2452314expectorat__ed
expirations2069584exp___irations
exploration2066714exp__loration_
exportations2146654exp___ortations
expostulations2352304expostulations
extortions1746474ex___tor_tions
impetrations1645444impe_t_rations
pectinations1649254__pectinations
perforations1747874__perforations
perorations13314064__pe_rorations
perpetrations1746374perpe_t_rations
redecorations1645084redec_orations
restorations12410954__restorations
affectations2043435affect__ations
ameliorations1563195_ameliorations
declarations1546805__declarations
decoration13314425__dec_oration_
deflorations1646065__deflorations
delectations1547455delect__ations
desecrations1559215desec__rations
desperations1559525despe___rations
deteriorations15164695deteriorations
detonations1239375__de_tonations
deuterations1348085__deuterations
effectuation2052285effect_uation_
elaborations1444925e__laborations
electorates1347445e_lectorat__es
electrocutions1863015e_lectrocutions
elucubrations1751745e_lucubrations
enculturations1652425enculturations
eructations1347235e_ruct__ations
evaporations1744695e__vaporations
eviscerations1882705evisc_erations
exacerbations2452505ex_acerbations
exaggerations2253485ex_aggerations
exaltations1847295ex_alt__ations
exasperations2253695ex_asperations
excavations2345085ex__c_avations
excerptions2244985ex__c_erptions
excitations2049005ex__c_itations
exclamations23104105ex__clamations
excoriation2048435ex__c_oriation_
excretions1946625ex__c__retions
exculpations2344175ex__culpations
execrating2047885ex_ec__rati_ng
execrators1946025ex_ec__rat_ors
executions1946395ex_ec___utions
exenterating2054215ex_enterati_ng
exercitations2254565ex_ercitations
exertions1639765ex_e___r_tions
exhilarations2352415ex_hilarations
exhortations2244455ex___hortations
exonerations1947015ex__onerations
expatiation2046835exp_at_iation_
expatriation2154335exp_atriation_
expectative2553585expect__ati_ve
expeditions2144635expe___ditions
expiations1959665exp____iations
expiration19610715exp___iration_
explanations2144625exp__lanations
explantations2253645exp_lantations
explications2347535exp__lications
exploitations2254215exp_loitations
explorational2252555exp__lorational
exponentiations2461735exponent_iations
exportation2047445exp___ortation_
expositions2046845exp___ositions
expostulation2262615expostulation_
expropriations2553325expropriations
expurgations2274125exp__urgations
exsections1947635exsec____tions
exsertions1746745exse___r_tions
exsiccations2343265exsic__cations
extenuations1945085exte__nuations
exterminations2365125exterminations
extirpations2174285ex___tirpations
extortion1646725ex___tor_tion_
extractions2077745ex___t_ractions
extrapolations2363235extrapolations
exultations1846525ex_ult__ations
fenestrations1695405fenest_rations
impersonations1863655impersonations
impetration1545905impe_t_ration_
meliorations1466755__meliorations
operations12312955_ope___rations
overdecorations2163725overdec_orations
pectination15410335__pectination_
peculations15310285__pec_ulations
peltations12311555__pelt__ations
penetrations1448855__penetrations
percolations1648045__percolations
perforation1649005__perforation_
peroration12316005__pe_roration_
perpetration1647135perpe_t_ration_
perpetuations1754985perpe_t_uations
personations1448395__personations
perturbations17123265__perturbations
prorations12314465__p__rorations
protonations1449065__protonations
recordations1548645__rec_ordations
redecoration1546015redec_oration_
reiterations12410875__reiterations
reoperations14410065reope___rations
restoration11412095__restoration_
retortions1049145__re_tor_tions
sequestrations23182995sequest_rations
speciations1548485_spec__iations
speculations1646395_spec_ulations
structurations16122155structurations

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.1101624463.6
2DLD Change Limit950241297.25013106.8
3Display Results1291290.0931387.1
 (SQL Overall)1786911297.45323975.7
 
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.