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

258 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
corsage103980(None) 
cordage11310061cordage
corkage1438371corkage
corsages11310361corsages
borage93917012bor_age
carnage10311742carnage
cartage10312592cartage
coinage10310552coinage
collage102813752collage
cordages12310112cordages
cordate10315212cordate
corkages1539102corkages
corrade101111042corrade
corsac10410172corsa_c
corsacs1139012corsacs
corsair937632corsair
corse75036182cors__e
cortege1098942cortege
cottage104210572cottage
courage10310992courage
cowage12310662co_wage
cowhage1636292cowhage
dosage82810002do_sage
forage104616992for_age
forsake1436532forsake
portage103013642portage
torsade837592torsade
vorlage1136402vorlage
wordage1236502wordage
acreage1037833acreage
aortae65115473aorta_e
barrage10710843barrage
bondage1138253bondage
borages103917163bor_ages
borane84620213bor_ane
borate85026153bor_ate
boscage1276533boscage
boskage1465413boskage
brokage1436673brokage
burgage1136633burgage
bursae84515603bursa_e
bursate94111203bursate
cabbage1446983cabbage
cage75339063c___age
carafe115416163car_afe
carate84734003car_ate
carcase11312733carcase
carfare12310073carfare
carnages11312213carnages
carpale113414353carpale
carriage1137853carriage
carse74934333cars__e
cartages11313313cartages
cerate84829463cer_ate
choragi1346683chor_agi
chorale124313353chor_ale
chordate1448033chordate
cirrate92413483cirrate
coarse84813893coars__e
cockade1638133cockade
cocreate122611813cocreate
coesite9713623coesite
cognate10312193cognate
coinages11310803coinages
collaged12279963collaged
collagen11338563collagen
collages113514233collages
collate92919683collate
college102410433college
comade114415323co_made
comae97128423co_ma_e
comake144413423co_make
comanage1346343comanage
comate104124843co_mate
compare135814993compare
comrade12139213comrade
concave1439373concave
conge85227593co__nge
connate9315753connate
consign1038773consign
console92715983console
consume11510133consume
copse95623923cops__e
coracle112011723coracle
coral76033453cor_a_l
corals85325143cor_als
corban10314693corba_n
corbans11313173corbans
corbie103618203cor_bie
cordite10315253cordite
core67263113cor___e
coreign1037343coreign
corelate10516013corelate
corgi8316083cor__gi
coria75828303coria__
coring94433963coring_
corncake1645263corncake
cornice11612933cornice
cornute939633cornute
coronae94214893coronae
coronate103018213coronate
corotate102813933corotate
corpse104013403cor_pse
corraded12128293corraded
corrades111211263corrades
corral83616253corra_l
corrals93713853corrals
corrie83621213cor_rie
corrode101310573corrode
cors66656443cors___
corsairs1046863corsairs
corselet10414573corselet
corses84433463cors_es
corset85636223cors_et
corseted11311473corseted
corsets94819803corsets
corslet9318063corslet
corteges1198813corteges
coruscate1346053coruscate
corvee114320093cor_vee
corvine122113643corvine
cosie74728263co_s_ie
cosign958783co_sign
cosine83823513co_sine
cossack1545823cossack
costae85319683co_stae
costate94019273costate
cottae84615703cotta_e
cottager11306803cottager
cottages113310493cottages
cottagey14305233cottagey
courages11311393courages
course85117773cours__e
cousinage1243503cousinage
couvade1335063couvade
coverage1438733coverage
cowages13310933co_wages
cowbane1437673cowbane
cowhages1736103cowhages
coxae146115183co_xa_e
cozenage2094783cozenage
crag75625303c_r_ag_
crags85622573c_r_ags
crake114823523c_r_ake
crane75331603c_r_ane
crape96128443c_r_ape
crate76537403c_r_ate
crave105626313c_r_ave
craze165221463c_r_aze
crease85519573c_rease
create85126373c_reate
cringe93515483c_ringe
crosse85216303cros_se
crusade1036053crusade
cubage1178273c_ubage
curagh1236553cur_agh
curare84916953cur_are
curate85226243cur_ate
curiae84518373curia_e
curragh1344293curragh
curse75829143curs__e
cursive1237833cursive
curtate9312643curtate
cuttage10318343cuttage
dockage1535723dockage
dorsa64617283dorsa__
dorsad8408973dorsa_d
dorsal74613943dorsa_l
dorsals84110843dorsals
dosages92310803do_sages
dotage82711613do_tage
ecotage1036883eco_tage
enrage72715073enr_age
foggage1334113foggage
foliage1147533foliage
footage1148833footage
foraged124812273for_aged
forager114412553for_ager
forages114217273for_ages
forbade13259103forbade
forbare122310513forbare
forestage1346973forestage
forgave1435853forgave
forge95126943for__ge
formate123115093formate
forsaken1543353forsaken
forsaker1545103forsaker
forsakes1536893forsakes
fossae95510373fossa_e
fossate10388603fossate
fromage1336753fromage
garage8314513gar_age
garbage1138053garbage
gorge76423893gor__ge
gorse65926813gors__e
herbage1337003herbage
homage121210603ho_mage
horse86132653hors__e
horste94817413hors_te
hostage113111233hostage
lockage1436613lockage
lovage1037353lo_vage
massage1039893massage
message1037833message
mirage92313653mir_age
montage101211713montage
moorage1038733moorage
morae75831193mor_a_e
morale85220553mor_ale
morse76032703mors__e
mortgage1244213mortgage
moulage1037903moulage
nonage7313683no_nage
nonwage1137163nonwage
ocreae83310273ocrea_e
ocreate93711743ocreate
ohmage1295063_ohmage
onstage838363_onstage
orange74016323_orange
orate55133303_or_ate
ornate6315133_ornate
outage72017533_outage
passage1039803passage
portaged12228463portaged
portages112613223portages
postage103214853postage
potage92715903po_tage
pottage103310603pottage
presage10312293presage
rage55742353__r_age
rootage839043rootage
sage55044593___sage
sausage847193sausage
scoriae9310893scoria_e
serfage1138403serfage
shortage1236303shortage
soakage1236103soakage
socage91012123so_cage
soccage1236283soccage
soilage8169353soilage
sorbate9311733sorbate
storage8310473stor_age
tollage82610163tollage
tonnage8168053tonnage
torsades937203torsades
torse55833333tors__e
towage1039833to_wage
triage72812893_triage
ursae55214453_ursa_e
usage6410213__usage
visage1049083_visage
voltage1136863voltage
vorlages1236033vorlages
voyage1335473vo_yage
warpage1336403warpage
wordages1337053wordages
worse86525263wors__e
yardage1235733yardage

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.1561145455.1
2DLD Change Limit1340272587.65617506.1
3Display Results2582580.0763394.7
 (SQL Overall)1786912587.88822653.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.