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

144 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
toccate113877(None) 
toccata1144941toccata
baccate131011262baccate
locate83919842lo_cate
saccate111311762saccate
soccage1236282soccage
stoccata1243562stoccata
thecate123210022thecate
toccatas1243742toccatas
togate74515682to_gate
toluate7159342toluate
tomcat101013452tomcat_
tomcats11127772tomcats
acuate8315633_acuate
arcuate9311963arcuate
baccae12119703bacca_e
baccated15148373baccated
bobcat12411253bobcat_
bobcats1335993bobcats
bocce114313113bocc__e
boccie123311453bocc_ie
borate85026153bo_rate
boscage1276533boscage
cate66254603___cate
coccal9310223cocca_l
cockade1638133cockade
cocotte1138603cocotte
cocreate122611813cocreate
cognate10312203cognate
collate92919683collate
colocate12313443colocate
comate104124843co_mate
concave1439373concave
connate9315753connate
cordate10315223cordate
costate94019273costate
crate76537403__crate
dictate10311663dictate
dockage1535723dockage
donate73619503do_nate
educate10310213educate
falcate12311613falcate
folate93320393fo_late
foliate10513533foliate
formate123115093formate
fossate10388603fossate
foveate1338363foveate
furcate12310453furcate
hoecake1645203hoecake
hotcake1644543hotcake
iodate7313503io_date
lactate9312693lactate
lobate82915243lo_bate
locale83915653lo_cale
located103114183lo_cated
locater93113603lo_cater
locates93218813lo_cates
lockage1436613lockage
loculate101011403loculate
loricate10310663loricate
moschate1546583moschate
nictate9310223nictate
notate63217863no_tate
oblate82214743_oblate
ocicat101412813_ocicat_
ocicats11137413_ocicats
ocreate93711743_ocreate
octane81411633_octane
octave11157343_octave
oleate6318883_oleate
oocyte1135753_oocyte
opiate8513463_opiate
orate55133303_o_rate
ornate6315143_ornate
outate62923403_outate
ovate84214393_o_vate
pectate112214693pectate
piccata1345703piccata
picrate112014143picrate
placate11312433placate
plicate11314513plicate
recrate92621663recrate
roseate7613453roseate
rotate63320343ro_tate
saccade12107033saccade
socage91012123so_cage
soccages1336383soccages
solate64526073so_late
solvate102710213solvate
sonicate10310933sonicate
sorbate9311733sorbate
spicate113214193spicate
staccati1244673staccati
staccato1244063staccato
stoccado1342953stoccado
stoccatas1342523stoccatas
stockade1544523stockade
stockage1544903stockage
stomate9313123sto_mate
sulcate9314423sulcate
tannate71813523tannate
tate44748603t___ate
teacake1335453teacake
tectite9310583tectite
ternate7415483ternate
testate73916233testate
thecae11299653theca_e
tipcat10312653tipcat_
tipcats1137103tipcats
titrate72215573titrate
toecap1037323toeca_p
toecaps1135553toecaps
toeplate1047613toeplate
togae67020113to_ga_e
togated94410663to_gated
tolane64316583to_lane
tolerate8312323tolerate
tollage82610163tollage
tollgate946253tollgate
toluates8138903toluates
tomato8313453to_mato
tomcatted1442063tomcatted
tonette7310373tonette
tonnage8168053tonnage
topcoat1179313topcoat_
topcoats1245193topcoats
torquate1745003torquate
torsade837593torsade
torte55431703to__rte
tote46643673to___te
toucan838193touca_n
toucans937583toucans
touche114916173touc_he
towage1039833to_wage
towpath1544043towpath
tractate10411003tractate
truncate1046283truncate
tubate82813173t_ubate
tunicate103310043tunicate
uncrate9415953uncrate
vacate11314553_vacate
volvate13317993volvate
zincate1838533zincate
zonate154114923zo_nate

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271446.84319586.0
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.31224438.0
 
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.