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 “burger” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

165 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
burger9402079(None) 
budger104617701budger
bugger104418721bugger
bulger94917351bulger
burgee97120591burgee
burgers103918571burgers
burgher1337001burgher
burier84324651burier
burker125221171burker
burler84723831burler
burner83819201burner
burrer83718471burrer
purger94717231purger
surger74320091surger
urger64116471_urger
auger64922472au_ger
badger105415072badger
bagger104619202bagger
banger94423632banger
barber104419322barber
barer74535802bar_er
barge85631022barge_
barged105822642barged
bargee94624442bargee
barges94528252barges
barker124822862barker
barter85525372barter
bergere1068912bergere
bigger104315062bigger
binger94923452binger
birder94915492birder
birler85715082birler
bludger11419562bludger
blunger104112012blunger
blurter9419832blurter
booger94816552booger
border94419972border
borer75131272bor_er
brier74527402b_rier
bucker145420462bucker
budder104314812budder
budge94619872budge_
budged114517232budged
budgers114314922budgers
budges104820122budges
budget104618112budget
buffer144512682buffer
bugged114318402bugged
buggers114315662buggers
buggery14367932buggery
buggier113611342buggier
bugler94717722bugler
bulge86419872bulge_
bulged105117122bulged
bulgers105215142bulgers
bulges95919322bulges
bulgier103911212bulgier
bulgur9387532bulgur
bummer124014102bummer
bumper123714342bumper
bunged105218792bunged
bungee96319772bungee
bungler104611482bungler
bunker124519372bunker
bunter85020382bunter
burbler114412422burbler
burden9412472burden
buret77444012bur_et
burg74930362burg__
burgees104915892burgees
burgeon1036432burgeon
burgess10409342burgess
burgh115216032burg_h
burghers1435632burghers
burghs12519922burghs
burglar1065532burglar
burgle94815862burgle
burgled115511422burgled
burgles105615962burgles
burgoo938932burgoo
burgs84924092burg_s
buried94822372buried
buriers94017192buriers
buries84633272buries
burke115122762burke_
burked135220882burked
burkers133716622burkers
burkes124421312burkes
burled94825382burled
burlers94120272burlers
burley114715752burley
burlier93514412burlier
burned95818962burned
burners94115672burners
burnet84326172burnet
burped116215502burped
burr65631232bur__r
burred95820722burred
burrers93814492burrers
burrier93613552burrier
bursar85413252bursar
burse75527252burse_
bursera936762bursera
burses84425512burses
burster9310292burster
busher114922202busher
busier85219722busier
busker125517832busker
buster84726492buster
butler84220032butler
butter84724232butter
buyer105013092bu_yer
buzzer16379112buzzer
curber104517052curber
curer75030752cur_er
curler85221322curler
curser84721472curser
curter85320082curter
forger104820772forger
furler93616402furler
gorger86116982gorger
gurge75419782gurge_
gurged95513362gurged
gurges84716862gurges
huger94914872hu_ger
hugger114713122hugger
hunger104015202hunger
hurler94717222hurler
hurter93915852hurter
judger154411442judger
larger74417512larger
luger65322082lu_ger
lugger83916552lugger
lunger75720422lunger
lurer54625312lur_er
lurker103613292lurker
merger95016472merger
mugger103914702mugger
murder93613782murder
murker123715242murker
nudger85111632nudger
nurser64314502nurser
purer75127902pur_er
purge85324602purge_
purged104918262purged
purgers104714002purgers
purges94421762purges
purser85020472purser
rugger84414512rugger
serger73819732serger
surer54833092sur_er
surfer93515882surfer
surge65027692surge_
surged84118882surged
surgers83517482surgers
surgery11319212surgery
surges73924592surges
tugger84013102tugger
turgor736862turgor
turner63914612turner
urge54722412_urge_
urged75316032_urged
urgers73313622_urgers
urges64619912_urges
verger104315692verger

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511652.72030349.6
3Display Results1651650.0463587.0
 (SQL Overall)1786911652.87662131.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.