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

153 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
guttated1026687(None) 
guttate8328901guttate_
gestated102910572gestated
guttae73210582gutta_e_
gutted84716362gu_t_ted
guttered10259162guttered
guttled9378992gutt_led
mutated102712252mu_tated
nutated83113422nu_tated
outdated1012513192outdated
outrated92219312outrated
outstated10169812outstated
acetated112010683acetated
actuated1138743actuated
agitated1038413agitated
aurated83817793au_rated
automated1248813automated
butted94722063bu_t_ted
buttered112712623buttered
buttoned1137503buttoned
butylated1544183butylated
citrated112712253citrated
cultrated1248223cultrated
cuneated11310103cuneated
curated104717583cu_rated
curtate9312643curtate_
cuspated1335913cuspated
cuttage10318343cuttage_
cuttages11297223cuttages
cuttled10319933cutt_led
cutwater1344833cutwater
dentated10411703dentated
dictated1239203dictated
duetted937023duet_ted
eructated1245643eructated
estated83715573_estated
furcated1437593furcated
galeated104111583galeated
gated75329773g___ated
gelated93615643g_elated
gemmated14336293gemmated
gestate83614073gestate_
gestates93213733gestates
gettered10258613gettered
gitted84015053g_it_ted
gloated93511533g_loated
globated1265753globated
glutted937243glut_ted
gradated1157433gradated
grated84523923g__rated
gritted94110903grit_ted
guested9157713gu_ested
guffawed1941623guffawed
gusseted1043553gusseted
gusted84316723gu__sted
gutta64613383gutta___
guttation1046173guttation
gutter73817713gu_t_ter
guttier83911103gutt_ier
guttle74111973gutt_le_
guttler8369163gutt_ler
guttles83011933gutt_les
gyrated12428413g_yrated
hutted104616333hu_t_ted
imitated1138263imitated
instated91613343instated
jutted144315023ju_t_ted
juttied15417863jutt_ied
lactated1138873lactated
lunated8310823lu_nated
lustrated1037963lustrated
luxated1535713lu_xated
muriated1139793muriated
mutate83017483mu_tate_
mutates92215793mu_tates
mutilated1239453mutilated
muttered112610793muttered
nictated1137793nictated
nitrated92213153nitrated
notated82713663_notated
nutate63017373nu_tate_
nutates73214973nu_tates
nutted74316973nu_t_ted
outacted1139383outacted
outate62923403ou_tate_
outbaked1538393outbaked
outdared102711513outdared
outdate83016423outdate_
outdates93114743outdates
outeaten8310423outeaten
outfaced14219463outfaced
outfasted13147173outfasted
outgazed19197733outgazed
outlasted10128353outlasted
outlawed1238033outlawed
outpaced13269793outpaced
outraced112414203outraced
outraged102313103outraged
outrate72323183outrate_
outrates82421373outrates
outraved122511923outraved
outskated14176833outskated
outstared10188423outstared
outstarted1155073outstarted
outstate81411993outstate_
outstates91710753outstates
outstayed13185933outstayed
outtake11310793outtake_
outtakes12310033outtakes
outtalked1445513outtalked
outtasked1445373outtasked
outtraded1176983outtraded
outvoted1237273outvoted
outwaited13137293outwaited
outwasted13137683outwasted
pulsated1136853pulsated
punctated1445053punctated
pupated12319353pu_pated
putted94220253pu_t_ted
puttered112611143puttered
puttied103811163putt_ied
quitted17339893quit_ted
restated93120183restated
rotated82715293_rotated
ruinated939523ruinated
rutted74518403ru_t_ted
satiated9311603satiated
situated938033situated
stated75427833__stated
sublated11311503sublated
sulcated11310373sulcated
sulfated1238833sulfated
summated13298833summated
surtaxed1644133surtaxed
tatted74920533__tatted
teated74924023__teated
titrated92611683titrated
tutted75117443tu_t_ted
unbated103317733_unbated
undated93118463_undated
ungated92717213_ungated
unmated103317023_unmated
unrated82621553_unrated
unsated83419933_unsated
unstated91615813unstated
untamed102913223_untamed
untasted92011573_untasted
untaxed152710583_untaxed
updated11369423_updated
uprated103213323_uprated
uttered82712433_uttered
vitiated12289223vitiated
vittate10409733vittate_

Search took 7 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621536.45622639.7
3Display Results1531530.0602550.0
 (SQL Overall)1786911536.95225703.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.