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

257 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
bursera93676(None) 
berserk1334912berserk
burger94020792burger_
burgers103918572burgers
burier84324652burier_
buriers94017192buriers
burker125221172burker_
burkers133716622burkers
burler84723832burler_
burlers94120272burlers
burner83819202burner_
burners94115672burners
burrer83718472burrer_
burrers93814492burrers
bursa74921522burs__a
bursar85413252bursar_
bursars94510892bursars
bursary12397582bursary
burse75527252burse__
burseed1049502burseed
burses84425512burse_s
burster9310292burster_
bursters1038982bursters
curser84721472curser_
cursers94317162cursers
nurser64314502nurser_
nursers74311832nursers
nursery10396022nursery
purser85020472purser_
pursers93916092pursers
abuser85413683abu_ser_
abusers94710553abu_sers
aurora6411763aur_ora
barber104419323barber_
barbers114317503barbers
barer74535803bar_er_
barker124822863barker_
barkers134318513barkers
barter85525373barter_
barters94223033barters
baser74828923b_aser_
bergere1068913bergere
berseem1166463berseem
berserks1433993berserks
birder94915493birder_
birders103913263birders
birler85715083birler_
birlers93813003birlers
birse74517403birse__
birses84717733birse_s
blurter9419833blurter_
blurters10348373blurters
border94419973border_
borders104317533borders
borer75131273bor_er_
borers85122683bor_ers
bourse84414333bourse__
bourses94014303bourse_s
brier74527403b_rier_
briers85319733b_riers
briery114510773b_riery
bruiser9349573bruiser_
bruisers10307953bruisers
brusher123813003brusher_
brushers134210573brushers
brusker13437853brusker_
bucker145420463bucker_
buckers153517453buckers
buckra1436753bu_ckra
budder104314813budder_
budders113812103budders
budger104617703budger_
budgers114314923budgers
buffer144512683buffer_
buffers153310793buffers
bugbear1233953bugbear
bugger104418723bugger_
buggers114315663buggers
buggery14367933buggery
bugler94717723bugler_
buglers105115323buglers
bugseed1136173bugseed
bugsha1233823bugs_ha
bulger94917353bulger_
bulgers105215143bulgers
bummer124014103bummer_
bummers133712443bummers
bumper123714343bumper_
bumpers133912053bumpers
bunker124519373bunker_
bunkers133715953bunkers
bunter85020383bunter_
bunters94717123bunters
buqsha2032793buqs_ha
bura66139533bu___ra
burbler114412423burbler_
burblers12399263burblers
burden9412473burde_n
burdens1039713burdens
bureau8712523bur_eau
buret77444013bur_e_t
burets84321263bur_ets
burgee97120593burge_e
burgees104915893burgees
burgeon1036433burgeon
burgess10409343burgess
burgher1337003burgher_
burghers1435633burghers
burglar1065533burglar
buried94822373burie_d
buries84633273burie_s
burka114617693bur__ka
burke115122763burke__
burked135220883burke_d
burkes124421313burke_s
burled94825383burle_d
burlesk1335463burlesk
burley114715753burle_y
burleys12479673burleys
burlier93514413burlier_
burned95818963burne_d
burnet84326173burne_t
burnets93813263burnets
burped116215503burpe_d
burqa165013093bur__qa
burr65631233bur__r_
burred95820723burre_d
burrier93613553burrier_
burro75018493bur__ro
burrs74925653bur__rs
burry105221563bur__ry
burs65847423burs___
bursae84515603burs_ae
bursal84414823burs_al
bursarial1154003bursarial
bursas85318273burs_as
bursate94111203bursate
burseeds1134783burseeds
burst75332243burs__t
bursted1039423bursted
bursts85116243burs_ts
burweed1347823burweed
busbar1038453bu_sbar
bused85624493bu_se_d
buses75936013bu_se_s
busher114922203busher_
bushers124018803bushers
bushwa14105143bu_shwa
busier85219723busier_
busker125517833busker_
buskers133414093buskers
bussed94717053busse_d
busses85023383busse_s
buster84726493buster_
busters94724133busters
butler84220033butler_
butlers94518053butlers
butlery12369423butlery
butter84724233butter_
butters94521723butters
buttery124311193buttery
buyer105013093bu_yer_
buyers114511003bu_yers
buzzer16379113buzzer_
buzzers17347173buzzers
courser94114803courser_
coursers104412303coursers
curara83712203cur_ara
curber104517053curber_
curbers115514383curbers
curer75030753cur_er_
curers84923193cur_ers
curler85221323curler_
curlers94218073curlers
curse75829143curse__
cursed94321253curse_d
curses85328273curse_s
cursor84110293cursor_
cursors93910023cursors
cursory12406393cursory
curter85320083curter_
cusser86016093cusser_
cussers94213403cussers
dorser74819183dorser_
dorsers83516303dorsers
drosera836203drosera
durra65315793dur__ra
eureka1034483eur_eka
furler93616403furler_
furlers104214223furlers
fusser94813773fusser_
fussers104210813fussers
gerbera1034773gerbera
hurler94717223hurler_
hurlers103714323hurlers
hurter93915853hurter_
hurters103413643hurters
lurer54625313lur_er_
lurers64217493lur_ers
lurker103613293lurker_
lurkers113910083lurkers
lustra6358893lu_stra
murder93613783murder_
murders103311363murders
murker123715243murker_
murra74519083mur__ra
muser76024123mu_ser_
musers84719103mu_sers
nurse54420123nurse__
nursed74514663nurse_d
nurses63919353nurse_s
ourself1057453ourself
outsert72819513outsert
parser84822373parser_
parsers94118153parsers
puerpera1242853puerpera
pulser84215193pulser_
pulsers94213153pulsers
purer75127903pur_er_
purger94717233purger_
purgers104714003purgers
purpura1144793purpura
purse76028893purse__
pursed95220883purse_d
purses84826373purse_s
pursier94012753pursier_
pursuer9338893pursuer_
pursuers10376523pursuers
sera46141393___sera
subsea82610193subse_a
subsere9311443subsere
sudser73511283sudser_
sudsers83310423sudsers
surer54833093sur_er_
surfer93515883surfer_
surfers103614133surfers
surger74320093surger_
surgers83517483surgers
surgery11319213surgery
surra55521343sur__ra
terser67317823terser_
tessera736333tessera
tuatera756373tuatera
turner63914613turner_
turners73912893turners
turnery10357423turnery
tusser64615833tusser_
tussers74313563tussers
urea46528053_ur_e_a
urger64116473_urger_
urgers73313623_urgers
ursa44116903_urs__a
user45023003_u_ser_
users55817573_u_sers
verser94516963verser_
versers103813523versers
worser95117523worser_

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.1401276364.3
2DLD Change Limit1340272577.33018284.7
3Display Results2572570.0763381.6
 (SQL Overall)1786912577.54623680.2
 
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.