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

171 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
resonate851351(None) 
resinate8316771resinate
resonated10510611resonated
resonates9412401resonates
desolate9411992desolate
detonate9311192detonate
neonate7311332ne_onate
personate112111422personate
relocate10713532relocate
renovate1138552renovate
resinated10413282resinated
resinates9314762resinates
reslate73520592res_late
resolute868512resolute
resonance1147622resonance
resonant8410812resonant
resonants946692resonants
resonator946362resonator
restate73824882res_tate
areolate81014453are_olate
arsenate81010483arsenate
coronate103018213coronate
crenate93317113cre__nate
decorate11315193decorate
derogate10311353derogate
designate1147113designate
desolated1139653desolated
desolater1038383desolater
desolates10311793desolates
detonated1138213detonated
detonates10310433detonates
donate73619503__donate
ebonite9310293_ebonite
elongate945613_elongate
emanate9312473_emanate
enate54428153_e__nate
essonite845733essonite
estate64719763_es_tate
festinate1249473festinate
geminate11411813geminate
gestate83614073ges_tate
hesitate1169973hesitate
hessonite1244253hessonite
insolate8311893insolate
intonate8310923intonate
isolate7313923_isolate
lemonade1144283lemonade
masonite1049683masonite
messmate1246393messmate
neonates8310063ne_onates
odonate848403_odonate
ozonate1646863_ozonate
pennate93314033pe_nnate
peonage1048723pe_onage
pepsinate1346633pepsinate
perorate10417923perorate
personae102410553persona_e
personage12226713personage
personated13258293personated
personates122510693personates
phonate12411813_phonate
prelocate13109523prelocate
pronate9418873_pronate
protonate11412573protonate
reasonable1246283reasonable
rebate84424113re__bate
reboant9315093reboant_
reclinate11410023reclinate
recoat84024273reco_at_
recoated113416793reco_ated
recoats92616643reco_ats
recoinage1245643recoinage
recondite1248963recondite
recrate92621663re_crate
recreate10313603recreate
rectorate11411373rectorate
redate74124683re__date
redone74820053redon__e
reflate103516263re_flate
reformate1446953reformate
regelate9312083regelate
reginae84713453regina_e
regrate82618663re_grate
regulate9313023regulate
reignite947233reignite
relate64033633re__late
relegate9311243relegate
relocated12710813relocated
relocatee11810633relocatee
relocates11712933relocates
remate84428683re__mate
remolade1147203remolade
remote84222603remo__te
rename82718813re__name
rennase738713re_nnase
renominate12178423renominate
renovated1347173renovated
renovates1248453renovates
rente54733783re__n_te
replate93420053re_plate
reprobate1347683reprobate
reroute7313963rero_ute
resale64025543res__ale
resalute857413resalute
resat55139683res__at_
rescale93215483res_cale
reseat64131493res_eat_
reseated93220263res_eated
reseats74319583res_eats
resent63833623resen_t_
resented92716963resen_ted
resents74221223resen_ts
reshape1249043res_hape
reshave1338603res_have
reshone102414163reshon__e
resite64128453res__ite
resituate948613resituate
reslated93517523res_lated
reslates83619503res_lates
resoak10311093reso_a_k
resoaked1337943reso_aked
resoaks1148973reso_aks
resoften1145443reso_ften
resojet14312823resojet_
resojets1535343resojets
resole64624183reso__le
resoluter966183resoluter
resolutes968193resolutes
resolve103910983reso_lve
resonances1246873resonances
resonantly1353853resonantly
resonating11311263resonating
resonators1045813resonators
resort65728623reso_rt_
resorted9313493reso_rted
resorter8312183reso_rter
resorts74817193reso_rts
resource1046313resource
respace11310913res_pace
respade1039573res_pade
respite9513033res_pite
response1037753respon_se
restage83316193res_tage
restated93120183res_tated
restates83423433res_tates
resupinate1244423resupinate
retinae75517333retina_e
retinite8314853retinite
reunite7312713re_unite
reviolate1248123reviolate
revolute1176793revolute
revote94917453revo__te
rezone153814783rezon__e
roseate7613453ros_eate
rostrate8313843rostrate
rosulate8310903rosulate
rotate63320343r__otate
ruinate7312833r_uinate
ruminate10511473ruminate
selenate81712533selenate
senate63725173__senate
serenate81914883serenate
solate64526073__solate
sonata6313223__sonata
ternate7415483te_rnate
testate73916233tes_tate
thionate11137503thionate
umbonate1245293umbonate
venenate1147933venenate
vesicate131210053vesicate
zonate154114923__zonate

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.420425454.8
2DLD Change Limit1461621717.56319325.9
3Display Results1711710.0632714.3
 (SQL Overall)1786911718.04622208.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.