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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
saturated103899(None) 
maturated1249161maturated
saturate8312811saturate_
saturater947901saturater
saturates9811601saturates
aurated83817792_a_urated
maturate10312612maturate_
maturates11311762maturates
obturated1245952obturated
satiated9311602sat_iated
saturaters1045562saturaters
saturator946612saturator
situated938032situ_ated
unsaturated1244922unsaturated
acerated113113983_acerated
actuated1138743actu_ated
adulated1039753_adulated
aerated85322373_a_erated
asperated1239313asperated
aspirated1247703aspirated
asteriated1177993asteriated
attracted1246073_attracted
attrited947373_attrited
aurate64426473_a_urate_
canulated12310673canulated
castrated1239513castrated
catenated1238913catenated
caudated1238063ca_udated
citrated112712253cit_rated
curated104717583__curated
depurated1338183depurated
extubated1944133extubated
fabulated1546323fabulated
gratulated1255733gratulated
indurated1139013indurated
intubated1246453intubated
iterated91213823_iterated
jaculated19289053jaculated
lacerated122210673lacerated
lateraled1047453lateraled
laureated1096153la_ureated
macerated142010523macerated
maculated142411503maculated
masturbated1652803masturbated
matured10310033matur__ed
micturated1584993micturated
narrated9310323na_rrated
natured838963natur__ed
nitrated92213153nit_rated
obturate1077773obturate_
obturates1157003obturates
outrated92219313out_rated
patinated123911413patinated
patriated1238533patriated
sacculated1546623sacculated
salivated1337473salivated
saluted84511713salu__ted
sanitated1068993sanitated
saponated1245733saponated
satiate7315403sat_iate_
satiates8314633sat_iates
satirised1046553satirised
satirized1957893satirized
saturable1146633saturable
saturant8410643satura_nt
saturants946383saturants
saturating11119203saturating
saturation1049803saturation
saturators1046093saturators
saturniid1051983saturniid
saunaed836703sa_una_ed
sauted74119603sa_u__ted
separated1237713separated
serrated92513433s_errated
simulated1238283simulated
sinuated938413sinu_ated
situate7410783situ_ate_
situates8310373situ_ates
spatulate11107173spatulate_
spurted103111973s_pur_ted
stagnated1145143stagnated
started84217323s_tar_ted
stated75427833s_t__ated
strafed114413333s_t_rafed
straked125415343s_t_raked
strawed114813613s_t_rawed
strayed114513283s_t_rayed
striated93414153s_triated
strunted957243s_trunted
strutted946343s_trutted
stunted83010403s_tu_nted
sturdied10215963s_turdied
subsaturated1552843subsaturated
sulfurated1444733sulfurated
suppurated1544093suppurated
susurrated1143113susurrated
sutured8310373sutur__ed
tabulated1237303tabulated
tartrated1096643tartrated
titrated92611683tit_rated
triturated1145073triturated
unsaturate1054933unsaturate_
unsaturates1154603unsaturates
valuated12239203valu_ated

Search took 8 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411047.48619855.9
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.95222471.2
 
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.