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

264 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
corrade10111104(None) 
comrade12139211comrade
corraded12128291corraded
corrades111211261corrades
corrode101310571corrode
charade13129912charade
cirrate92413492cirrate
cockade1638132cockade
comade114415322co_made
comrades13149772comrades
cordage11310062cordage
cordate10315222cordate
corkage1438372corkage
corral83616252corra_l
corrals93713852corrals
corrida1078512corrida
corrie83621232corr_ie
corroded12147512corroded
corrodes111310332corrodes
corrody13136142corrody
corsage1039802corsage
courage10310992courage
couvade1335062couvade
forbade13259102forbade
forrader1236152forrader
torsade837592torsade
abrade9313053_abrade
aggrade1035643aggrade
aortae65115473aorta_e
arcade91013643_arcade
barrage10710843barrage
borage93917013bo_rage
borane84620213bo_rane
borate85026153bo_rate
boride9415903bo_ride
bourride1144403bourride
brocade1238533brocade
cade76443913c___ade
carafe115416163c_arafe
carate84734003c_arate
carbide126112493carbide
carcase11312743carcase
carfare12310073carfare
carnage10311743carnage
carpale113414353carpale
carrack1548753carrack
carriage1137853carriage
carried103717153carried
carronade1246093carronade
cartage10312593cartage
cascade12118603cascade
cerate84829463c_erate
chamade15138453chamade
charades141310853charades
chorale124313353chorale
chordate1448033chordate
cirrose937473cirrose
citrate92216803citrate
clade85821013c__lade
coarse84813903coar_se
cobra95214403cobra__
cobras104014193cobra_s
cockaded1836393cockaded
cockades1738433cockades
cocreate122611813cocreate
code77347733co___de
codrive1337653codrive
codrove1336423codrove
coerce10310403coer_ce
coerced1238583coerced
cognate10312203cognate
cohead123811123cohead_
coheaded1536603coheaded
coheads13289233coheads
coinage10310553coinage
colead94114643colead_
coleader1139183coleader
coleads102911423coleads
collage102813763collage
collate92919683collate
collide103214793collide
collude10337993collude
colorado1145933colorado
comae97128423co_ma_e
comake144413423co_make
comate104124843co_mate
commode1438123commode
compadre15295883compadre
compare135814993compare
comradely1783483comradely
comradery1793493comradery
concave1439373concave
concede12310103concede
confide13310203confide
congaed11399743congaed
connate9315753connate
copra98115463copra__
coprah133710603copra_h
coprahs14338153coprahs
copras103517153copra_s
coracle112011723coracle
coral76033453co_ra_l
corals85325143co_rals
corban10314693corba_n
corbans11313173corbans
corbie103618203co_rbie
cord76740923co_r_d_
cordages12310113cordages
corded105923353co_r_ded
corder94322883co_r_der
cordite10315263cordite
cords86030623co_r_ds
core67263113co_r__e
cored85044223co_red_
corelate10516013corelate
coria75828323coria__
coriander1245663coriander
corkages1539103corkages
corked135020783corked_
corncake1645263corncake
corncrake1743263corncrake
corned95224523corned_
cornfed1337383cornfed
cornice11612933cornice
cornute939643cornute
corody12149703co_rody
coronae94214893coronae
coronate103018213coronate
corotate102813933corotate
corporate13410903corporate
corpse104013403co_rpse
corrading1338203corrading
corralled1245283corralled
corrasive1445063corrasive
correct11513983correct
correlate1149043correlate
corridas1177313corridas
corridor1145033corridor
corries94026803corries
corrodies1247903corrodies
corrugate1255483corrugate
corrupt1149103corrupt
corsac10410173corsa_c
corsacs1139013corsacs
corsages11310363corsages
corsair937633corsair
corse75036183co_r_se
cortege1098953cortege
corvee114320093co_rvee
corvid12310473corvid_
corvids1337683corvids
corvine122113643corvine
costae85319683costa_e
costate94019273costate
cottae84615703cotta_e
cottage104210573cottage
coude85022633co__ude
courages11311393courages
courant9317973courant
courante1049953courante
course85117783cour_se
coursed104113603coursed
courted103514923courted
couvades1435613couvades
coverage1438733coverage
cowage12310673co_wage
coward12411673coward_
cowards1339613cowards
cowbane1437673cowbane
cowhage1636303cowhage
cowhide1636143cowhide
cowrie113814283cowr_ie
cowrite123612683cowrite
cowrote12289673cowrote
coxae146115183co_xa_e
cradle93313163c__radle
crake114823523c__rake
crane75331603c__rane
crape96128443c__rape
crate76537403c__rate
crave105626313c__rave
craze165221463c__raze
crease85519573c_rease
create85126383c_reate
crore74922873cror__e
crude86018573c__rude
crusade1036053crusade
curare84916953c_urare
curate85226243c_urate
curiae84518373curia_e
currach1446453currach
curragh1344293curragh
curran8312023curra_n
currans9310613currans
currant9314173currant
curred94319263curred_
currie84317263curr_ie
curried103313653curried
curtate9312643curtate
degrade10229903degrade
dorado838813do_rado
dorsad8408973dorsad_
ferrate103014043ferrate
forage104617003fo_rage
forbad122710503forbad_
forbare122310513forbare
forbode13257963forbode
forgave1435853forgave
formate123115093formate
forrarder1343623forrarder
forsake1436533forsake
gourde8107933gour_de
grade75126093__grade
horde94623053ho_r_de
horrid10311563horrid_
horrider1236533horrider
irade65618153__irade
joyride1853753joyride
joyrode1853303joyrode
moorage1038743moorage
morae75831193mo_ra_e
morale85220553mo_rale
narrate7313493narrate
normande1145943normande
noyade1036423no_yade
ocreae83310273ocrea_e
ocreate93711743ocreate
orad56031693_o_rad_
orate55133303_o_rate
oread64619603_oread_
oreads73915773_oreads
oreide7311673_oreide
ornate6315143_ornate
oroide7311703_oroide
orra46120723_orra__
orrice81410163_orrice
parade94720643_parade
parkade1437583parkade
pervade1337023pervade
pomade113611333po_made
porridge1243763porridge
portage103013643portage
prograde1247183prograde
prorate9418733prorate
protrade1148213protrade
regrade92612033regrade
roulade857003roulade
scoriae9310903scoria_e
serrate73017543serrate
sorbate9311733sorbate
sororate8411173sororate
terrace93311843terrace
terrae62915213terra_e
terrane72814233terrane
tirade7311693_tirade
tornado845673tornado
torrid7311853torrid_
torrider936173torrider
torsades937213torsades
trade65026043__trade
upgrade11215823upgrade
vorlage1136403vorlage
wordage1236503wordage
worried11308693worried

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272646.97019229.1
3Display Results2642640.0932838.7
 (SQL Overall)1786912647.45323975.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.