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

120 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
subsaturation155307(None) 
subsaturations1672571subsaturations
saturation1049803___saturation
subsaturated1552843subsaturat_ed
substation1248993subs_t__ation
supersaturation1783503supersaturation
denaturation1345884_denaturation
instauration12114834_instauration
lustration1048354lu_s_t_ration
maturation1249514___maturation
obscuration1544404_obs_curation
obturation1297144_ob__turation
oversaturation1794464oversaturation
pustulation13116624pu_s_tulation
renaturation1256754_renaturation
saturations1148574___saturations
structuration15122514structuration
subaudition1452694sub_a_udition
subgeneration1652604subgeneration
subjugation2143704sub__jugation
subluxation2043824sub__luxation
subpopulation1962664subpopulation
subsidization2553984subsidization
substantiation1673154substantiation
substations1348244subs_t__ations
substitution1453324subs_titution
subsumption1752624subs__umption
subtraction1545624sub__t_raction
suppuration1545894su__ppuration
suspiration1346544su_s_piration
susurration1144794su_s_urration
abjuration1945885_ab__juration
abstraction1545885_abs_t_raction
acculturation17173345acculturation
arbitration1346475arb_it_ration
blastulation1452595__blastulation
castration12410805_cas_t_ration
denaturations1444955_denaturations
dubitation1377335dub_it__ation
enculturation1552785enculturation
frustration1444815frus_t_ration
fulguration15123335fu__lguration
fustigation1545215fu_s_tigation
gratulation1245995__gratulation
gustation1047965gu_s_t__ation
habituation1643595hab_itu_ation
infatuation1444935_infatu_ation
instaurations13114255_instaurations
lustrations1147625lu_s_t_rations
masturbation1653585_mas_turbation
maturations1348445___maturations
menstruation1455225mens_truation
mensuration1346495mens__uration
obliteration1453895_obliteration
obscurations1644025_obs_curations
obstruction15135545_obs_truction
obturations13116425_ob__turations
outstation1046165outs_t__ation
oversaturations1863965oversaturations
postulation13119135_pos_tulation
prostration13410795pros_t_ration
punctuation1543485pu_nctu_ation
pustulations14115625pu_s_tulations
renaturations1355965_renaturations
restoration11412095_res_toration
rustication1349225ru_s_tication
salutation1048905___salutation
satiation9313435___sat_iation
saturating11119205___saturating
saturator946615___saturat_or
scatteration1452925s_catteration
sensitisation13153645sensitisation
sensitization22146725sensitization
separation12510435s_epa__ration
sequestration22133135seques_t_ration
situation949425___situ_ation
structurations16122155structurations
suballocation1761625suballocation
subaquatic2351455sub_aqu_ati_c
subauditions1552585sub_a_uditions
subcurative1854415sub__curative
subduction1544685sub__du_ction
suberization2359245sub_erization
subgenerations1752515subgenerations
subinfeudation20121465subinfeudation
subirrigation1652645subirrigation
subjugations2253415sub__jugations
subjunction2253335sub__junction
sublation11311015sub____lation
sublimation1557185sub__limation
subluxations2143385sub__luxations
submunition1563115sub__munition
subordination1654175subordination
subornation1346495sub__ornation
subpopulations2062385subpopulations
subrogation1446005sub__rogation
subscription1853125subs_cription
subsection1496785subs___ection
subsidizations2653735subsidizations
substantiations1772795substantiations
substitutions1553285subs_titutions
substrata11184915subs_t_rat__a
substrate11178795subs_t_rat__e
substrates12168555subs_t_rat_es
substratum1452695subs_t_rat_um
substratums1551995subs_t_ratums
subsumptions1852615subs__umptions
subtilization2456635subtilization
subtractions1645375sub__t_ractions
summarization2655305summarization
supersaturating1882735supersaturating
suppurations1645205su__ppurations
suspirations1445855su_s_pirations
sustentation1255025su_stentation
susurrations1244335su_s_urrations
trituration1146655__trituration
unsaturate1054935_unsaturat__e
unsaturated1244925_unsaturat_ed
unsaturates1154605_unsaturat_es
usurpation1243815_u_s__urpation

Search took 10 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.390458182.1
2DLD Change Limit1247901208.81314159.8
3Display Results1201200.0761578.9
 (SQL Overall)1786911209.27919257.6
 
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.