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

214 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
barware1261070(None) 
barwares13610091barwares
aware86420022_a_ware
bakeware1745482bakeware
barbate11314542barbate
barbwire1543862barbwire
barrage10710842barrage
barre75929542bar__re
beware11313712b_eware
carfare12310072carfare
hardware1546282hardware
tartare73012682tartare
warfare1336732warfare
abrade9313053abr_ade
aglare7312423_aglare
airfare1047243airfare
airward1148133airward
airwave1344433airwave
arame75026623_ar_ame
arcade91013643_arcade
arcane81216743_arcane
areae55229743_area_e
ariary94114203_ariary
armure8710133_armure
aswarm11107913_aswarm
awake125014783_a_wake
award97118043_a_ward
baccae12119703bacca_e
baccara1347143baccara
baccate131011263baccate
backward2048103backward
baggage1235633baggage
bagworm1566343bagworm
bakewares1845043bakewares
ballade104012563ballade
bandage11311023bandage
bandore10611633bandore
barbal104016663barba_l
barbaric1446363barbaric
barbarize2246243barbarize
barbe95328283bar__be
barber104419323barber_
barbered13259543barbered
barbers114317503barbers
barbie105018353bar_bie
barbule1137943barbule
barbwires1643643barbwires
barca91319433barca__
barcarole1343773barcarole
barcas101016603barca_s
barde85330773bar__de
bare65460523b___are
barege94713543bar_ege
barer74535803bar_er_
baresark1443883baresark
bargain1079063bargain
barge85631023bar__ge
bargee94624443bar_gee
barite84224813bar_ite
barker124822863barker_
barkers134318513barkers
barkier133814483barkier
barmaid1238193barmaid
barman103519703barma_n
barmie103816393bar_mie
barmier114313043barmier
barnacle1245943barnacle
barnier93213673barnier
barnyard1443783barnyard
baronage1147073baronage
baronne938263baronne
baroque1835103baroque
barque17239553bar_que
barrable1249243barrable
barrack1538253barrack
barraged1297683barraged
barrages11711083barrages
barrater10310143barrater
barratry13114473barratry
barred95725793bar__red
barrel84517873bar__rel
barren85317613bar__ren
barres84427543bar__res
barret84930483bar__ret
barrier94017733barrier
barter85525373barter_
bartered113113013bartered
barterer102711633barterer
barters94223033barters
barye105021493bar__ye
baryte115312883bar_yte
bastard103012423bastard
bawbee132714233ba_wbee
bawdry15516463ba_wdry
bawler114315053ba_wler
bawtie113812143ba_wtie
bayard124411663ba_yard
bazaar17306403bazaar_
bazaars18275883bazaars
bazar163816003ba_zar_
bazars174613113ba_zars
bedward1497473bedward
bedwarf16106463bedwarf
berake124216083ber_ake
berate84729023ber_ate
bereave1258353bereave
bergere1068913bergere
beswarm1445773beswarm
bewared13310113b_ewared
bewares12313373b_ewares
blare75826233b__lare
bloatware1442173bloatware
borage93917013bor_age
borane84620213bor_ane
borate85026153bor_ate
bordure1035773bordure
brace95629273b_r_ace
brae65639113b_r_a_e
brake116025343b_r_ake
brassware1463813brassware
brave104925503b_r_ave
bravure1254393bravure
brawer114216333brawer_
brawler124310233brawler
brawlie12198153brawlie
braze165423453b_r_aze
brewage1347183brewage
briar75718153b_riar_
briard94311293b_riard
briars84814823b_riars
briary114912003b_riary
bulwark1645213bulwark
burgage1136633burgage
bursae84515603bursa_e
bursar85413253bursar_
bursars94510893bursars
bursary12397583bursary
bursate94111203bursate
caneware1347803caneware
carafe115416163car_afe
carate84734003car_ate
carbarn1139453carbarn
carcase11312733carcase
carfares13310323carfares
carnage10311743carnage
carpale113414353carpale
cartage10312593cartage
carwash1535993carwash
caviare1238373caviare
clayware1643933clayware
curare84916953cur_are
darbar959953darbar_
darbars10510093darbars
daycare1355093daycare
daymare1375633daymare
earmark1345653earmark
earwax1664733earwa_x
earwaxes1844703earwaxes
earworm1238733earworm
fanfare1336673fanfare
firmware1643963firmware
flatware1444883flatware
forbare122310513forbare
forward1438293forward
garage8314513gar_age
garbage1138053garbage
hardwares1646563hardwares
hardwire1544623hardwire
hayward1736413hayward
haywire1644743haywire
karate105320923kar_ate
larvae938843larva_e
manward1349093manward
narrate7313493narrate
narwal938943narwa_l
narwals1036983narwals
narwhale1443223narwhale
parade94720643par_ade
parae76335703par_a_e
parbake1538353parbake
parkade1437583parkade
partake1339643partake
parure8312523par_ure
rare45348433__r_are
rearward1245783rearward
redware1139353redware
sarape84817573sar_ape
sardar73013173sardar_
sardars83112903sardars
sarsar63011843sarsar_
sarsars73512143sarsars
seaware1049623seaware
shareware1544323shareware
sware85828213__sware
tarre55825633tar__re
tartar63214753tartar_
tartars73313403tartars
teaware1048143teaware
tinware1038593tinware
unaware1038033unaware
urare56322553_ur_are
vanward1456943vanward
vaporware1752083vaporware
variate101316433variate
vaward13498723va_ward
ware76254723___ware
warfares1436683warfares
warpage1336403warpage
warwork1757573warwork
warworn1357343warworn
wayward1736053wayward
wetware1335793wetware
yardage1235733yardage
yardarm13114533yardarm

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 Limit1340272147.01619103.1
3Display Results2142140.0802675.0
 (SQL Overall)1786912147.25224640.2
 
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.