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

136 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
coronated12331332(None) 
coronate103018211coronate_
coronates1110816921coronates
coroneted12278321coroneted
corotated122810051corotated
carbonated1547242carbonated
carinated123414272carinated
cohobated1744882cohobated
colocated1439612colocated
corelated12411822corelated
cornuted1137472cor_nuted
coronae94214892corona_e_
corotate102813932corotate_
corotates112714282corotates
crenated113013912c_renated
ozonated1864592_ozonated
pronated11414052_pronated
abrogated13126713abrogated
arrogated11147143arrogated
borated104116363bor__ated
bromated1339173_bromated
carbonate13410513carbonate_
carbonates1449133carbonates
carinate103320253carinate_
catenated1238923catenated
cerated103922473cer__ated
chlorinated1744493chlorinated
chromate15312783chromate_
chromates16313113chromates
chromatid17410913chromatid
coated94927043c__o_ated
cocreated142710093cocreated
coenacted1445803co_enacted
coequated2144823coequated
cogitated1346323cogitated
cognate10312203co_gnate_
cognates11311583co_gnates
cohobate1547013cohobate_
cohobates1646523cohobates
cohosted1436143coho_sted
collated113615063co_llated
collocated1546163collocated
colocate12313443colocate_
colocates13312853colocates
colonised12248723colonised
colonized212710433colonized
colonnaded1441943colonnaded
comanaged1544523comanaged
combated1539823co_mbated
conflated1539333conflated
confronted1644193confron_ted
connate9315753co_nnate_
connoted1138863co_nnoted
coopted123710773co_o_pted
coordinated1553513coordinated
copulated142710483copulated
cordate10315223cor_date_
cordoned12229613cordon__ed
corelate10516013corelate_
corelates11314863corelates
corned95224523cor_n__ed
cornered11311133cor_nered
cornfed1337383cor_n_fed
corniced1368603cor_niced
cornute939643cor_nute_
corollate1148123corollate_
corona83817403corona___
coronach1545763corona_ch
coronachs1644253coronachs
coronal94115763corona__l
coronally1448413coronally
coronals103312913corona_ls
coronaries12410243coronaries
coronary1347693corona_ry
coronas93916913corona__s
coronating13410173coronating
coronation12412073coronation
coronel94515223coron__el
coroner94218203coron__er
coronet94227173coron__et
coronets103814363coronet_s
coronoid1148953coron_oid
corporate13410903corporate_
corporates14410733corporates
corraded12128293cor_raded
corrected1438123corrected
correlated1346683correlated
corrugated1444433corrugated
corrupted1444503corrupted
corseted11311473cor_seted
coruscated1544473coruscated
counted103815803co_un_ted
covenanted1663803covenanted
crated94827773c_r__ated
created104323453c_r_eated
cremated133412963c_remated
crenate93317113c_renate_
croaked143710543c_ro_aked
crooned103813353croon__ed
curated104717583cur__ated
derogated1238683derogated
detonated1138213detonated
dominated1339883dominated
donated93513863__donated
foredated1447683foredated
forenamed1545163forenamed
fronted114011273_fron_ted
intonated1048303intonated
iodinated1146943iodinated
loricated1247903loricated
marinated122513173marinated
mordanted1344413mordanted
nominated1239283nominated
odonate848403_odonate_
odonates947743_odonates
orated74221503_or__ated
ornate6315143_or_nate_
ozonate1646863_ozonate_
ozonates1745963_ozonates
perorated12412473perorated
personated13258293personated
phonated1447893_phonated
probated13410863_probated
pronate9418873_pronate_
pronates10418373_pronates
prorated11513713_prorated
prorogated1445723prorogated
protonated1348593protonated
resonated10510613resonated
rotated82715293__rotated
saponated1245733saponated
sororate8411173sororate_
sororates9410473sororates
throated1247923thro_ated
urinated9311613_urinated
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.420425454.8
2DLD Change Limit1486411367.42320024.4
3Display Results1361360.0632158.7
 (SQL Overall)1786911367.90622601.9
 
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.