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

189 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
barwares1361009(None) 
barware12610701barware_
bakewares1845042bakewares
barbwires1643642barbwires
barrages11711082barrages
barres84427542bar__res
bewares12313372b_ewares
carfares13310322carfares
earwaxes1844702earwaxes
hardwares1646562hardwares
warfares1436682warfares
abrades10312073abr_ades
airfares1146693airfares
airwaves1444723airwaves
arames84622573_ar_ames
arbores94016033_arbores
arcades101113193_arcades
armures9510273_armures
arrases71214543_arrases
awakes135012473_a_wakes
awards107113453_a_wards
aware86420023_a_ware_
baases85218013ba__ases
baccaras1446913baccaras
backwards2147463backwards
baggages1335443baggages
bagworms1645213bagworms
bakeware1745483bakeware_
balases93815433ba_lases
ballades114211643ballades
bandages12310633bandages
bandores11311603bandores
banjaxes2443393banjaxes
barbaric1446373barbaric
barbarism1545963barbarism
barbarizes2345873barbarizes
barbarous1345623barbarous
barbate11314543barbate_
barbered13259543barbered
barbers114317503barber_s
barbes104526233bar__bes
barbies114519593bar_bies
barbules1238043barbules
barbwire1543863barbwire_
barcaroles1443803barcaroles
barcas101016603barca__s
bardes95026933bar__des
bareges105212033bar_eges
bares75457133b___ares
baresarks1543433baresarks
barflies1338303barflies
bargains1178643bargains
bargees105415873bar_gees
barges94528253bar__ges
barites94322333bar_ites
barkers134318513barker_s
barmaids1345943barmaids
barnacles1355333barnacles
barnyards1543493barnyards
baronages1247153baronages
baronies10315023baronies
baronnes1038553baronnes
baroques1934863baroques
barques18259643bar_ques
barracks1636883barracks
barrage10710843barrage_
barraged1297683barraged
barrater10310143barrater
barraters1138043barraters
barratries1245733barratries
barre75929543bar__re_
barred95725793bar__red
barrel84517873bar__rel
barrels94514363bar__rels
barren85317613bar__ren
barrens94414323bar__rens
barret84930483bar__ret
barrets94917103bar__rets
barriers104311883barriers
bartered113113013bartered
barterer102711633barterer
barterers11269633barterers
barters94223033barter_s
baryes116218503bar__yes
barytes124611153bar_ytes
bastards113310313bastards
bawbees14337243ba_wbees
bawdies134613393ba_wdies
bawdries14136843ba_wdries
bawlers124412733ba_wlers
bawties124214313ba_wties
bayards13379683ba_yards
bazaars18275883bazaar_s
bazars174613113ba_zar_s
bedwards1596393bedwards
bedwarfs17113583bedwarfs
berakes134815773ber_akes
berates94126873ber_ates
bereaves1338273bereaves
bergeres1189113bergeres
beswarms1544323beswarms
beware11313713b_eware_
bewared13310113b_ewared
blares85021633b__lares
bloatwares1552193bloatwares
boraces113716853bor_aces
borages103917163bor_ages
boranes93720403bor_anes
borates94823013bor_ates
boraxes163511633bor_axes
bordures1136173bordures
boreases10310253boreases
braces108427773b_r_aces
braes75735053b_r_a_es
brakes124923123b_r_akes
brasswares1583733brasswares
braves115524083b_r_aves
brawlers13408643brawlers
brazes175522193b_r_azes
brewages1436383brewages
briards10398553b_riards
briars84814823b_riar_s
bulwarks1744133bulwarks
burgages1236483burgages
bursaries1157643bursaries
bursars94510893bursar_s
canewares1447363canewares
carafes125015703car_afes
carates95630613car_ates
carbarns1238563carbarns
carcases12313093carcases
carfare12310073carfare_
carnages11312213carnages
cartages11313313cartages
carwashes1745783carwashes
caviares1337993caviares
claywares1743463claywares
curares94916853cur_ares
darbars10510093darbar_s
daycares1454803daycares
daymares1445333daymares
earmarks1444793earmarks
earworms1346783earworms
fanfares1436773fanfares
firmwares1743853firmwares
flatwares1544773flatwares
forwards1537043forwards
garages9314113gar_ages
garbages1238183garbages
hardware1546283hardware_
hardwires1644643hardwires
haywards1845873haywards
haywires1744043haywires
karates115617473kar_ates
manwards1447613manwards
narrates8312763narrates
narwals1036983narwa_ls
narwhales1543163narwhales
parades104121463par_ades
parbakes1638343parbakes
parkades1538273parkades
partakes1449923partakes
parures9512693par_ures
paxwaxes1942053paxwaxes
rares55247443__r_ares
rearwards1344803rearwards
redwares1239053redwares
sarapes94617753sar_apes
sardars83112903sardar_s
sarsars73512143sarsar_s
seawares1139333seawares
sharewares1644033sharewares
tarres64723043tar__res
tartare73012683tartare_
tartars73313403tartar_s
teawares1148083teawares
tinwares1137913tinwares
unawares1137053unawares
urares64519093_ur_ares
vaporwares1852133vaporwares
variates111214983variates
vawards14457573va_wards
wares88250583___wares
warfare1336733warfare_
warpages1437053warpages
warworks1877063warworks
wetwares1445953wetwares
yardages1336203yardages
yardarms14123333yardarms

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.423422437.4
2DLD Change Limit1461621896.72021750.3
3Display Results1891890.0762486.8
 (SQL Overall)1786911897.21924752.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.