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

343 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
bursars9451089(None) 
bursar85413251bursar_
bursary12397581bursary
bursas85318271bursa_s
briars84814822b_riars
burans85019302bur_ans
buras74736302bur_a_s
bureaus979292bureaus
burgers103918572burgers
burglars1154592burglars
burials93612082burials
buriers94017192buriers
burkas124513802burka_s
burkers133716622burkers
burlaps1156252burlaps
burlers94120272burlers
burners94115672burners
burqas174410902burqa_s
burrers93814492burrers
burrs74925652bur__rs
bursa74921522bursa__
bursae84515602bursa_e
bursal84414822bursa_l
bursaries1157642bursaries
bursate94111202bursate
bursera936762bursera
burses84425512burs_es
bursters1038982bursters
bursts85116242burs_ts
busbars1138152busbars
cursers94317162cursers
cursors93910022cursors
durbars1077972durbars
hussars10326982hussars
nursers74311832nursers
pulsars9358912pulsars
pursers93916092pursers
quasars1646902quasars
sarsars73512142sarsars
tussars7359252tussars
abusers94710553abu_sers
arrears738843arrears
aurar54420253aur_ar_
auras55932563aur_a_s
auroras7311703auroras
balsams11579013balsams
balsas86417523balsa_s
barbers114317503barbers
barcas101016603barca_s
baresark1443883baresark
baresarks1543433baresarks
barkers134318513barkers
barosaurs1143813barosaurs
bars66564093b___ars
barters94223033barters
barware12610703barware
barwares13610093barwares
bazaars18275883bazaars
bazars174613113b_azars
bears75739043b__ears
beggars11378223beggars
berserk1334913berserk
berserks1433993berserks
bezoars1836793bezoars
birders103913263birders
birlers93813003birlers
birrs74917103bir__rs
birses84717733birs_es
blears85116453b_lears
blurters10348373blurters
boars75229603b__oars
borals86721913bor_als
boras75938303bor_a_s
borders104317533borders
boreas85421733borea_s
borers85122683bor_ers
borshts1266543borshts
borstals1037463borstals
bourses94014303bours_es
boursins1037513boursins
boxcars1834773boxcars
boyars115611983b_oyars
brads85528293b_r_ads
braes75735053b_r_aes
brags85625103b_r_ags
brans75437433b_r_ans
bras65746453b_r_a_s
brass75428023b_r_ass
brats75336013b_r_ats
braws106425193b_r_aws
brays106723113b_r_ays
breads95419203b_reads
breaks124816423b_reaks
breams104815043b_reams
briar75718153b_riar_
briard94311293b_riard
briards10398553b_riards
briary114912003b_riary
briers85319733b_riers
broads94515153b_roads
bruisers10307953bruisers
brushers134210573brushers
brushes124014663brushes
bubals103513843bu_bals
bubbas94110703bubba_s
buckers153517453buckers
buckras1537343buckras
bucksaws1943853bucksaws
budders113812103budders
budgers114314923budgers
buffers153310793buffers
bugbears1333693bugbears
buggers114315663buggers
buglers105115323buglers
bugshas1334513bugshas
buhrs104811243bu__hrs
bulbar1039583bulbar_
bulgers105215143bulgers
bulgurs10397113bulgurs
bulwark1645213bulwark
bulwarks1744133bulwarks
bummers133712443bummers
bumpers133912053bumpers
bunas75126573bu_na_s
bunkers133715953bunkers
bunters94717123bunters
bunyas11359433bunya_s
buqshas2143573buqshas
bura66139533bur_a__
buran75225303bur_a_n
burblers12399263burblers
burbles114916803burbles
burbots1168673burbots
burbs95423493bur__bs
burdens1039713burdens
burdies104117563burdies
burds84626063bur__ds
bureau8712523burea_u
bureaux1664593bureaux
burets84321263bur_ets
burgage1136633burgage
burgages1236483burgages
burgees104915893burgees
burger94020793burger_
burgess10409343burgess
burghers1435633burghers
burghs12519923bur_ghs
burglar1065533burglar_
burglary1473133burglary
burgles105615963burgles
burgoos1037123burgoos
burgs84924093bur__gs
burial84117623buria_l
burier84324653burier_
buries84633273bur_ies
burins84221893bur_ins
burka114617693burka__
burker125221173burker_
burkes124421313bur_kes
burlap1098353burla_p
burler84723833burler_
burleys12479673burleys
burls74228853bur__ls
burner83819203burner_
burnets93813263burnets
burnies94017823burnies
burnous938823burnous
burns74926783bur__ns
burps94220173bur__ps
burqa165013093burqa__
burr65631233bur__r_
burrer83718473burrer_
burro75018493bur__ro
burros85114993bur_ros
burrows12399093burrows
burry105221563bur__ry
burs65847423bu___rs
bursarial1154003bursarial
burse75527253burs__e
burseed1049503burseed
burseeds1134783burseeds
bursitis1045033bursitis
burst75332243burs__t
bursted1039423bursted
burster9310293burster
burtons9310853burtons
busbar1038453busbar_
buses75936013bu_s_es
bushers124018803bushers
bushes115226113bu_shes
busies85525263bu_sies
buskers133414093buskers
busks115521373bu_s_ks
buss65134913bu_s__s
busses85023383bu_sses
bustard10389723bustard
bustards11308513bustards
busters94724133busters
busts75227693bu_s_ts
butlers94518053butlers
buttals938503buttals
butters94521723butters
buyers114511003bu_yers
buzzard1844273buzzard
buzzards1943613buzzards
buzzers17347173buzzers
byroads1335293byroads
caesars9410733caesars
corsacs1139013corsacs
corsairs1046873corsairs
coursers104412303coursers
curara83712203cur_ara
curaras93911953cur_aras
curare84916953cur_are
curares94916853cur_ares
curari84414403cur_ari
curaris94114773cur_aris
curbers115514383curbers
curers84923193cur_ers
curlers94218073curlers
currans9310613currans
currs75624393cur__rs
curser84721473curser_
curses85328273curs_es
cursor84110293cursor_
cursory12406393cursory
curtals93111623curtals
cussers94213403cussers
darbars10510093darbars
dorsals84110843dorsals
dorsers83516303dorsers
drears74614253_drears
duras65727733dur_a_s
durbar968723durbar_
durians839573durians
durras74713373durra_s
durrs65519993dur__rs
friars93812093_friars
fulmars1246423fulmars
furans94515953fur_ans
furlers104214223furlers
furors9310953fur_ors
fussers104210813fussers
guars65021053gu__ars
guisard954203guisard
guisards1043603guisards
guitars8116863guitars
gurnard944773gurnard
gurnards1043633gurnards
gurshes112210033gurshes
hurlers103714323hurlers
hurrahs13336773hurrahs
hurrays13386153hurrays
hursts97213093hurs_ts
hurters103413643hurters
hussar9317283hussar_
jurats134213203jur_ats
jurors1338283jur_ors
kurgans12145653kurgans
kurtas10349883kurta_s
lumbars11289763lumbars
lunars65012813lu_nars
lurdans837073lurdans
lurers64217493lur_ers
lurkers113910083lurkers
mortars93411523mortars
muggars11316643muggars
murals84016763mur_als
muras75329583mur_a_s
murders103311363murders
murmurs1134523murmurs
murras84916013murra_s
murrs75521303mur__rs
musers84719103mu_sers
nurser64314503nurser_
nursery10396023nursery
nurses63919353nurs_es
ourari63413543our_ari
ouraris73512933our_aris
outroars838923outroars
outsays102710403outsays
outsoars838853outsoars
outwars10912793outwars
parsers94118153parsers
pulsar8329363pulsar_
pulsers94213153pulsers
purdahs13285483purdahs
purdas92612263purda_s
purgers104714003purgers
purrs75320433pur__rs
purser85020473purser_
purses84826373purs_es
pursuers10376523pursuers
pursues94111373pursues
quasar1536833quasar_
qurshes19228573qurshes
rears54739653__rears
roars55622243__roars
sansars73313913sansars
sardars83112903sardars
sarsar63011843sarsar_
sirdars8228213sirdars
sudsers83310423sudsers
sugars7312423su_gars
surahs94515543sur_ahs
suras55336333sur_a_s
surfers103614133surfers
surgers83517483surgers
surpass938283surpass
surras65919533surra_s
tarsals72512603tarsals
tartars73313403tartars
tsars56717113__tsars
turbans939563turbans
turbary1236383turbary
turgors836833turgors
turners73912893turners
tussahs10335113tussahs
tussar6369543tussar_
tussers74313563tussers
tussors7388773tussors
tussurs7356393tussurs
unbars82113033_unbars
unsays9399543_unsays
uprears9107493uprears
uproars986453uproars
upsoars985413_upsoars
urare56322553_ur_are
urares64519093_ur_ares
urari54619963_ur_ari
uraris63817273_ur_aris
urases63723563_urases
ureas55826013_urea_s
urgers73313623_urgers
urials64415193_urials
ursa44116913_ursa__
ursae55214453_ursa_e
ursids737823_ursids
users55817573_u_sers
versers103813523versers
vulgars11306533vulgars
warsaws1335763warsaws
wursts95211163wurs_ts

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 Limit1340273436.75019855.9
3Display Results3433430.1103118.2
 (SQL Overall)1786913437.26624592.8
 
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.