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

109 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
syrettes113696(None) 
syrette1037181syrette_
burettes1048952burettes
curettes1039312curettes
strettas846422strettas
strette7310762strette_
strettos847112strettos
sureties8316582sureties
aigrettes1046393aigrettes
aretes64425353_are_tes
ariettes8411353ariettes
barbettes1348163barbettes
barrettes1149063barrettes
berettas1046733berettas
birettas1046513birettas
burette939853burette_
casettes1039653casettes
corvettes1447433corvettes
creates95225203_creates
curette939783curette_
curetted1137173curetted
cuvettes1335323cuvettes
dinettes9310193dinettes
fouettes1137883fouettes
fretted113411853_fretted
fretter103412753_fretter
fretters113410303_fretters
fumettes1345773fumettes
fyttes1236933fy__ttes
galettes93111153galettes
garottes978283garottes
gazettes18296863gazettes
genettes938303genettes
gyrates113610263gyr_ates
gyrenes11267523gyre_nes
layettes1136263layettes
lunettes836753lunettes
mofettes1386083mofettes
musettes1037433musettes
myrtles1235733myr_tles
navettes1136613navettes
octettes1045533octettes
palettes103112833palettes
parkettes15137593parkettes
pipettes1237563pipettes
pretties10615133_pretties
proettes10312763proettes
pyrenes123511223pyre_nes
pyrexes19305843pyre_xes
pyrites12812203pyr_ites
rentes65431193__rentes
reties65436193__reties
retted74826313__retted
rosettes8310343rosettes
rottes64524833__rottes
safeties1139163safeties
sarees65329943sare__es
screes85023973scre__es
secretes10410473secre_tes
seethes103613743s_eethes
septettes1144923septettes
serenes73222903sere_nes
seriates82620673seriates
serrates82617023serrates
serviettes1342903serviettes
settee63721023s__ettee
settees73513633s__ettees
setter64023723s__etter
setters73822063s__etters
settles73916003s__ettles
setts55124323s__ett_s
sextettes1643923sextettes
sirees64624583sire__es
sirventes1244903sirventes
sorbates10311103sorbates
sorites73825243sor_ites
sorties74126403sor_ties
soubrettes1243963soubrettes
sprattles1174883sprattles
sprees85620643spre__es
sprites94220333spr_ites
spritzes1946943spritzes
stetted82610403s_tetted
streets73312613street_s
stresses81112493stresses
stretches1438293stretches
stretta737293strett_a
stretti747913strett_i
stretto737733strett_o
striates83417083striates
strutted946343strutted
strutter846503strutter
strutters955693strutters
styrenes11116623styre_nes
superettes1249743superettes
sweeties11159723sweeties
sycees11409653syce__es
syenites1138943syenites
sylvites14225843sylvites
syrens94911993syre__ns
syringes122810213syringes
syrinxes18294423syrinxes
tonettes839203tonettes
umbrettes1344143umbrettes
usherettes1352413usherettes
vedettes1265943vedettes
videttes1266333videttes
yentes95517603_y_entes
yetts86715133_y_ett_s

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.420425454.8
2DLD Change Limit1461621096.48622535.0
3Display Results1091090.0303633.3
 (SQL Overall)1786911096.93625762.8
 
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.