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

284 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
blabby123481(None) 
blebby1233741blebby
flabby1634571flabby
baby116723672b_a_by
blab86629132bla_b_
blabbed11357812blabbed
blabber10418922blabber
blabs95619632bla_bs
blasty115611052blasty
blowby16467512blowby
bobby114814652b_obby
bubby115013922b_ubby
cabby145314552_cabby
clubby1534682clubby
crabby15346752crabby
gabby135512942_gabby
globby1434682globby
grabby14336182grabby
lamby125114842_lamby
lobby125113912_lobby
scabby1535502scabby
shabby1635802shabby
slobby1334802slobby
swabby1634352swabby
tabby125213882_tabby
yabby15389742_yabby
abba810522643__abba
abbe87627183__abbe
abbey125714933__abbey
ably99725133__ably
aby810238063__a_by
alary86123443ala_ry
baba88828343b_a_ba
babas96325733b_abas
babble94017113b_abble
babe86835813b_a_be
babel95821693b_abel
babes95834113b_abes
babka137812913b_abka
baboo94319503b_aboo
babu85829223b_a_bu
babul96317713b_abul
babus95620333b_abus
baddy125016023b_addy
badly114918763b_adly
baffy165511923b_affy
baggy125615683b_aggy
balboa10389963balboa
baldly12479833baldly
baldy115518933b_aldy
balky145418243b_alky
ballsy11508873ballsy
bally105530103b_ally
balmy125217473b_almy
bandy114824183b_andy
banty106624003b_anty
barb85240063b_arb_
barbe95328283b_arbe
barbs95928193b_arbs
barky145721613b_arky
barmy125218763b_army
barny105821733b_arny
bassy1012917103b_assy
batboy1387533batboy
batty105422243b_atty
bawdy147513283b_awdy
bawty135614103b_awty
bay89661643b_a__y
beachy164011253beachy
beady114719923bea_dy
beaky146118023bea_ky
beamy126218573bea_my
beauty115410163beauty
belabor1136293belabor
belady12489933bela_dy
belay105021523bela__y
bellboy1445123bellboy
bialy105119323bia_ly
bibb75819193b_ibb_
bibbs84911573b_ibbs
bilby124912343b_ilby
blabbers11308153blabbers
blabbing12266723blabbing
black134719073bla_ck
blackboy2143163blackboy
blackly1835253blackly
blacks144914953blacks
blade85923333bla_de
bladed104717763bladed
blader93618583blader
blades95221253blades
blae66134643bla__e
blaff135216483bla_ff
blaffs14426623blaffs
blah98625063bla__h
blahs105616513bla_hs
blain75421793bla_in
blains84516373blains
blam86131703bla__m
blamably1744903blamably
blame95625493bla_me
blamed116017953blamed
blamer104417143blamer
blames105121863blames
blams95023853bla_ms
blanch133410853blanch
bland85320453bla_nd
blandly1336043blandly
blank115418553bla_nk
blankly1634263blankly
blanks124112893blanks
blare75826233bla_re
blared95018243blared
blares85021633blares
blarney12174763blarney
blase75524233bla_se
blast76532573bla_st
blasts85116773blasts
blat66550953bla__t
blate75933783bla_te
blats75132503bla_ts
blaubok1542243blaubok
blaw97026723bla__w
blawed124713893blawed
blawn106813703bla_wn
blaws105620463bla_ws
blaze165520833bla_ze
blazed184314713blazed
blazer174414023blazer
blazes174817353blazes
blazon1736763blazon
bleakly1634663bleakly
bleary115112553bleary
bleb85425223bl_eb_
blebs96416153bl_ebs
blenny1156203blenny
blimey13468453blimey
blimy125212823bl_imy
blob86027093bl_ob_
blobbed11366563blobbed
blobs95620033bl_obs
blocky17388353blocky
bloody124710173bloody
blooey115110793blooey
bloomy134510113bloomy
blotty11178343blotty
blousy11459123blousy
blowbys17353813blowbys
blowsy14579453blowsy
blowy134315323bl_owy
blowzy23516673blowzy
blub85324873bl_ub_
blubbed11338393blubbed
blubber10399293blubber
blubbery14294783blubbery
blubs95818153bl_ubs
bluely113310083bluely
bluesy11448983bluesy
bluey104817053bl_uey
blurb95214903blurb_
blurbs10489313blurbs
blurry11437673blurry
booby125319513b_ooby
brabble10349973brabble
braggy13337173braggy
brainy114815643brainy
braky145015813bra_ky
brambly16296253brambly
brandy124712063brandy
branny115111833branny
brashy145210593brashy
brassy11509233brassy
bratty1159683bratty
brawly144312353brawly
brawny144710603brawny
braxy175410893bra_xy
bray95232903bra__y
brumby15385953brumby
bubba84311793b_ubba
bubbly124110353bubbly
burbly134311153burbly
busboy13307443busboy
busby126113293b_usby
chubby1844123chubby
clabber134210113clabber
clammy15356333clammy
clanky15469073clanky
clary105719613cla_ry
classy11379043classy
clay95927413cla__y
clayey14407663clayey
cobby145516403_cobby
cubby145212113_cubby
dauby115211223_dauby
dobby136013623_dobby
drably123511613drably
flab96628353fla_b_
flabbily1843353flabbily
flabs105818643fla_bs
flaggy14415923flaggy
flakey164410513flakey
flaky155715583fla_ky
flambe13489153flambe
flamy135217473fla_my
flappy1654483flappy
flashy15498173flashy
flatly123110213flatly
flawy145913383fla_wy
flaxy189012293fla_xy
flay106332803fla__y
flyboy17113913flyboy
flyby1676003fl_yby
gaby107123193_ga_by
gladly11497933gladly
glady105413943gla_dy
glairy10448273glairy
glary96018543gla_ry
glassy10527753glassy
glazy187410983gla_zy
glibly1236293glibly
grubby14324503grubby
hobby155913723_hobby
hubby155011393_hubby
knobby1732713knobby
knubby1742783knubby
lab58864783_la_b_
label75019383_label
labia75219003_labia
labor75117313_labor
labra75415463_labra
labs67145123_la_bs
lacey105820913_lacey
lacy95829633_la_cy
lady86527153_la_dy
laity85318903_laity
laky116725823_la_ky
lamb86832143_lamb_
lambs95921413_lambs
lanky125517483_lanky
lardy96119273_lardy
larky125218873_larky
lathy115215063_lathy
lawny115912013_lawny
laxly15610103_laxly
lay68865353_la__y
lazy166423073_la_zy
limby125714063_limby
looby108115623_looby
nearby11356053nearby
nobby125513453_nobby
nubby125011023_nubby
plaguy12386413plaguy
plashy14448873plashy
platy105021663pla_ty
play95928983pla__y
playboy1743813playboy
pliably14147383pliably
rabbi93113173_rabbi
ribby12419673_ribby
rubby124413853_rubby
salably121610743salably
slab67133763sla_b_
slabbed12409503slabbed
slabber113311393slabber
slabbery15375773slabbery
slabs75322643sla_bs
slaggy11438793slaggy
slangy105411393slangy
slanty95114843slanty
slatey95417063slatey
slaty86523153sla_ty
slavey124011803slavey
slay76436383sla__y
snobby1334403snobby
snubby1344533snubby
squabby2343283squabby
stably113314123stably
stubby1345043stubby
suably112814533suably
tubby124511393_tubby
usably11288983usably
viably14199833viably
wabbly16348363_wabbly
webby1537143_webby

Search took 7 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.1261418182.5
2DLD Change Limit1127162845.89019136.8
3Display Results2842840.0933053.8
 (SQL Overall)1786912846.10929250.5
 
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.