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 “busbars” 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
busbars113815(None) 
busbar1038451busbar_
bubals103513842bu_bals
bubbas94110702bubba_s
bugbears1333692bugbears
bulbar1039582bulbar_
bursars94510892bursars
busbies113011692busbies
busboys14325022busboys
bushers124018802bushers
buskers133414092buskers
bustard10389722bustard
bustards11308512bustards
busters94724132busters
disbars10310322disbars
durbars1077972durbars
hussars10326982hussars
lumbars11289762lumbars
tussars7359252tussars
unbars82113032_unbars
abusers94710553abus_ers
babas96325733b_aba_s
baobabs1044443baobabs
barbers114317503barbers
bars66564093___bars
bashaws15347713bashaws
bashers124820833bashers
bastard103012423bastard
bastards113310313bastards
basters94930303basters
bazaars18275883bazaars
bazars174613113b_azars
bears75739043b__ears
beggars11378223beggars
besmears1234543besmears
bestirs9311133bestirs
beswarm1445783beswarm
beswarms1544323beswarms
bezoars1836793bezoars
bibbers103911353bibbers
bisters93922613bisters
blears85116453b_lears
blubbers11408143blubbers
blushers133911293blushers
blusters104413893blusters
boars75229603b__oars
bobbers103614283bobbers
bombard1437333bombard
bombards1536493bombards
bombers134512593bombers
boxcars1834773boxcars
boyars115611983b_oyars
briars84814823b_riars
bribers114111503bribers
brushers134210573brushers
bubal94218213bu_ba_l
bubale104014623bu_bale
bubales113513343bu_bales
bubalis11359903bu_balis
bubba84311803bubba__
bubbies103913513bubbies
bubblers11448943bubblers
bubbles104315963bubbles
bubkes144612623bu_bkes
buboes104513993bu_boes
bubs86235503bu_b__s
bubus95115453bu_b_us
buckers153517453buckers
buckras1537343buckras
budders113812103budders
budgers114314923budgers
buffers153310793buffers
bugbane1255863bugbane
bugbanes1345153bugbanes
bugbear1233953bugbear_
buggers114315663buggers
buglers105115323buglers
bugshas1334513bugsha_s
buhrs104811243bu__hrs
bulbels11398013bulbels
bulbils11338333bulbils
bulbous1138293bulbous
bulbs96016933bulb__s
bulbuls11346783bulbuls
bulgers105215143bulgers
bulgurs10397113bulgurs
bullbats1255893bullbats
bulwark1645213bulwark
bulwarks1744133bulwarks
bumblers143710733bumblers
bumbles134016843bumbles
bumboats1445183bumboats
bummers133712443bummers
bumpers133912053bumpers
bunas75126573bu_na_s
bunkers133715953bunkers
bunters94717123bunters
bunyas11359433bunya_s
buqshas2143573buqsha_s
burans85019303bu_rans
buras74736303bu_ra_s
burblers12399263burblers
burbles114916803burbles
burbots1168673burbots
burbs95423493burb__s
bureaus979293bureaus
burgers103918573burgers
burglars1154593burglars
burials93612083burials
buriers94017193buriers
burkas124513803burka_s
burkers133716623burkers
burlaps1156253burlaps
burlers94120273burlers
burners94115673burners
burqas174410903burqa_s
burrers93814493burrers
burrs74925653bu__rrs
burs65847423bu___rs
bursar85413253bursar_
bursary12397583bursary
bursas85318273bursa_s
bursters1038983bursters
busboy13307443busb_oy
busby126113293busb__y
buses75936013bus__es
busgirl1044143busgirl
busgirls1142653busgirls
bushels124110713bushels
busher114922203busher_
bushes115226113bus_hes
bushwahs19113333bushwahs
bushwas15105613bushwas
busier85219723busier_
busies85525263bus_ies
busings103711223busings
busker125517833busker_
buskins133310943buskins
busks115521373bus__ks
busloads1144153busloads
busman10310253busma_n
buss65134913bus___s
busses85023383bus_ses
buster84726493buster_
bustics11810883bustics
bustiers103810053bustiers
bustlers104210613bustlers
bustles93816323bustles
busts75227693bus__ts
butlers94518053butlers
buttals938503buttals
butters94521723butters
buyback2045533buyback
buybacks2144783buybacks
buyers114511003bu_yers
buzzard1844273buzzard
buzzards1943613buzzards
buzzers17347173buzzers
casbahs1436463casbahs
costars94218013costars
cubers105318353cu_bers
cudbears1343483cudbears
cumbers134515413cumbers
curbers115514383curbers
cushats12288273cushats
cushaws15356293cushaws
cussers94213403cussers
custard10389973custard
custards11338393custards
darbars10510093darbars
debars94218043_debars
disbar938513disbar_
dubbers124011823dubbers
durbar968723durbar_
dusters84918363dusters
embars103812883_embars
escars83913133_escars
eskars10357593_eskars
eyebars1245333eyebars
fubar1039923fu_bar_
fulmars1246423fulmars
fussers104210813fussers
gasbags1135473gasbags
guars65021053gu__ars
guitars8116863guitars
gushers113512513gushers
husband1345653husband
husbands1444763husbands
huskers143510043huskers
hussar9317283hussar_
instars7411133instars
isbas71010403_isba_s
isobars936593isobars
jubas144614223ju_ba_s
jubbahs2143623jubbahs
jumbals18106533jumbals
justers143815733justers
kabars124513953_kabars
kasbahs1634363kasbahs
kbars114612603__kbars
kebars124112493_kebars
lascars979013lascars
lubbers113913723lubbers
lumbar103610593lumbar_
lumbers113815913lumbers
lunars65012813lu_nars
lusters73921443lusters
mimbars1397383mimbars
muggars11316643muggars
muscats1138933muscats
musers84719103mus_ers
mushers124016443mushers
mustard10359533mustard
mustards11297883mustards
musters94522513musters
numbats1137673numbats
numbers113711243numbers
ousters74122793ousters
outbark1339453outbark
outbarks1437833outbarks
outsoars838853outsoars
outwars10912793outwars
pulsars9358913pulsars
pushers123814503pushers
quasars1646903quasars
rebars84019833_rebars
rubbers113913193rubbers
rumbas102512013rumba_s
rushers103816103rushers
sambars115113843sambars
scars75433533__scars
sears54744913__sears
soars54732513__soars
spars75431543__spars
stars55836573__stars
subahs114512383su_bahs
subas74724073su_ba_s
subbass1138033subbass
subers85722643su_bers
sugars7312423su_gars
taskbars1452993taskbars
tsars56717113_ts_ars
tubas75119583tu_ba_s
tubbers113411253tubbers
tubers85017033tu_bers
turbans939563turbans
turbary1236383turbary
tuskers113710043tuskers
tussahs10335113tussahs
tussar6369543tussar_
tussers74313563tussers
tussors7388773tussors
tussurs7356393tussurs
umbers104215213_umbers
umbras1038643_umbras
unbans81912623_unbans
unbar71913613_unbar_
unbears998043_unbears
upbears1195423_upbears
upsoars985413upsoars
users55817573_us_ers
ushers94415533_ushers
usuals637783_usuals
vulgars11306533vulgars

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.406440125.6
2DLD Change Limit1340272647.09318895.7
3Display Results2642640.0932838.7
 (SQL Overall)1786912647.59223536.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.