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

161 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
rosettes831034(None) 
rosette7310371rosette_
casettes1039652casettes
fossettes1245082fossettes
fouettes1137882fouettes
frisettes1295352frisettes
grisettes1094712grisettes
mofettes1386082mofettes
musettes1037432musettes
noisettes946532noisettes
proettes10312762pro_ettes
resetter81511832resetter
resetters9129462resetters
resettles936562resettles
roomettes1146542roomettes
roquettes1855062roquettes
roseate7613452roseate_
roselles8310712roselles
roseries8317312roseries
rosets65819952rose_t_s
rottes64524832ro__ttes
roulettes946522roulettes
tonettes839202tonettes
anisettes946673anisettes
ariettes8411353ariettes
besetter10137983besetter
besetters11136643besetters
boletes9316063bole_tes
briolettes1243853briolettes
brochettes1744703brochettes
brunettes1144583brunettes
burettes1048953burettes
caseates10313713caseates
casette9310393casette_
cassettes1146703cassettes
cocottes1238303cocottes
coesites101313093coesites
coquettes2065983coquettes
corvettes1447433corvettes
cosets85824403cose_t_s
croquettes2143543croquettes
crossties1139013crossties
curettes1039313curettes
cuvettes1335323cuvettes
dinettes9310193dinettes
diskettes1446573diskettes
fossette1145263fossette_
fouette1038213fouette_
frisette1195483frisette_
frizettes2193493frizettes
fumettes1345773fumettes
galettes93111163galettes
gazettes18296863gazettes
genettes938303genettes
grisette994653grisette_
insetted9249023insetted
insetter8218593insetter
insetters9187133insetters
jockettes2254383jockettes
jostles143411143jos_tles
layettes1136263layettes
lottes65322753lo__ttes
lunettes836753lunettes
mofette1296773mofette_
moffettes1743463moffettes
moieties10311263moieties
moquettes2044643moquettes
mottes85523693mo__ttes
mozettas1993553mozettas
mozette1886773mozette_
musette938433musette_
navettes1136613navettes
noisette846313noisette_
octettes1045533octettes
oleates7417833_oleates
osetras737333_osetras
palettes103112833palettes
pipettes1237563pipettes
pirouettes1254363pirouettes
posties93128813pos_ties
posttest10410233pos_ttest
poussettes1243533poussettes
presettles1245023presettles
proette9312363pro_ette_
prosected14158633prosected
prosects1239473prosect_s
prosecutes1445673prosecutes
proselytes1544743proselytes
prostates11314423prostates
prosties101421193pros_ties
raclettes1147013raclettes
reletter81311023reletter
reletters9138783reletters
rentes65431193r__entes
reseated93220263reseated
reseats74319583reseat_s
resected112514743resected
resects94115593resect_s
resees63827483rese__es
reseizes1759853reseizes
resented92716963resented
resents74221223resent_s
reserves111011983reserves
resets65427613rese_t_s
resettle837303resettle
resettled1035303resettled
resites74027793res_ites
reslates83619503reslates
respites10513243respites
restates83423433restates
reties65436193r__eties
retted74826313r__etted
revetted122210943revetted
rewetted12228353rewetted
rillettes946533rillettes
risottos843583risottos
rivetted12226093rivetted
rodents8611543rodent_s
roomette1046103roomette_
rootles73215633ro_otles
roperies10315763roperies
roquette1755533roquette_
rosaries8312783rosaries
roscoes9310923ros_coes
roseately1244313roseately
rosebays13114913rosebays
rosebuds1143183rosebuds
rosehips1344253rosehips
roselle7310243roselle_
roseolas8107173roseolas
roses56445773ros___es
roset55945243rose_t__
rosewater1245023rosewater
roster64329083ros__ter
rosters73727543ros_ters
rotates72819773ro_tates
rotes56143903ro___tes
rotte54625933ro__tte_
rotted74524433ro__tted
rotten64115433ro__tten
rotter64325463ro__tter
rotters74421393ro__tters
roulette847093roulette_
rouletted1045053rouletted
routes66129313ro__utes
rustles73416413rus_tles
settee63721023__settee
settees73513633__settees
setter64023723__setter
setters73822063__setters
settles73916003__settles
setts55124323__sett_s
syrettes1136963syrettes
toilettes946023toilettes
tonette7310373tonette_
tsetses785453_tsetses
unsettles964653unsettles
upsetter1034643upsetter
upsetters1143653upsetters
vedettes1265943vedettes
videttes1266333videttes

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621617.89018525.0
3Display Results1611610.0802012.5
 (SQL Overall)1786911618.40621257.6
 
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.