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

106 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
structuration1512251(None) 
structurations16122151structurations
structuralism1762663structuralism
structuralist1562793structuralist
structuralize2472273structuralize
trituration1146653_tr_ituration
acculturation17173344acculturation
enculturation1552784enculturation
eructation1248334_eruct__ation
fluctuation1653074_fluctu_ation
frustration1444814_frust_ration
mercuration1547494mer_c_uration
procuration1548294_proc_uration
saturation1049804s___aturation
strangulation1464044strangulation
stridulation1354774str_idulation
structural1254394structura___l
structuralisms1872224structuralisms
structuralists1672254structuralists
structuralized2691814structuralized
structuralizes2571924structuralizes
structuralizing2781634structuralizing
structurally1763084structura_lly
structuring1453174structur__ing
subsaturation1553074subsaturation
suppuration1545894s__uppuration
triturations1245684_tr_iturations
acculturations18182905acculturations
actuation11310335___actu_ation
adulteration1353665_adulteration
arbitration1346475_arbit_ration
arcuation11410585_ar_c_u_ation
articulation1447975artic_ulation
circulation1549395cir_c_ulation
denaturation1345885_denaturation
deuteration1249105_deu_teration
effectuation2052285effectu_ation
elucubration1652065_elucubration
enculturations1652425enculturations
eructations1347235_eruct__ations
expectoration2452565expectoration
fluctuations1752565_fluctu_ations
frustrations1544535_frust_rations
fulguration15123335__fulguration
gratulation1245995_gr_atulation
illustration1253515illust_ration
inauguration1353705inau_guration
lucubration1553005__lucubration
lustration1048355__lust_ration
matriculation17125385matric_ulation
maturation1249515___maturation
mercurations1646565mer_c_urations
micturition15133355__micturition
obscuration1544405_obsc_uration
obturation1297145___obturation
oversaturation1794465oversaturation
parturition1354175par__turition
perpetration1647135perpet_ration
perpetuation1655345perpetu_ation
perturbation16123545per__turbation
procurations1647405_proc_urations
prostration13410795_prost_ration
punctuation1543485_punctu_ation
pustulation13116625__pustulation
reiteration11412165__reiteration
reluctation1347965reluct__ation
renaturation1256755_renaturation
repunctuation1752525repunctu_ation
restoration11412095__restoration
rustication1349225__rustication
sacculation1547845s__acculation
salutation1048905salu_t__ation
saturations1148575s___aturations
scatteration1452925s_catteration
sequestration22133135sequestration
serration9414065ser____ration
situation949425s___itu_ation
speculation1547545s_pec_ulation
spiculation1547035s_pic_ulation
sternutation1253965st_ernutation
stimulation1377225st__imulation
stipulation1356335st__ipulation
strangulations1563655strangulations
striation9313485str____iation
striction1148985stric____tion
stridulations1454405str_idulations
strobilation1454055str_obilation
structure1145245structur____e
structured1343995structur___ed
structureless1561685structureless
structures1245455structur___es
subjugation2143705s__ubjugation
subluxation2043825s__ubluxation
subsaturations1672575subsaturations
subtraction1545625s__ubt_raction
supersaturation1783505supersaturation
suppurations1645205s__uppurations
suspiration1346545s__uspiration
susurration1144795s__usurration
titration9310545_t__it_ration
transudation1355325_transudation
tribulation1346495_tr_ibulation
trifurcation1753275_tr_ifurcation
triturating1245435_tr_iturating
triturator1054125_tr_iturat_or
truncation1245455_tru__ncation

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.406440125.6
2DLD Change Limit1247901068.29615042.2
3Display Results1061060.0761394.7
 (SQL Overall)1786911068.77820356.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.