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

198 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
effectuations215195(None) 
effectuation2052281effectuation_
affectations2043432affect_ations
effectuating2151782effectuati_ng
affectation1943843affect_ation_
effectuates1952533effectuat__es
expectations2365843expect_ations
fluctuations1752563_fluctuations
accentuations1753094accentuations
actuations1239294___actuations
affections1845894affec___tions
defecations1779004defec__ations
delectations1547454delect_ations
effectualities2262204effectualities
effectuality2382314effectuali_ty
effectualness2171934effectualness
effectuate1852584effectuat___e
effectuated2051994effectuat__ed
eructations1347234e_ruct_ations
evacuations1646304e_vac_uations
execrations2048924e_xec_rations
executions1946394e_xec_u_tions
expectation2266484expect_ation_
expectorations2552194expectorations
extenuations1945084exte_nuations
fenestrations1695404fenestrations
fetations12511384__fe_t_ations
fluctuation1653074_fluctuation_
infatuations1544434inf_atuations
infestations1546624infest_ations
officiations2053504offic_iations
perpetuations1754984perpe_tuations
punctuations1643184_punctuations
repunctuations1852264repunctuations
accentuation1653465accentuation_
acceptations1864505accept_ations
actuation11310335___actuation_
affection1745895affec___tion_
affiliations1844185aff_iliations
affirmations2053235aff_irmations
affixations2443855aff__ixations
afforestations2062245afforest_ations
arcuations1249345__arc_uations
assentations1245835assent_ations
attenuations1243805atte_nuations
attestations1244465attest_ations
brecciations1844285_brecciations
cementations1659015cement_ations
coarctations16114495coarct_ations
cunctations1576155_cunct_ations
decimations16410165__decimations
decorations14312885__decorations
defalcations1845195defalc__ations
defecation1679805defec__ation_
defections161510205defec___tions
defenestrations1993305defenestrations
deflections17187325deflec___tions
deforestations1853965deforest_ations
deifications18410655deific__ations
delectation1448555delect_ation_
dentations11413635__dent_ations
deprecations1748565deprec__ations
depreciations1846575deprec_iations
deputations1448345__deputations
desecrations1559215desec_rations
detestations1347585detest_ations
dictations1389705__dict_ations
edifications1848695edific__ations
educations1339235e_duc__ations
effecting1845585effec___ti_ng
effectives21134565effec___tives
effectivities2453855effectivities
effectors1755035effec___t_ors
effectual1752765effectua____l
effectually2252655effectua__lly
efficacious2151615effic__acious
effluxions2351735eff__lu_xions
effusions1544375eff___u_sions
ejaculations2195215e_jaculations
ejections18249965e_jec___tions
elections112414975e_lec___tions
electuaries1354235e_lectuari_es
elevations1338635e_le__vations
elicitations1446805e_licitations
elocutions1245965e_loc_u_tions
elucidations1544515e_lucidations
emaciations1548165e_mac_iations
emancipations1953745emancipations
emasculations1754605emasculations
emendations1446055e_me_ndations
enculturations1652425enculturations
enervations1478575e_ne_rvations
enucleations1444105e_nucleations
enunciations1445095enunc_iations
equations1839495___e_quations
equitations2047445e_quit_ations
erections112515215e_rec___tions
eructation1248335e_ruct_ation_
escalations1347665e__scalations
etherizations2557235etherizations
evacuation1547165e_vac_uation_
evaluations1457325e__valuations
evections142510695e_vec___tions
eventuating1543255e_ventuati_ng
eviscerations1882705eviscerations
evocations15259875e_voc__ations
exacerbations2452505exacerbations
exaltations1847295e_xalt_ations
excavations2345085e__xcavations
excitations2049005e__xcitations
execration1949835e_xec_ration_
execution1846305e_xec_u_tion_
exenterations2054485e_xenterations
exercitations2254565exercitations
exfoliations2244785exf_oliations
exhortations2244455exhort_ations
expatiations2146135e_xpatiations
expectational2452495expect_ational
expectoration2452565expectoration_
exportations2146655export_ations
expostulations2352305expostulations
exsections1947635exsec___tions
exsiccations2343265exsic_cations
extenuation1845185exte_nuation_
exultations1846525e_xult_ations
fasciations1646265_fasc_iations
fascinations1746375_fascinations
fecundations1842965__fecundations
federations1548885__federations
felicitations1874585felicitations
fellations1338065__fe_llations
fenestration1596075fenestration_
fermentations1856275ferment_ations
fetation11613145__fe_t_ation_
filtrations1445625__filtrations
flections14239215_flec___tions
flirtations14104265_flirt_ations
floatations1444105_float_ations
flocculations2052475_flocculations
flotations1366875__flot_ations
fluctuating1752605_fluctuati_ng
fluctuational1861235_fluctuational
fomentations1746795foment_ations
forestations1546325forest_ations
frustrations1544535_frustrations
furcations1547535_furc__ations
gestations1139775__gest_ations
habituations1743115_habituations
hebetations1656465hebe_t_ations
impetrations1645445impe_trations
indentations1347885indent_ations
infatuation1444935inf_atuation_
infections15510235infec___tions
infestation1447045infest_ation_
infiltrations1653905infiltrations
jactations1936895__jact_ations
lactations1239425__lact_ations
lamentations1495985lament_ations
mentations12312585__ment_ations
molestations1475475molest_ations
nictations1278315__nict_ations
officiation1943835offic_iation_
orientations1246915orient_ations
ostentations1246125ostent_ations
pectinations1649255__pectinations
peculations15310285__peculations
peltations12311555__pelt_ations
penetrations1448855pene_trations
perfections1848145perfec___tions
perpetrations1746375perpe_trations
perpetuation1655345perpe_tuation_
persecutions1654795persec_u_tions
potentiations1555185potentiations
precautions1546555_precau_tions
punctations1585355_punct_ations
punctuation1543485_punctuation_
recautions1247815__recau_tions
recitations13314205__recitations
recreations13412255__recreations
redecorations1645085redecorations
refections151811645refec___tions
reflections16178555reflec___tions
reforestations1754465reforest_ations
refutations1448675ref_ut_ations
reifications17411825reific__ations
reinfestations1793885reinfest_ations
reluctations1446755reluct_ations
repunctuation1752525repunctuation_
reputations13410735__reputations
restations10315845__rest_ations
segmentations1655595segment_ations
sequestrations23182995sequestrations
situations1038435___situations
speciations1548485_spec_iations
speculations1646395_speculations
structurations16122155structurations
suffocations2053095suffoc__ations
vegetations1547325vege_t_ations

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.376475242.0
2DLD Change Limit1247901988.17015274.2
3Display Results1981980.1261571.4
 (SQL Overall)1786911988.67220605.5
 
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.