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 “oversaturations” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
oversaturations186394(None) 
oversaturation1794441oversaturation_
oversaturating1864032oversaturati_ng
oversaturates1654203oversaturat__es
overvaluations2064593overvalu_ations
denaturations1444954_de_naturations
overassertions17133284overasser_tions
overattentions17103174over_attentions
overcautions1755234overca_u__tions
overdecorations2163704overdecorations
overeducations2054964over_educations
overestimations20124584overestimations
overevaluations2194054overevalu_ations
overextractions27163234overext_ractions
overmaturities1962384overmaturiti_es
overnutritions1763104overnut_ritions
overpopulations22154124overpopulations
overregulations1963834overregulations
oversaturate1554424oversaturat___e
oversaturated1754094oversaturat__ed
oversecretions1963704overs_ecretions
overstrains1447154overs_t_ra_i_ns
overtaxations2353494over__taxations
overvaluation1965084overvalu_ation_
renaturations1355954_re_naturations
saturations1148574____saturations
subsaturations1672574_subsaturations
supersaturation1783504supersaturation_
congratulations1882785congr_atulations
denaturation1345885_de_naturation_
gratulations1345175__gr_atulations
instaurations13114255__instaurations
maturations1348435____maturations
menstruations1585055_mens_truations
mensurations1445715_mens__urations
mercurations1646535_mer__curations
obscurations1644015o__bs_curations
obturations13116425o____bturations
overactions1648185over_a___ctions
overassertion16113505overasser_tion_
overattention16113235over_attention_
overcaution1655145overca_u__tion_
overcautious1752735overca_u__tious
overdecoration2063925overdecoration_
overeducation1955355over_education_
overelaboration2072235overelaboration_
overestimation19125135overestimation_
overevaluation2074515overevalu_ation_
overexertions23115155over_exer_tions
overextraction26153525overext_raction_
overinflations20154395over_inflations
overmedications2363645overmedications
overnutrition1663375overnut_rition_
overpopulation21144575overpopulation_
overregulation1864325overregulation_
oversecretion1863925overs_ecretion_
overspeculation2263315overspeculation_
overstating15410735overs_t__ati_ng
overstimulation2073525overstimulation_
overstrain1347045overs_t_ra_i_n_
overtaxation2253675over__taxation_
overtrains13109485over__t_ra_i_ns
perpetrations1746355_perpet_rations
perpetuations1754975_perpetu_ations
perseverations1953225_perseverations
perspirations1786165_pers_pirations
perturbations17123255_per__turbations
renaturation1256755_re_naturation_
restorations12410935_re_s_torations
saturation1049805____saturation_
structurations16122155_structurations
subsaturation1553075_subsaturation_
supersaturating1882735supersaturati_ng
triturations1245685__tr_iturations
verbalizations2849165_verbalizations
verbigerations2052455_verbigerations
vermiculations2153885_vermiculations
vernalizations2649245_vernalizations
versifications22166905_versifications
vesiculations1845315_ve_siculations

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 Limit65874804.64314187.8
3Display Results80800.0601333.3
 (SQL Overall)178691804.79637258.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.