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

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

73 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
unsaturates115460(None) 
unsaturate1054931unsaturate_
unsaturated1244921unsaturated
saturates9811602__saturates
infatuates1344493infatu_ates
maturates11311763__maturates
saturate8312813__saturate_
saturated1038993__saturated
saturater947903__saturater
saturaters1045563__saturaters
subsaturated1552843subsaturated
unstates81314993uns_t__ates
castrates11312674cas_t_rates
clathrates1545274_clathrates
cyanurates1543564_cyanurates
enculturates1453584enculturates
gratulates1157134_gratulates
inaugurates1253484inaugurates
indurates10310694in__durates
infatuate1244774infatu_ate_
infatuated1443924infatu_ated
insatiate948064insat_iate_
insinuates1045464insinu_ates
instates81615834ins_t__ates
instigates1148424ins_tigates
insulates9311844ins__ulates
intubates1147124in__tubates
lustrates939464lus_t_rates
masturbates1553424mas_turbates
maturate10312614__maturate_
maturated1249164__maturated
menstruates1343984mens_truates
micturates1456094_micturates
monounsaturates1781164monounsaturates
narrates8312764_n_a_rrates
naturals847904_n_atura_ls
natures7311964_n_atur__es
nitrates82516224_n_it_rates
obturates1157004__obturates
ossatures943424ossatur__es
oversaturates1654214oversaturates
pastorates12410144pas_torates
pasturages1344924pas_turages
postulates1268964pos_tulates
punctuates1443454pun_ctu_ates
pustulates1276214pus_tulates
resituates1047754resitu_ates
satiates8314634__sat_iates
saturants946384__saturants
saturator946614__saturator
saturators1046094__saturators
situates8310374__situ_ates
substrates12168554subs_t_rates
supersaturates16104424supersaturates
triturates1046764_triturates
unaspirated1444244unaspirated
uncastrated1445384uncastrated
uncrates10314564un___crates
underrates11410564un_derrates
undersaturated1662494undersaturated
undulates1048924un__dulates
unfortunates1551804unfortunates
ungulates1048354un__gulates
unmatured1245694unmatur__ed
unnatural943614unnatura__l
unnaturally1453344unnaturally
unnaturalness1362264unnaturalness
unseparated1443514unseparated
unstate71916214uns_t__ate_
unstated91615814uns_t__ated
unstraps1045984uns_t_ra_ps
upstates10189644ups_t__ates
ustulate868324u_s_tulate_

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 Filter1786911488190.1531167915.0
2DLD Change Limit148819738.70317099.7
3Display Results73730.0332212.1
 (SQL Overall)178691738.88920102.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.