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

(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
unsaturated124492(None) 
unsaturate1054931unsaturate_
unsaturates1154591unsaturates
saturated1038992__saturated
subsaturated1552822subsaturated
infatuated1443923infatu_ated
maturated1249163__maturated
saturate8312813__saturate_
saturater947903__saturater
saturates9811593__saturates
unaspirated1444243unaspirated
uncastrated1445383uncastrated
undersaturated1662493undersaturated
unmatured1245693unmatur__ed
unseparated1443513unseparated
unstated91615813uns_t__ated
aurated83817794___a_urated
castrated1239514cas_t_rated
enculturated1553374enculturated
gratulated1255734_gratulated
inaugurated1353244inaugurated
indurated1139014in__durated
infatuate1244774infatu_ate_
infatuates1344494infatu_ates
insatiate948064insat_iate_
insinuated1144814insinu_ated
instated91613334ins_t__ated
instigated1247684ins_tigated
instructed1345634ins_tructed
insulated10310714ins__ulated
intubated1246454in__tubated
lustrated1037964lus_t_rated
masturbated1652804mas_turbated
maturate10312614__maturate_
maturates11311754__maturates
menstruated1473744mens_truated
micturated1584994_micturated
monounsaturated1881254monounsaturated
narrated9310324_n_a_rrated
natured838964_n_atur__ed
nitrated92213154_n_it_rated
obturated1245954__obturated
oversaturated1754094oversaturated
polyunsaturated218924polyunsaturated
postulated1377654pos_tulated
punctuated1543374pun_ctu_ated
pustulated1375544pus_tulated
resituated1147324resitu_ated
satiated9311604__sat_iated
saturaters1045554__saturaters
saturator946614__saturator
situated938024__situ_ated
supersaturated17113584supersaturated
triturated1145074_triturated
unabated11310134un_a__bated
unaborted1245734un_abor_ted
unabraded1344894un_a_braded
unalerted1047964un_aler_ted
unarrayed1344184un_a_rrayed
unassuaged1242404unassu_aged
unassured1084354unassur__ed
unattested1143374un_attested
unaudited1145854un_a_udited
unautomated1453304unautomated
unaverted1336564un_aver_ted
uncalculated1753524uncalculated
uncalibrated1752934uncalibrated
uncarted11312054unca__r_ted
uncatered1237404uncater__ed
uncrated11416314un___crated
undaunted1145454unda_u_nted
undecorated1545724undecorated
underrated12310844un_derrated
undulated11310084un__dulated
uneducated1444514un_educated
unevaluated1553074unevalu_ated
unexpurgated2361004unexpurgated
unhatted1238184unhat___ted
uninsulated1244304uninsulated
unintegrated1453304unintegrated
unliberated1444254unliberated
unmatted1138294unmat___ted
unmitigated1553724unmitigated
unmotivated1753514unmotivated
unnatural943614unnatura__l
unnaturally1453344unnaturally
unparted11310824unpa__r_ted
unrated82621554un____rated
unregulated1344404unregulated
unsalaried1144034unsalar_ied
unsalted9510924unsa___lted
unsated83419934uns____ated
unsatisfied1581654unsatisfied
unseated91317684uns___eated
unsecured1244904unsecur__ed
unshirted13105954uns_hir_ted
unsorted9312514uns__or_ted
unsourced1244834uns_our_ced
unsoured9310064uns_our__ed
unsprayed1554364uns__prayed
unsquared1944074uns_qu_ared
unstarred1036364uns_tar_red
unstate71916214uns_t__ate_
unstates81314994uns_t__ates
unstayed12168394uns_t__ayed
unstinted1038554uns_t_inted
unstrained1146374uns_t_rained
unstrapped1573564uns_t_rapped
unstriped1246304uns_t_riped
unstudied1194284uns_tu_died
unstuffed1642684uns_tu_ffed
unsuited9310794uns__u_ited
untraced112413244un__t_raced
untreated10312904un__treated
untufted1236084un__tu_fted
unturned9228564un__tur_ned
unwarranted1552224unwa_rranted
unwatered1345684unwater__ed
upstarted1244214ups_tar_ted
ustulate868324u_s_tulate_

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 Filter1786911488190.1531167915.0
2DLD Change Limit1488191209.26616060.8
3Display Results1201200.0462608.7
 (SQL Overall)1786911209.46518879.1
 
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.