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

412 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
bloody12471017(None) 
blood85319521blood_
bloods94614841bloods
blooey115110791blooey
bloomy134510111bloomy
boody115420401b_oody
broody124510081broody
blocky17388352blocky
blond85618372blond_
blonde94813292blonde
blonds95213342blonds
blooded11379802blooded
bloodily1445182bloodily
blooie83913192blooie
bloom95918972bloo_m
blooms104613172blooms
bloop96116152bloo_p
bloops106611342bloops
blotty11178342blotty
blousy11459122blousy
blowby16467512blowby
blowsy14579452blowsy
blowy134315322bl_owy
blowzy23516672blowzy
body107425672b__ody
booby125319512b_ooby
boogy114518322b_oogy
boomy125421822b_oomy
booty106125912b_ooty
boozy194917062b_oozy
brood84620242brood_
broods95416382broods
broomy13449952broomy
cloddy13405232cloddy
cloudy12517802cloudy
doody105517912_doody
flood95215602flood_
floods104511652floods
flooey123910172flooey
floosy12368152floosy
floozy21356612floozy
gloomy12528762gloomy
goody105620392_goody
hoody124919722_hoody
looby108115622_looby
looey84822912_looey
loony86918962_loony
loopy105316642_loopy
moody115017492_moody
ploidy1237482ploidy
unbloody1482412unbloody
woody125116882_woody
abloom1039783abloo_m
alkoxy2033343alkoxy
allod64418373allod_
allods73615083allods
alloy85519973allo_y
almondy13144483almondy
aloof83521573aloo_f
aloofly1343623aloofly
aloud65018063aloud_
baddy125016023b_addy
balcony1435853balcony
baldy115518933b_aldy
baloney1237483baloney
bandy114824183b_andy
barony115915303barony
bawdy147513283b_awdy
beady114719923b_eady
beblood12106083beblood_
bebloods13115233bebloods
belady12489933belady
bendy115017253b_endy
betony114211583betony
bhoot104322093bhoo_t
bhoots11459903bhoots
biddy124612693b_iddy
billowy15366903billowy
biology1337363biology
bionomy1444723bionomy
biopsy1334533biopsy
bipod104410823bipod_
bipods11408593bipods
blabby1234813blabby
blade85923333bl_ade
bland85320453bland_
blandly1336043blandly
blasty115611053blasty
bleary115112553bleary
blebby1233743blebby
bled75729313bl_ed_
bleed85019803bleed_
bleeds95211593bleeds
blend85317453blend_
blende95413443blende
blends96012883blends
blenny1156203blenny
blimey13468453blimey
blimy125212823bl_imy
blind86319323blind_
blindly1335743blindly
blinds95111613blinds
bloat75229923bl_oat
bloats85215763bloats
blob86027093bl_o_b
blobs95620033bl_obs
bloc85023273bl_o_c
block134917843bl_ock
blocks144513943blocks
blocs95219653bl_ocs
blog75723823bl_o_g
blogs85319233bl_ogs
bloke114316633bl_oke
blokes123813883blokes
blonder104011943blonder
blondes104213163blondes
bloodfin1443393bloodfin
bloodied1245973bloodied
bloodier1136823bloodier
bloodies11310163bloodies
blooding122410653blooding
bloodred1234083bloodred
bloodying1643783bloodying
bloomed12439433bloomed
bloomer11419813bloomer
bloomery15335693bloomery
blooped12398543blooped
blooper11358533blooper
blossomy15113203blossomy
blot65842323bl_o_t
blotch13197143blotch
blotchy17293973blotchy
blots75626173bl_ots
blotto8198443blotto
blouse84714723blouse
blow95827193bl_o_w
blowbys17353813blowbys
blowed125016693blowed
blower115316573blower
blowfly1843243blowfly
blown105716673bl_own
blowoff1843913blowoff
blowout1248403blowout
blows105423833bl_ows
blowup1335063blowup
blued84520323blued_
bluely113310083bluely
bluesy11448983bluesy
bluey104817053bl_uey
blurry11437673blurry
bobby114814653b_obby
bod67055543b__od_
bode75838753b__ode
bods76244713b__ods
bogey115220233b_ogey
boggy126116073b_oggy
bogy106426193b__ogy
bold75432813b_old_
boldly12399423boldly
bolds85825283b_olds
bolide9515563bolide
bolo65535953bolo__
boloney1247763boloney
bolos75531373bolo_s
bolshy1444883bolshy
bond75334363b_ond_
bonds86126843b_onds
boney105227313b_oney
bonny105816623b_onny
bony96732083b__ony
boo58163663b_oo__
boob85932583b_oo_b
boobs96221993b_oobs
boodle93215033b_oodle
booed85127273b_ooed
boogey124711523boogey
book106836333b_oo_k
books115729713b_ooks
boom87435673b_oo_m
booms95427123b_ooms
boon67142173b_oo_n
boons75031913b_oons
boor66130683b_oo_r
boors74325013b_oors
boos67955033b_oo_s
boost75132473b_oost
boot67759373b_oo_t
booth105522013b_ooth
boots75837973b_oots
booze164718913b_ooze
borty105522833b_orty
bosky145612393b_osky
bosomy13509033bosomy
bossy105515973b_ossy
bothy136713963b_othy
bousy104917843b_ousy
boxy166420733b__oxy
boy87753563b__o_y
brandy124712063brandy
bready124511183bready
briony1149043briony
broad84817693broad_
broadly1337153broadly
broads94515143broads
brolly114510853brolly
bronzy20306713bronzy
broo65129823broo__
brooch13368443brooch
brooded113510933brooded
brooder103811623brooder
broodily1445503broodily
brook114717763broo_k
brooks125813883brooks
broom95022213broo_m
brooms104915873brooms
broos75126413broo_s
brosy106115383b_rosy
brothy14519623brothy
browny144510043browny
bryony1435833bryony
buddy124812633b_uddy
buoy95921783b_uo_y
choosy14459103choosy
clod76124613cl_od_
clods85320863cl_ods
cloggy1344873cloggy
cloot76127053cloo_t
cloots85113693cloots
clotty11208263clotty
cloud86716423cloud_
clouds94612353clouds
cloy96623833cl_o_y
colony115417273colony
cooey105828223_cooey
cooky145321363_cooky
cooly105525423_cooly
corody12149703corody
crowdy15467173crowdy
dhooly13457143dhooly
dipody1336363dipody
dooly94821803_dooly
doomy116018263_doomy
doozy186813713_doozy
dowdy136112543_dowdy
drooly104911073drooly
droopy12458243droopy
embody1435023embody
floaty124210943floaty
flocky18468423flocky
flooded12307933flooded
flooder11258463flooder
floodway1842683floodway
flooie93712153flooie
floor84215233floo_r
floors94112353floors
floppy1654873floppy
flossy12517703flossy
floury12449573floury
food86830573_food_
foods95924163_foods
footy115820533_footy
glady105413943gl_ady
globby1434683globby
gloom87116523gloo_m
glooms96211683glooms
gloppy1454723gloppy
glory96413293gl_ory
glossy10549003glossy
good66531803_good_
goodby13406283_goodby
goodly11419303_goodly
goods75124483_goods
gooey95522863_gooey
goofy124915623_goofy
gooky135818033_gooky
goony95519783_goony
goopy115816623_goopy
goosy96018883_goosy
grody103412063_grody
groovy13375403groovy
hood85132333_hood_
hoods95124083_hoods
hooey114926603_hooey
hooky155220263_hooky
hooly115022223_hooly
hooty115022433_hooty
howdy155711413_howdy
imbody1434093imbody
kloof123812133kloo_f
kloofs13386353kloofs
kooky114412873_kooky
lady86527153_l_ady
lardy96119273_lardy
leady95618603_leady
lindy96918313_lindy
load56730603_load_
loads65323373_loads
loamy105913343_loamy
lobby125113913_lobby
lode56240113_l_ode
lofty115813303_lofty
loggy105714193_loggy
logy87025783_l_ogy
loid55531483_loid_
loids66220703_loids
lolly85120663_lolly
loo38359823_loo__
looed64626133_looed
looeys95110123_looeys
loof78141053_loo_f
loofa85912813_loofa
loofs85623783_loofs
looie55624243_looie
look87333473_loo_k
looks95124863_looks
loom67035053_loo_m
looms75124643_looms
loon47344793_loo_n
looney94712403_looney
loons55731723_loons
loop67835013_loo_p
loops75723963_loops
loos49051123_loo_s
loose56627683_loose
loot46955823_loo_t
loots55431423_loots
loppy125911663_loppy
lord55032083_lord_
lordly1038753_lordly
lords64923503_lords
lorry86315663_lorry
lory75931713_l_ory
lossy85214643_lossy
loud55228043_loud_
loudly1037783_loudly
loury85716753_loury
lousy84617083_lousy
lowly114113333_lowly
melody1237203melody
moldy115014653_moldy
monody1238243monody
mood76332063_mood_
moods85224623_moods
moony104818273_moony
moory105115793_moory
nobody1235743nobody
noddy105411203_noddy
nooky124814813_nooky
obloquy2141873obloquy
oldy85316843__oldy
ology94113113ol_ogy
oology103210253oology
oozy167018133__oozy
oxblood1743603oxblood_
oxbloods1842753oxbloods
parody12410093parody
phooey14379233phooey
plod76723273pl_od_
plods85719293pl_ods
plotty11208853plotty
ploy96123603pl_o_y
pood75934323_pood_
poods85124753_poods
poofy136213273_poofy
prosody1336433prosody
ptooey11346413ptooey
rebody1238153rebody
rood56733003_rood_
roods65125283_roods
rooky126117623_rooky
roomy107118063_roomy
rooty86423023_rooty
rowdy125711533_rowdy
shoddy1434533shoddy
slobby1334803slobby
sloid64619693sloid_
sloids73712693sloids
slojd13378843slojd_
slojds14345473slojds
sloop76118913sloo_p
sloops85513623sloops
sloppy1395303sloppy
sloshy12366623sloshy
slowly1237153slowly
sloyd9409683sloyd_
sloyds10346293sloyds
snood64616163snood_
snoods74312443snoods
snoopy11449473snoopy
snooty94211503snooty
snoozy18517223snoozy
soddy104210703_soddy
sooey84522433_sooey
sooty84924833_sooty
spoofy14498553spoofy
spooky15418093spooky
spoony114111793spoony
stood65517713stood_
swoony12408263swoony
swoopy14487283swoopy
toady96814343_toady
toddy106812423_toddy
tody86327213__tody
wood85329383_wood_
woods95723033_woods
woodsy13505923_woodsy
wooly114417673_wooly
woozy204410603_woozy
wordy126916163_wordy
zloty17399793zl_oty
zooey173914803_zooey
zooty175415353_zooty

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.280638182.1
2DLD Change Limit1127164128.17313791.3
3Display Results4124120.2801471.4
 (SQL Overall)1786914128.73320461.6
 
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.