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

253 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
bootleg1027663(None) 
bootlegs11325871bootlegs
boodle93215032boodle_
boodled113410932boodled
boodler103312002boodler
boodles103416042boodles
booklet132312642booklet
boomlet112412272boomlet
booted94822732boot_ed
bootee84323022boot_ee
bootees94114472bootees
bootie85421162bootie_
booties94124612booties
booting103821362booting
bootless103410982bootless
bottle84916072bottle_
bottled104611232bottled
bottler94211882bottler
bottles94216272bottles
bowleg12369182b_owleg
footle93914382footle_
footled113610762footled
footler104011872footler
footles103715712footles
rootle63214452rootle_
rootled83410532rootled
rootles73215632rootles
rootlet73015732rootlet
tootle62613812tootle_
tootled83511042tootled
tootler73511122tootler
tootles72915602tootles
battle85217863battle_
battled104213123battled
battler94113383battler
battles94517683battles
beetle8311673beetle_
beetled1038223beetled
beetler938043beetler
beetles9312083beetles
blotless10347153blotless
blotted103911833blotted
blotter94612853blotter
boated94221973boat_ed
boatel84314093boat_el
boatels93510233boatels
boater84622093boat_er
boating103721303boating
boatmen1146913boatmen
bobble94115143bobble_
bobbled113811833bobbled
bobbles104514913bobbles
bobsled12297153bobsled
boggle104511943boggle_
boggled12409003boggled
boggler113910083boggler
boggles113411823boggles
bogle85821683b_ogle_
bogles95020833b_ogles
boiled95020953b_oiled
boiler84319273b_oiler
boite74426323boit_e_
boites84322703boit_es
bole66448693b_o_le_
boles75448603b_o_les
bolled94722653b_olled
bolted94617803bolt_ed
bolter83920753bolt_er
bolting104416763bolting
boltless10338283boltless
bomblet13412263bomblet
boobed114514873boo_bed
boobie104015293boobie_
boobies113718203boobies
boobing123613913boobing
boodies103721443boodies
boodlers113710743boodlers
boodling121910243boodling
booed85127273boo__ed
booger94816553boo_ger
boogey124711523boo_gey
boogie93515993boogie_
boogied11379283boogied
boogies103719013boogies
booing94521643boo_ing
booked135319503boo_ked
booker124719193boo_ker
bookie123516003bookie_
bookies133819403bookies
booking143618383booking
booklets14247123booklets
bookmen15126263bookmen
boomed115318133boo_med
boomer104618513boo_mer
boomier113312183boomier
booming123716223booming
boomlets12246673boomlets
boonies93422483boonies
boonless10328353boonless
boosted104111983boosted
booster94314553booster
boosting113311053boosting
boot67759373boot___
bootable12179223bootable_
bootery1238983bootery
booth105522013boot__h
booths115313793boot_hs
bootlace1245403bootlace
bootlaces1345033bootlaces
bootlegged1551993bootlegged
bootlegger1452103bootlegger
bootlick1664643bootlick
boots75837973boot__s
booty106125913boot__y
booze164718913boo_ze_
boozed184813833boo_zed
boozer174815963boo_zer
boozes174916523boo_zes
boozier18349013boozier
boozing194012163boozing
bortzes1838223bortzes
botel75121863b_ot_el
botels84815803b_otels
bother115218063b_other
botonee9311833botonee
bottlers103810013bottlers
bottling11279143bottling
boucle103712783boucle_
boucles113113003boucles
boule74828043b_oule_
boules84925973b_oules
boulle84614613boulle_
boulles93114123boulles
boweled132810693boweled
bowled125018143b_owled
bowlegs13366823b_owlegs
bowler114217313b_owler
broiled103811423broiled
broiler92911753broiler
brooklet1456403brooklet
brothel12318193brothel
brother123311333brother
bustle84015483bustle_
bustled104011523bustled
bustler94012573bustler
bustles93816323bustles
butle75023103b_utle_
butled94818603b_utled
butler84220033b_utler
butles84423913b_utles
cooled95224593coo_led
cooler84824713coo_ler
cooter85128613coot_er
cootie84223093cootie_
cooties93725733cooties
dogleg936323_dogleg
doodle83212853doodle_
doodled10369463doodled
doodler93310153doodler
doodles93614163doodles
doolee73018953doo_lee
dottle74212503dottle_
dottles83912283dottles
fooled104317823foo_led
footage1148843footage
footbag1344553footbag
footed104418623foot_ed
footer94320773foot_er
footie94718143footie_
footier104115113footier
footies103721543footies
footing115017593footing
footlers113910793footlers
footless113710803footless
footling12239923footling
footmen1246583footmen
footslog1242663footslog
foozle18369203foozle_
foozled20346893foozled
foozler19397593foozler
foozles19329543foozles
foreleg1137743foreleg
hooklet142510813hooklet
hooted104422663hoot_ed
hooter94123933hoot_er
hootier104915353hootier
hooting113919883hooting
hostler103411023hostler
jostle13319863jostle_
jostled15267083jostled
jostler14288223jostler
jostles143411143jostles
looted74421113loot_ed
looter64222323loot_er
looting83019643looting
mooley11311633moo_ley
moonlet92413273moonlet
mooted94120373moot_ed
mooter83921093moot_er
mooting103019363mooting
motley1139383_motley
mottle84116053mottle_
mottled10409973mottled
mottler94410343mottler
mottles93415803mottles
noodle73212543noodle_
noodled9339923noodled
noodles83513193noodles
obole75917143obo_le_
oboles83815833obo_les
oodles73517183_oodles
ostler63312193_ostler
outbeg938733_outbeg
outled74020343_outled
outlet63728683_outlet
poodle93112043poodle_
poodles103013513poodles
pooled94619813poo_led
pooler83819843poo_ler
pottle84416103pottle_
pottles93816983pottles
proleg94612113pro_leg
rootage839053rootage
rooted75424003root_ed
rooter64926033root_er
rootier74915393rootier
rooting83522433rooting
rootless83910443rootless
rootlets8308653rootlets
rootling9269953rootling
sooted73922593soot_ed
soothe94214853soothe_
soothed113712743soothed
soother104215043soother
soothes103917113soothes
sootier73916613sootier
sooting82820963sooting
tooled74918903too_led
tooler63818613too_ler
tooted74620123toot_ed
tooter64420803toot_er
toothed113310243toothed
tooting83019423tooting
tootlers8289503tootlers
tootling9279523tootling
tootses72910773tootses
wooled103715503woo_led
woolen93111373woo_len
wooler93615873woo_ler
woolled1136643woolled
woollen1034723woollen
zooglea1733373zooglea
zootier163611173zootier

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.423422437.4
2DLD Change Limit1340272537.00019146.7
3Display Results2532530.0932720.4
 (SQL Overall)1786912537.51623774.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.