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

271 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
barrage1071084(None) 
barraged1297681barraged
barrages11711081barrages
arrange838682_arrange
baggage1235632baggage
bandage11311022bandage
barbate11314542barbate
barege94713542ba_rege
barge85631022ba_r_ge
baronage1147072baronage
barrable1249242barrable
barrack1538252barrack
barrater10310142barrater
barre75929542barr__e
barrelage1243572barrelage
barware12610702barware
borage93917012b_orage
burgage1136632burgage
carnage10311742carnage
carriage1137852carriage
cartage10312592cartage
farrago1144922farrago
garage8314512ga_rage
garbage1138052garbage
marriage1147252marriage
narrate7313492narrate
warpage1336402warpage
yardage1235732yardage
aarrgh10786303aarr_gh
abrade9313053_abrade
abridge1135693abridge
acreage1037833acreage
adage7414053_a_dage
aerate64830553_aerate
agrafe1038093_agrafe
ambage11510603_ambage
anlage72514223_anlage
arame75026623_a_rame
arcade91013643_arcade
arcane81216743_arcane
areae55229743_area_e
arrack121110253_arrack
arraign845063_arraign
arranged1036933_arranged
arranger936873_arranger
arranges939413_arranges
arrant6623253_arrant
arras55626133_arra_s
arrased8149863_arrased
arrases71214543_arrases
array86317143_arra_y
arrayed11117153_arrayed
arrayer10136703_arrayer
arrays95311683_arrays
arrive91311793_arrive
aurae54128113_aura_e
aurate64426473_aurate
average1158853average
baccae12119703bacca_e
baccate131011263baccate
badge94819683ba__dge
badinage1294923badinage
baggages1335443baggages
ballade104012563ballade
bandaged1337313bandaged
bandager1237703bandager
bandages12310633bandages
barbal104016663barba_l
barbe95328283ba_r_be
barbie105018353ba_rbie
barbule1137943barbule
barca91319433barca__
barcas101016603barca_s
barde85330773ba_r_de
bare65460523ba_r__e
bareges105212033ba_reges
bargain1079063bargain
barged105822643ba_r_ged
bargee94624443ba_rgee
barges94528253ba_r_ges
baring95135853baring_
barite84224813ba_rite
barmaid1238203barmaid
barman103519703barma_n
barmie103816393ba_rmie
barnacle1245943barnacle
baronages1247153baronages
barong96015823barong_
barongs105310833barongs
baronne938263baronne
baroque1835103baroque
barque17239553ba_rque
barracked1844753barracked
barracker1744653barracker
barracks1636883barracks
barraging1337383barraging
barranca1245583barranca
barranco1244943barranco
barraters1138043barraters
barrator1048403barrator
barratry13114473barratry
barred95725793barr_ed
barrel84517873barr_el
barrelages1343623barrelages
barreled1137843barreled
barrels94514363barrels
barren85317613barr_en
barrener1038333barrener
barrens94414323barrens
barres84427543barr_es
barret84930483barr_et
barrets94917103barrets
barrette1039783barrette
barricade1454523barricade
barrier94017733barrier
barring104021593barring
barrio8312573barr_io
barrios9310773barrios
barroom1139373barroom
barrow114512763barr_ow
barrows123411683barrows
barwares13610093barwares
barye105021493ba_r_ye
baryte115312883ba_ryte
bedrape1277693bedrape
berake124216083b_erake
berate84729023b_erate
bereave1258353bereave
beverage1445143beverage
birdcage1443513birdcage
bondage1138253bondage
borages103917163b_orages
borane84620213b_orane
borate85026153b_orate
boscage1276533boscage
boskage1465413boskage
brace95629273b__race
brae65639113b__ra_e
brag75229723b__rag_
brags85625103b__rags
brake116025343b__rake
brakeage1544013brakeage
brassage1145283brassage
brave104925503b__rave
braze165423453b__raze
brewage1347183brewage
bridge103711883b_ridge
brokage1436673brokage
bulkage1435703bulkage
buoyage1344293buoyage
burgages1236483burgages
burgrave1443113burgrave
bursae84515603bursa_e
bursate94111203bursate
cabbage1446983cabbage
carafe115416163ca_rafe
carate84734003ca_rate
carcase11312733carcase
carfare12310073carfare
carnages11312213carnages
carpale113414353carpale
carrack1548753carrack
carrageen1274013carrageen
carriages1238333carriages
cartages11313313cartages
cirrate92413493cirrate
cordage11310063cordage
corkage1438373corkage
corrade101111043corrade
corsage1039803corsage
courage10310993courage
curragh1344293curragh
damage10410773da_mage
drayage1234423drayage
enrage72715073_enrage
farragoes1344633farragoes
ferrate103014043ferrate
ferriage1245463ferriage
forage104617003_forage
garaged1039253ga_raged
garages9314113ga_rages
garbages1238183garbages
garbagey1543373garbagey
garbagy1444243garbagy
garrote8510103garrote
gavage1137193ga_vage
harborage1544653harborage
haulage1136913haulage
haylage1436443haylage
herbage1337003herbage
jarrah1636683jarra_h
jarrahs1735453jarrahs
karate105320923ka_rate
langrage10106033langrage
large65325463la_r_ge
larvae938843larva_e
laurae64011663laura_e
lavage1038263la_vage
layerage1244963layerage
macrame1338713macrame
manage93818903ma_nage
marge85328333ma_r_ge
margrave1444793margrave
marram10313883marra_m
marrams11310123marrams
marrano939423marrano
marriages1247383marriages
massage1039893massage
mirage92313653_mirage
moorage1038743moorage
narrated9310323narrated
narrater838723narrater
narrates8312763narrates
outrage82616893outrage
overage11514053overage
package16128013package
parade94720643pa_rade
parae76335703pa_ra_e
parbake1538353parbake
parge85831853pa_r_ge
parkade1437583parkade
parral85517533parra_l
parrals94414573parrals
parridge1254333parridge
partake1339643partake
passage1039803passage
pawnage1335873pawnage
peerage1089803peerage
portage103013643portage
rage55742353___rage
rampage1237453rampage
ravage1039303ra_vage
rearrange1045033rearrange
salvage1138193salvage
sarape84817573sa_rape
sarge65531133sa_r_ge
sausage847193sausage
savage10410173sa_vage
serfage1138403serfage
serrate73017543serrate
storage8310473storage
tagrag837043tagrag_
tagrags936123tagrags
tallage82712073tallage
tankage12257773tankage
tannage8209583tannage
targe65227093ta_r_ge
tarragon944663tarragon
tarre55825633tarr__e
tartare73012683tartare
tartrate899683tartrate
terrace93311833terrace
terrae62915203terra_e
terrane72814223terrane
triage72812893_triage
umbrage1236723umbrage
vantage11109893vantage
variate101316433variate
vorlage1136403vorlage
waftage14115323waftage
wantage11119623wantage
warfare1336733warfare
warpages1437053warpages
warragal1243863warragal
warrant10614243warrant
wastage11109253wastage
waterage1248663waterage
wattage1186983wattage
wharfage1842213wharfage
wordage1236503wordage
yardages1336203yardages

Search took 10 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.203880251.2
2DLD Change Limit1340272718.79615237.3
3Display Results2712710.0932914.0
 (SQL Overall)1786912719.09219653.7
 
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.