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

372 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
burgling1223930(None) 
bugling113615341bu_gling
bungling12269541bungling
burbling13249421burbling
burling104421131bur_ling
gurgling11267321gurgling
argling92812732_argling
barging114018482barg_ing
birling104317052bir_ling
boggling13257162boggling
bubbling12248222bubbling
buckling17259112buckling
budging124313022budg_ing
bugging123515182bu_gging
bulging113514212bulg_ing
bulling104324792bu_lling
bumbling15249762bumbling
bundling12219702bundling
bunging113616502bung_ing
bunglings13235212bunglings
burking143716322bur_king
burning104215502bur_ning
burping124012942bur_ping
burring104016992bur_ring
bursting1138702bursting
burying133413912bur_ying
bustling112110062bustling
butling103516812bu_tling
byrling13337372byr_ling
curdling12228892curdling
curling104320182cur_ling
fugling124212512fu_gling
furling114016562fur_ling
gargling11239202gargling
guggling10236352guggling
gurging102910112gurg_ing
hurdling13288012hurdling
hurling113616412hur_ling
hurtling12318312hurtling
juggling18225602juggling
nurling84215822nur_ling
nursling997602nursling
pungling12228662pungling
purfling1467762purfling
purging113314182purg_ing
purling103620292pur_ling
purpling1368542purpling
surging93115432surg_ing
turtling9238832turtling
urging83413122_urg_ing
angling92816043_angling
arguing9248733_arguing
aureoling1045873aureoling
babbling12228693babbling
badging123712793badg_ing
baffling1756053baffling
bagging123316983b_agging
bailing103723523b_ailing
baling94829693b__aling
balling104424763b_alling
banging114019863bang_ing
bantling112611993bantling
barbing123716993bar_bing
barding113822893bar_ding
barfing134615093bar_fing
bargain1079063bargain_
bargains1178643bargains
baring95135853bar__ing
barking144724183bar_king
barning104320353bar_ning
barreling1238043barreling
barring104021593bar_ring
battling113110493battling
bawling133813863b_awling
beetling1139283beetling
begging123012653b_egging
belling103825073b_elling
beraking153612963beraking
berating113220753berating
beriming13310453beriming
berlin83116373ber_lin_
berline93716853ber_line
berlins93216013ber_lins
berming123614823ber_ming
berrying14137363berrying
berthing14209593berthing
beryline1337083beryline
beveling143011033beveling
bigging122815883b_igging
bilging114212683bilg_ing
billing103823853b_illing
bingeing12237643bingeing
binging113619383bing_ing
birching16328463birching
birding114014923bir_ding
birlings11359613bir_lings
birring103713063bir_ring
birthing14338433birthing
blagging13319163blagging
blogging13369013blogging
bludging13297463bludg_ing
blunging12328413blung_ing
blurbing13326503blur_bing
blurring11277233blur_ring
blurting11258773blur_ting
bobbling12238643bobbling
bogging123615753b_ogging
boiling103819673b_oiling
bolling103820883b_olling
bonging113316373bong_ing
boodling121910243boodling
boogying1535373boogying
borating113414503borating
boring94724873bor__ing
borking144716173bor_king
bottling11279143bottling
boweling143410683boweling
bowling133916493b_owling
bracing123817613b_racing
bragging13359333bragging
brailing113514793brailing
braking143917703b_raking
braving133714613b_raving
brawling143210043brawling
braying134416313b_raying
brazing193715113b_razing
brewing133411153b_rewing
bribing123111043b_ribing
bridling122610583bridling
bring85528503b_r__ing
brining103216473b_rining
brisling112410843brisling
broiling113112013broiling
broking143514823b_roking
bruising11279143bruising
bruiting11259973bruiting
brushing14359963brushing
bruting102612993b_ruting
bruxing17236823b_ruxing
bubaline1247163bubaline
bucking163617573bu_cking
budding123712403bu_dding
buddying16274793buddying
budgeting1444023budgeting
buffing163411393bu_ffing
buggering1435193buggering
building1237503building
bulking143815123bu_lking
bullring11388423bullring
bullying14329293bullying
bumblings16194753bumblings
bumming143410783bu_mming
bumping143812493bu_mping
bunching163410703bunching
buncoing13337813buncoing
bundlings13235563bundlings
bunglingly1743393bunglingly
bunking144016193bu_nking
bunkoing15355643bunkoing
bunting103718833bu_nting
buntline10198063buntline
buoying13379953bu_oying
burblier1255603burblier
burdening1335543burdening
burgeon1036433burgeon_
burgeoning1443103burgeoning
burgeons1146053burgeons
burglar1065533burgl_ar
burglars1154593burglars
burglary1473133burglary
burgle94815863burgl__e
burgled115511423burgl_ed
burgles105615963burgl_es
burin75626063bur__in_
burins84221893bur__ins
burlier93514413bur_lier
burlily1237713bur_lily
burnings11387623bur_nings
burrowing1544473burrowing
busheling1535503busheling
bushing134018583bu_shing
busing96420593bu__sing
busking144116573bu_sking
bussing103614623bu_ssing
busting104221793bu_sting
bustline10208843bustline
busying134211993bu_sying
butting103519283bu_tting
buying124213833bu__ying
buzzing18186543bu_zzing
carling103727063car_ling
caroling113317003caroling
circling1338423circling
cuddling13287653cuddling
cudgeling1443663cudgeling
culling103921303cu_lling
cupeling1338863cupeling
curating11314293curating
curbing123814023cur_bing
curding113515133cur_ding
curing94824783cur__ing
curlings114110383cur_lings
curring103616843cur_ring
currying14196483currying
cursing104217033cur_sing
curving133912103cur_ving
cuttling1138203cuttling
daggling12237063daggling
dangling112611233dangling
darkling1437483darkling
darling93418363dar_ling
dartling1039563dartling
dirling93316073dir_ling
drugging12326443drugging
duckling16247703duckling
dueling93614543du_eling
duelling103410733duelling
dulling93418273du_lling
dumpling14217893dumpling
dunging103012623dung_ing
during84419403dur__ing
durning93511733dur_ning
eagling91113603_eagling
feruling1258873feruling
forging124114723forg_ing
forgoing1366853forgoing
frugging14317053frugging
fuddling14247153fuddling
fudging133310013fudg_ing
fueling113615133fu_eling
fuelling123410153fuelling
fugging133912913fu_gging
fuguing12337483fu_guing
fulling114019703fu_lling
fumbling16208163fumbling
furlong11295413fur_long
furring114013133fur_ring
gaggling10217463gaggling
gangling112411403gangling
garbling12249453garbling
giggling10227043giggling
girdling1146823girdling
goggling10246283goggling
gorging102611363gorg_ing
grueling1078273grueling
guiling93214213gu_iling
gulling94019563gu_lling
guttling1037293guttling
guzzling18225063guzzling
haggling14227273haggling
higgling14217163higgling
hireling121210993hireling
hirpling1467223hirpling
hirsling1277543hirsling
huddling14227293huddling
hugging132710633hu_gging
hulling113619013hu_lling
humbling16208673humbling
hurlings12388213hur_lings
hurrying15145523hurrying
hurting113914033hur_ting
hustling12228793hustling
jangling17249623jangling
jiggling18226363jiggling
jingling17188573jingling
joggling18215573joggling
judging17337933judg_ing
jugging172910723ju_gging
jugglings19212723jugglings
jumbling20217233jumbling
jurying18337763jur_ying
justling16207253justling
kegling13309363_kegling
knurling1344943knur_ling
laureling1035643laureling
lordling1077743lordling
lugeing9359113lu_geing
lugging104114353lu_gging
luging83915293lu_g_ing
lulling83616803lu_lling
lunging93714213lung_ing
lurching14277333lurching
luring73820753lur__ing
lurking123710853lur_king
mangling122312623mangling
marbling13179883marbling
marling103322763mar_ling
merging112711753merg_ing
mingling122010933mingling
muddling13268593muddling
muffling1765503muffling
mugging122711793mu_gging
muling93519883mu__ling
mulling103819993mu_lling
mumbling15198533mumbling
muring95120373mur__ing
muscling1337853muscling
muzzling19245733muzzling
niggling11227443niggling
nudging10328693nudg_ing
nulling83818063nu_lling
nursing84012553nur_sing
nurslings1043733nurslings
nuzzling17224773nuzzling
ogling83211883__ogling
outgoing1039273outgoing
parging113318603parg_ing
parling103823763par_ling
paroling113316213paroling
periling11316863periling
puddling13218033puddling
pugging122912543pu_gging
puling93621403pu__ling
pulling103821073pu_lling
purblind1345163purblind
pureeing1137273pureeing
purflings1554093purflings
purgings12347293purg_ings
purlin83615863pur_lin_
purline93516533pur_line
purlings113910283pur_lings
purlins93415423pur_lins
purring104515823pur_ring
pursing103715553pur_sing
pursuing1146233pursuing
puzzling19225393puzzling
quailing1838403quailing
quelling18259793quelling
quilling182510003quilling
quisling18218063quisling
ridgling11258203ridgling
riling74227973__riling
rubbling13238073rubbling
ruckling15258573ruckling
ruddling11228553ruddling
ruffling1546093ruffling
rugging102512763ru_gging
ruling73219553__ruling
rumbling131910103rumbling
rumpling13178763rumpling
runkling13217613runkling
rustling9249983rustling
serging93416673serg_ing
singling101913003singling
smuggling1433243smuggling
snuggling1243473snuggling
suckling152410023suckling
sughing12359713su_ghing
suppling1359043suppling
surfing112914483sur_fing
tangling101712533tangling
tingling102210803tingling
tirling83315733tir_ling
toggling11206483toggling
tugging102611233tu_gging
tumbling13219293tumbling
turfing113010053tur_fing
turning83713183tur_ning
turtlings10184873turtlings
tussling935823tussling
ungluing1035863_ungluing
unsling8313643_unsling
upfling1337093_upfling
upgoing1135353_upgoing
urping93914053_ur_ping
verging123812303verg_ing
waggling14197063waggling
wangling132310993wangling
warbling14198943warbling
warsling12198593warsling
wiggling14217293wiggling
youngling1463273youngling

Search took 10 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623728.79616616.9
3Display Results3723720.1562384.6
 (SQL Overall)1786913729.10819619.1
 
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.