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

149 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
resonates941240(None) 
resinates9314761resinates
resonate8513511resonate_
resonated10510611resonated
desolates10311792desolates
detonates10310432detonates
neonates8310062ne_onates
personates122510692personates
relocates11712932relocates
renovates1248452renovates
resinate8316772resinate_
resinated10413282resinated
reslates83619502res_lates
resolutes968192resolutes
resonances1246872resonances
resonants946692resonants
resonator946362resonator
resonators1045812resonators
restates83423432res_tates
arsenates979373arsenates
coronates1110816923coronates
decorates12314743decorates
derogates11310973derogates
designates1246363designates
desolate9411993desolate_
desolated1139653desolated
desolater1038383desolater
desolaters1146043desolaters
detonate9311193detonate_
detonated1138213detonated
donates83217223__donates
ebonites1039233_ebonites
elongates1045383_elongates
emanates10311333_emanates
enates64026433_e__nates
essonites945153essonites
estates74520183_es_tates
festinates1348943festinates
geminates12310043geminates
gestates93213733ges_tates
hesitates1269793hesitates
hessonites1343693hessonites
insolates9311273insolates
intonates9410243intonates
isolates8613513_isolates
lemonades1244093lemonades
masonites1149173masonites
messmates1346233messmates
neonate7311333ne_onate_
odonates947743_odonates
ozonates1745963_ozonates
penates93321603pe__nates
peonages1138473pe_onages
pepsinates1446373pepsinates
perorates11417023perorates
personages13276533personages
personate112111423personate_
personated13258293personated
phonates13410643_phonates
prelocates1468353prelocates
pronates10418373_pronates
protonates12411693protonates
rebates95123183re__bates
recoated113416783reco_ated
recoats92616643reco_at_s
recoinages1345393recoinages
recrates102420373re_crates
recreates11313363recreates
rectorates12410363rectorates
redates83423873re__dates
reflates113115663re_flates
reformates1546263reformates
regelates10311113regelates
regrates92618403re_grates
regulates101211723regulates
reignites1046933reignites
relates73731433re__lates
relegates10310943relegates
relocate10713533relocate_
relocated12710813relocated
relocatee11810633relocatee
relocatees1275223relocatees
remates93827113re__mates
remolades1246563remolades
remotes94521613remo__tes
renames92418053re__names
rennases848983re_nnases
renominates13137803renominates
renovate1138553renovate_
renovated1347173renovated
rentes65431193re__n_tes
replates102919273re_plates
reprobates1447363reprobates
reroutes8312223rero_utes
resales74724903res__ales
resalutes947433resalutes
rescales103414573res_cales
reseated93220263res_eated
reseats74319583res_eat_s
resented92716963resen_ted
resents74221223resen_t_s
reshapes1338803res_hapes
reshaves1438733res_haves
resites74027793res__ites
resituates1047753resituates
reslate73520593res_late_
reslated93517523res_lated
resoaked1337943reso_aked
resoaks1148973reso_a_ks
resoften1145443reso_ften
resoftens1243713reso_ftens
resojets1535343resojet_s
resoles73823653reso__les
resolute868513resolute_
resoluter966183resoluter
resolutest1053923resolutest
resolves113010783reso_lves
resonance1147623resonance
resonant8410813resona_nt
resonantly1353853resonantly
resonating11311263resonating
resorted9313493reso_rted
resorter8312183reso_rter
resorters939693reso_rters
resorts74817193reso_rt_s
resources1146203resources
respaces12311043res_paces
respades1139853res_pades
respites10513243res_pites
responses1147453respon_ses
restages92815773res_tages
restate73824883res_tate_
restated93120183res_tated
retinites9313503retinites
reunites8312473re_unites
reviolates1347533reviolates
revotes104716393revo__tes
rezones163213943rezon__es
rotates72819773r__otates
ruinates8311883r_uinates
ruminates11410193ruminates
selenates91611363selenates
senates73322613__senates
solates73523853__solates
sonatas7510293__sonatas
testates83615453tes_tates
thionates12106663thionates
venenates1247583venenates
vesicates14119033vesicates

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411496.50022867.8
3Display Results1491490.0632365.1
 (SQL Overall)1786911496.98625578.4
 
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.