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

129 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
corroded1214751(None) 
corraded12128291corraded
corrode101310571corrode_
corrodes111310331corrodes
borrowed1465042borrowed
carromed1338562carromed
corded105923352co_r_ded
cordoned12229612cordoned
cornrowed1543622cornrowed
corrade101111042corrade_
corrades111211262corrades
corrodies1247902corrodies
corrody13136142corrod_y
forboded15215352forboded
sorrowed1264832sorrowed
arrowed1148113_arrowed
boarded113910503boar_ded
borrower1384833borrower
brooded113510933_brooded
burrowed1444443burrowed
carboyed1637183carboyed
carded105424903c_ar_ded
caroled103717693c_aroled
caromed123713623c_aromed
carried103717153carr_ied
cartoned111312833cartoned
chorded144710553chor_ded
chromed153510923c_hromed
cirrhosed1542343cirrhosed
cirriped1344183cirriped
cirrose937473cirrose_
cockaded1836393cockaded
cocooned1337293cocooned
codded114515303co__dded
coded95433183c___oded
codrove1336423codrove_
coerced1238583coer_ced
coheaded1536603coheaded
collided12309803collided
colluded12296463colluded
colored10313473co_lored
commode1438123commode_
commodes1539093commodes
commoved1844763commoved
composed154612063composed
comrade12139213comrade_
comrades13149773comrades
conceded1438293conceded
condoled123110723condoled
condoned122612023condoned
confided1537453confided
connoted1138863connoted
consoled112911453consoled
convoked18236163convoked
convoyed17225553convoyed
cooed84534343co__o_ed
cooeed95917863co__oeed
cooked135921363co__oked
cooled95224593co__oled
cooped114821603co__oped
coproduced1852943coproduced
corbeled1338373corbeled
corder94322883co_r_der
corduroyed1751453corduroyed
cored85044223co_r__ed
corked135020783co_r_ked
cormoid12310403cormo_id
corned95224523co_r_ned
cornered11311133cornered
cornfed1337383co_rnfed
corniced1368593corniced
cornuted1137473cornuted
corodies11313693co_rodies
corody12149703co_rod_y
coronel94515223co_ronel
coroner94218203co_roner
coronet94227173co_ronet
corralled1245283corralled
corrected1438113corrected
corrida1078503corrid_a
corridas1177313corridas
corridor1145033corridor
corrie83621223corr_ie_
corries94026793corr_ies
corroding1337943corroding
corrupted1444503corrupted
corseted11311473corseted
corymbed1842613corymbed
cottoned1138033cottoned
coursed104113603cour_sed
courted103514923cour_ted
cowboyed1943373cowboyed
cowhided1843753cowhided
cowrote12289673cowrote_
crooked143910943c_rooked
crooned103813343c_rooned
crowded14418793c_rowded
crowed124717303c__rowed
crudded1235733c_rudded
curded104217163c_ur_ded
curred94319263curr__ed
curried103313653curr_ied
eroded84313583__eroded
farrowed1545283farrowed
forbode13257963forbode_
forbodes14217103forbodes
forded115020393fo_r_ded
foreboded1645673foreboded
forrader1236153forrader
furrowed1563833furrowed
garroted1056783garroted
harrowed1556263harrowed
hoarded12368343hoar_ded
hooded114616743ho__oded
horded115420483ho_r_ded
horrider1236533horrider
joyrode1853303joyrode_
lorded84916733lo_r_ded
marrowed1445973marrowed
mirrored1145773mirrored
narrowed1235203narrowed
parroted1158843parroted
pogromed1444813pogromed
sorrower1165043sorrower
torrider936173torrider
wooded114213683wo__oded
worded114316623wo_r_ded
worried11308693worr_ied
worrited1235743worrited

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621296.62322068.9
3Display Results1291290.0502580.0
 (SQL Overall)1786911297.10925135.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.