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

303 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
botfly143609(None) 
barfly14339652barfly
blowfly1843242blowfly
bodily12310992bodily
boldly12399422boldly
botany1139262botany
botchy16537822botchy
botel75121862botel_
botels84815802botels
bothy136713962bot_hy
bottle84916072bottle
boxily1877842boxily
hotly115815482hot_ly
outfly1238272outfly
softly12457762softly
aloofly1343623aloofly
aptly105111813apt_ly
artily92814713artily
badly114918763b_adly
baffle14399873baffle
baffy165511923b_affy
baldly12479833baldly
bally105530103b_ally
barely114716793barely
basely114412313basely
bassly114610073bassly
batboy1387533batboy
battle85217863battle
batty105422243bat_ty
beefily1535613beefily
beefy135313833beef_y
belfry1435073belfry
belly104625493b_elly
betel74419903betel_
betels84515063betels
betony114211583betony
betray111511443betray
bialy105119323b_ialy
biffy164711133b_iffy
bigly114814753b_igly
billy105525363b_illy
bitchy16479203bitchy
bitsy104511303bit_sy
bitty106119173bit_ty
blotchy17293973blotchy
blotty11178343blot_ty
bluely113310083bluely
bluffly1833433bluffly
boatel84314093boatel_
boatels93510233boatels
boatful1236283boatful
boatfuls1344823boatfuls
bobble94115143bobble
bobby114814663bo_bby
body107425683bo__dy
boff124727333bo_f_f
boffed15369483boffed
boffin14359053boffin
boffo136010373bo_ffo
boffola1543463boffola
boffos14568193boffos
boffs134915503bo_ffs
bogey115220233bo_gey
boggle104511943boggle
boggy126116073bo_ggy
bogle85821683bo_gle
bogusly1343893bogusly
bogy106426193bo__gy
boil66335183bo_il_
boils75427193bo_ils
bola66035563bo__la
bold75432813bo__ld
bole66448693bo__le
boll65634753bo__ll
bolls75531313bo_lls
bolo65535953bo__lo
bolshy1444883bolshy
bolt66254173bo__lt
boney105227313bo_ney
bonnily1236873bonnily
bonny105816623bo_nny
bony96732083bo__ny
booby125319513bo_oby
boodle93215033boodle
boody115420403bo_ody
boogey124711523boogey
boogy114518323bo_ogy
boomy125421823bo_omy
bootery1238983bootery
booty106125913bo_oty
boozily2135623boozily
boozy194917063bo_ozy
boral75831703boral_
borals86721913borals
borty105522833bo_rty
bosky145612393bo_sky
bosomy13509033bosomy
bossily1237563bossily
bossy105515973bo_ssy
bot59680403bot___
bota66236503bot__a
botas75328783bot_as
botch126717453bot_ch
botchily1864373botchily
botflies1336733botflies
both96533433bot__h
bother115218063bother
bots66453953bot__s
bott66548573bot__t
bottled104611233bottled
bottler94211883bottler
bottles94216273bottles
bottom1048723bottom
botts75224863bot_ts
botulin947653botulin
boucle103712783boucle
bouffe14438313bouffe
boule74828043bo_ule
boulle84614613boulle
bouncy13409073bouncy
bounty113411073bounty
bousy104917843bo_usy
bowel105621203bowel_
bowels114315593bowels
bowery146012113bowery
bowfin14338353bowfin
bowl96827703bo_wl_
bowls106121433bo_wls
boxful18145273boxful
boxfuls19113603boxfuls
boxy166420733bo__xy
boy87753563bo___y
boyla102912363bo_yla
brawly144312353brawly
briefly1534573briefly
brittly12165973brittly
broadly1337153broadly
brolly114510853brolly
brothy14519623brot_hy
brutely1235933brutely
bubbly124110353bubbly
buffy165013373b_uffy
bully105124813b_ully
burbly134311153burbly
burly104922833b_urly
busily112211503busily
butle75023103but_le
butty104020113but_ty
butyl1089103butyl_
butyls1176753butyls
bytalk1533473bytalk
coaly105521593co_aly
coffle14359043coffle
coldly12459953coldly
colly104926773co_lly
coly96940533co__ly
comely134213733comely
comfy153710213comf_y
comply152810383comply
coolly114811393coolly
cooly105525423co_oly
cosily113613853cosily
costly114012333costly
coyly135614893co_yly
cozily20349703cozily
cutely115312803cutely
daftly1335443daftly
dayfly1633813dayfly
deafly13389123deafly
deftly1336533deftly
doily95321033do_ily
dolly96125203do_lly
dooly94821803do_oly
dopily123510463dopily
dotal64919623dotal_
dottily1147283dottily
dottle74212503dottle
dotty94516103dot_ty
doty86128223dot__y
doubly12328963doubly
dourly103210433dourly
doyly124514013do_yly
dozily19329103dozily
fatly115716803fat_ly
fitly115114973fit_ly
fly97124953___fly
folly115022603fo_lly
fondly13299043fondly
foully1239013foully
foxily1947253foxily
gadfly1434663gadfly
glowfly1742673glowfly
godly104913293go_dly
goggly12337053goggly
golly95121103go_lly
goodly11419303goodly
goofily14105353goofily
goofy124915623goof_y
googly11417883googly
gorily10612503gorily
goutily1137933goutily
hokily16409093hokily
holily123612953holily
holly114824433ho_lly
holy106333433ho__ly
homely145313183homely
homily144712333homily
hooly115022223ho_oly
hostly124210863hostly
hotel85520753hotel_
hotels94515523hotels
hourly12369623hourly
jokily20306533jokily
jolly154517513jo_lly
joltily1746323joltily
jotty155012603jot_ty
jowly186410903jo_wly
lately93413843lately
liefly1266363liefly
loathly1334713loathly
loftily1336353loftily
lofty115813303lo_fty
logily1039833logily
lolly85120663lo_lly
lonely92912473lonely
longly10279603longly
lordly1038753lordly
loudly1037783loudly
lovely12339713lovely
lowly114113333lo_wly
mayfly1734403mayfly
medfly1535223medfly
molly105222493mo_lly
moly96031913mo__ly
monthly1535673monthly
mostly113110943mostly
motel76623243motel_
motels83616903motels
motey105922953mot_ey
mothy136214553mot_hy
motile83818343motile
motley1139383motley
mottle84116053mottle
mutely113811653mutely
nettly9459453nettly
nobly105314403no_bly
noily86120993no_ily
nosily93712683nosily
notably12199993notably
notal55221353notal_
notary92310713notary
notedly1136883notedly
notify1236943notify
oddly1037163_oddly
ofay106416103_o_fay
oily77932263_o_ily
only75319723_o_nly
oozily18328073oozily
otalgy1035353_otalgy
patly105020583pat_ly
pokily15309063pokily
poly96235153po__ly
poofy136213273poof_y
poorly1137893poorly
portly114713403portly
poshly1437723poshly
potboy1397813potboy
potful1138083potful
potfuls1236293potfuls
potsy105815613pot_sy
pottle84416103pottle
potty105621003pot_ty
pouffy17395883pouffy
rattly94111543rattly
refly113914563_refly
roily86121113ro_ily
ropily113312443ropily
rosily93914713rosily
rotary92411303rotary
rotl45029683rot_l_
rotls55620163rot_ls
ruffly15336673ruffly
sawfly1535133sawfly
shoofly1634353shoofly
softy115414483so_fty
solely93714213solely
sonly85718053so_nly
soothly13186923soothly
sootily101810523sootily
sorely94618013sorely
sotol54917653sotol_
sotols63714473sotols
sourly93612213sourly
toffy145310283to_ffy
total55321823total_
totally1039893totally
totals63115163totals
votary12248333votary
waffly18305433waffly
wetly114511713wet_ly
wobbly16347093wobbly
woolly12408513woolly
wooly114417673wo_oly

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 Filter1786911127160.796224486.2
2DLD Change Limit1127163038.79612814.5
3Display Results3033030.0933258.1
 (SQL Overall)1786913039.68518450.3
 
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.