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

139 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
tonette731037(None) 
tonettes839201tonettes
dinette8310012dinette
fouette1038212fouette
genette838862genette
lunette737482lunette
mofette1296772mofette
mozette1886772mozette
rosette7310372rosette
toilette846682toilette
toneme8312102tone_me
tonetic9313432tonetic
ariette7312373ariette
bolete8519613bole_te
boneset9316433boneset
brunette1044723brunette
burette939853burette
casette9310393casette
cocotte1138603cocotte
conepate12712533conepate
confetti1345993confetti
confetto1346253confetto
confute1239263confute
connate9315753connate
connote9311613connote
conte76633203con__te
coquette1976593coquette
corvette1338093corvette
cuneate9311723cuneate
curette939783curette
cuvette1235833cuvette
dinettes9310193dinettes
donate73619503don_ate
donee66931013done__e
fossette1145263fossette
fouettes1137883fouettes
foveate1338363foveate
fumette1245523fumette
galette84212703galette
gazette17357363gazette
genettes938303genettes
honest94822423honest_
honester1139713honester
honesty13378053honesty
jockette2165033jockette
layette1037133layette
lineate7815153lineate
lorgnette1043113lorgnette
lotte54923853lo__tte
lunettes836753lunettes
mofettes1386083mofettes
moffette1643493moffette
monetise10311473monetise
monetize1949983monetize
monte75829773mon__te
moquette1944973moquette
motte75526973mo__tte
mozetta1894753mozetta
mozzette1842913mozzette
musette938433musette
navette1036983navette
nett46643233__nett_
netted74118713__netted
netter63722023__netter
nettle64514583__nettle
netts55320723__netts
netty85816763__netty
noisette846313noisette
nonelite8313613nonelite
nonet54540843none_t_
nonets64118703none_ts
octette946423octette
oleate6318883_oleate
onetime937623_onetime
palette93613983palette
pipette1137943pipette
ponent82821593ponent_
proette9312363proette
roomette1046103roomette
roquette1755533roquette
roseate7613453roseate
rosettes8310343rosettes
rotte54625933ro__tte
roulette847093roulette
satinette944553satinette
sonnetted1044543sonnetted
strette7310763strette
syrette1037183syrette
tannate71813523tannate
teethe94511313t_eethe
telnetted1043813telnetted
tenet55542213tene_t_
tenets65518953tene_ts
tentie62521183ten_tie
terete6319333tere_te
tetter64322453t__etter
toccate1138773toccate
tofutti1041573tofutti
togate74515683to_gate
together1243743together
toilettes946023toilettes
tolerate8312323tolerate
toluate7159343toluate
tomenta9319833tomenta
tone46953743ton___e
tonearm937443tonearm
toned65435343tone__d
tonemes9311683tonemes
tonemic11310173tonemic
toner55336243tone__r
toners64128003tone_rs
tones56048663tone__s
tonetics1048943tonetics
toney86027413tone__y
tongue7410093ton_gue
toniest73218903toniest_
tonlet62924703tonlet_
tonlets73212503tonlets
tonnage8168053tonnage
tonne54921433ton__ne
tonsure758783tonsure
tontine72316143tontine
tootle62613813to_otle
topee76029953tope__e
torte55431703to__rte
tote46643673to___te
totemite1046873totemite
totted74319953to__tted
totter65021463to__tter
towelette1243403towelette
townee92815213towne__e
tsetse664693t_setse
tzetze1432733t_zetze
vedette1166003vedette
vidette1167543vidette
vignette1245043vignette
wagonette1343353wagonette
zonate154114923zon_ate
zonetime1944953zonetime

Search took 10 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.813219792.1
2DLD Change Limit1340271398.23316279.2
3Display Results1391390.0463021.7
 (SQL Overall)1786911399.09219653.7
 
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.