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

126 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
tonettes83920(None) 
tonette7310371tonette_
dinettes9310192dinettes
fouettes1137882fouettes
genettes938302genettes
lunettes836752lunettes
mofettes1386082mofettes
rosettes8310342rosettes
toilettes946022toilettes
tonemes9311682tone_mes
tonetics1048942tonetics
ariettes8411353ariettes
boletes9316063bole_tes
bonesets1036843bonesets
bonitoes1038153bonitoes
brunettes1144583brunettes
burettes1048953burettes
casettes1039653casettes
cocottes1238303cocottes
conepates13912283conepates
confutes1339843confutes
connotes10311453connotes
contes84432913con__tes
coquettes2065983coquettes
corvettes1447433corvettes
curettes1039313curettes
cuvettes1335323cuvettes
dinette8310013dinette_
donates83217223don_ates
donees74519493done__es
fossettes1245083fossettes
fouette1038213fouette_
fumettes1345773fumettes
galettes93111163galettes
gazettes18296863gazettes
genette838863genette_
honester1139713honester
honestest1247303honestest
honesties1249913honesties
jockettes2254383jockettes
joneses1438963jone_ses
layettes1136263layettes
lorgnettes1152693lorgnettes
lottes65322753lo__ttes
lunette737483lunette_
mofette1296773mofette_
moffettes1743463moffettes
moieties10311263moieties
monetise10311473monetise
monetises11311043monetises
monetizes2049263monetizes
montes84226933mon__tes
moquettes2044643moquettes
mottes85523693mo__ttes
mozettas1993543mozettas
mozette1886773mozette_
musettes1037433musettes
navettes1136613navettes
netted74118713__netted
netter63722023__netter
netters73618583__netters
nettles73214083__nettles
netts55320723__nett_s
nineties8312913nineties
noisettes946533noisettes
nonets64118703none_t_s
octettes1045533octettes
oleates7417833_oleates
palettes103112833palettes
pipettes1237563pipettes
pontes83627853pon__tes
proettes10312763proettes
roomettes1146543roomettes
roquettes1855063roquettes
rosette7310373rosette_
rottes64524833ro__ttes
roulettes946523roulettes
satinettes1043923satinettes
sonnetted1044543sonnetted
syrettes1136963syrettes
tannates81911953tannates
teethes103611653t_eethes
telnetted1043813telnetted
tenets65518953tene_t_s
testes65125823t__estes
tetter64322453t__etter
tetters74320473t__etters
tofuttis1141523tofuttis
together1243743together
toilette846683toilette_
tolerates9312123tolerates
toluates8138903toluates
tomatoes1038613tomatoes
tonearms1044713tonearms
toneless8610393toneless
toneme8312103tone_me_
toners64128003tone__rs
tones56048663ton___es
tonetic9313433tone_tic
tongues879693ton_gues
tonlets73212503tonlet_s
tonnages9187873tonnages
tonnes65320853ton__nes
tonsures869133tonsures
tontines82114733tontines
tonuses73612193ton_uses
tootles72915603to_otles
tootses72910773to_otses
topees85519703tope__es
tortes64826053to__rtes
totemites1146603totemites
totes55139683to___tes
totted74319953to__tted
totter65021463to__tter
totters74618733to__tters
towelettes1342743towelettes
townees10269783towne__es
trientes82812123trientes
tsetses785453t_setses
twenties1137503twenties
tzetzes1532673t_zetzes
vedettes1265943vedettes
videttes1266333videttes
vignettes1344673vignettes
wagonettes1442913wagonettes
zonetimes2044203zonetimes

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.423422437.4
2DLD Change Limit1461621267.92018454.8
3Display Results1261260.0462739.1
 (SQL Overall)1786911268.38921300.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.