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 “resonated” 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
resonated1051061(None) 
resinated10413281resinated
resonate8513511resonate_
resonates9412401resonates
desolated1139652desolated
detonated1138212detonated
personated13258292personated
recoated113416792reco_ated
relocated12710812relocated
renovated1347172renovated
reseated93220262res_eated
resented92716962resen_ted
resinate8316772resinate_
resinates9314762resinates
reslated93517522res_lated
resoaked1337942reso_aked
resonator946362resonator
resorted9313492reso_rted
restated93120182res_tated
areolated1089723are_olated
besotted1135843beso_tted
coronated123313323coronated
crenated113013913cre__nated
decorated13312213decorated
derogated1238683derogated
descanted1336673descanted
designated1345933designated
desolate9411993desolate_
desolater1038383desolater
desolates10311793desolates
detonate9311193detonate_
detonates10310433detonates
donated93513863__donated
elongated1144283_elongated
emanated1139163_emanated
estated83715573_es_tated
festinated1447533festinated
geminated1338553geminated
gestated102910573ges_tated
hesitated1377783hesitated
insolated1039713insolated
intonated1048303intonated
isolated9410523_isolated
neonate7311333ne_onate_
neonates8310063ne_onates
ozonated1864593_ozonated
pennated11299543pe_nnated
pepsinated1545233pepsinated
perorated12412473perorated
personate112111423personate_
personates122510693personates
phonated1447893_phonated
prelocated1597183prelocated
presented12311633presen_ted
presoaked1635653preso_aked
presorted1239453preso_rted
pronated11414053_pronated
protonated1348593protonated
reasoned9410733reason__ed
rebated103619703re__bated
rebooted11248463rebo_oted
recanted112513513recan_ted
recoaled113111793reco_aled
reconned113610663recon_ned
recontacted1654713recontacted
recounted1238723recounted
recrated112918613re_crated
recreated12412543recreated
redated93120923re__dated
redonned10297103redon_ned
reenacted1236853re_enacted
reflated123514293re_flated
refloated1347013refloated
refronted1336063refron_ted
regelated1139723regelated
regranted1137703regranted
regrated102816333re_grated
regulated11310463regulated
reheated122415003re_heated
reignited1145683reignited
reknotted1443523reknotted
related83327573re__lated
relegated1139763relegated
relented92614943relen_ted
reloaded1059103relo_aded
reloaned939723relo_aned
relocate10713533relocate_
relocatee11810633relocatee
relocates11712933relocates
remated103522473re__mated
reminted113615083remin_ted
remounted1236283remounted
renamed103114523re__named
renominated14146973renominated
renovate1138553renovate_
renovates1248453renovates
rented74426593re__n_ted
repeated113117443re_peated
repented112614983repen_ted
replanted1248063replanted
replated112817523re_plated
reported11312703repo_rted
reposited1239143reposited
repotted1139283repo_tted
reprobated1546393reprobated
rerented92516163reren_ted
rerouted9311153rero_uted
resaluted1046473resaluted
resawed113111193res__awed
rescaled113311303res_caled
resealed92713973res_ealed
resected112514743res_ected
reshaped1437203res_haped
reshaved1536873res_haved
resifted12310153res_ifted
resighted1436523resighted
resined84522653resin__ed
resisted9312693res_isted
resited85122423res__ited
resituated1147323resituated
reslate73520593res_late_
reslates83619503res_lates
resmelted1236043resmelted
resodded1136353reso_dded
resoften1145443reso_ften
resoled84119283reso__led
resolute868513resolute_
resoluter966183resoluter
resolutes968193resolutes
resolved12349343reso_lved
resonance1147623resonance
resonances1246873resonances
resonant8410813resona_nt
resonantly1353853resonantly
resonants946693resonants
resonating11311263resonating
resonators1045813resonators
resorbed1138533reso_rbed
resorter8312183reso_rter
resounded1136323resounded
resowed113712263reso__wed
respaced1338503res_paced
respaded1238133res_paded
respected1438493respected
respited11410813res_pited
responded1336513respon_ded
respotted1235953respotted
resprayed1544353resprayed
restaged103011863res_taged
restarted10410053restarted
restate73824883res_tate_
restates83423433res_tates
rested74430783res___ted
resulted939713res_ulted
retinted94414363retin_ted
retorted9312333reto_rted
retotaled1045953retotaled
retreated10312633retreated
reunited939713re_united
reviolated1446253reviolated
revolted12319863revo_lted
revoted114314153revo__ted
rezoned173611163rezon__ed
rotated82715293r__otated
ruinated939523r_uinated
ruminated1258663ruminated
saponated1245733saponated
solated83618023__solated
venenated1345903venenated
vesicated15117653vesicated
zonated173310533__zonated

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 Limit1486411716.59322545.3
3Display Results1711710.0762250.0
 (SQL Overall)1786911717.09225196.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.