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

293 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
blowby1646751(None) 
blowbys17353811blowbys
blowsy14579451blowsy
blowy134315321blow_y
blowzy23516671blowzy
blabby1234812blabby
blebby1233742blebby
blob86027092blo_b_
blobs95620032blo_bs
blocky17388352blocky
bloody124710172bloody
blooey115110792blooey
bloomy134510112bloomy
blotty11178342blotty
blousy11459122blousy
blow95827192blow__
blowed125016692blowed
blower115316572blower
blowfly1843242blowfly
blown105716672blow_n
blows105423832blow_s
blowup1335062blowup
bobby114814662b_obby
booby125319512b_ooby
browny144510042browny
globby1434682globby
lobby125113922_lobby
looby108115622_looby
lowboy1435902_lowboy
lowly114113332_lowly
plowboy1743182plowboy
slobby1334802slobby
slowly1237152slowly
alow75328593alow__
alway116113923al_way
baby116723683b__aby
baloney1237483baloney
bawdy147513283b_awdy
bawty135614103b_awty
below104617193below__
belows114614183below_s
beltway1564373beltway
bilby124912353b_ilby
billowy15366903billow_y
biopsy1334533biopsy
blab86629133bl_ab_
blabs95619633bl_abs
blasty115611053blasty
blaw97026723blaw__
blawed124713893blawed
blawn106813703blaw_n
blaws105620463blaw_s
bleary115112553bleary
bleb85425223bl_eb_
blebs96416153bl_ebs
blenny1156203blenny
blew94722433blew__
blimey13468453blimey
blimy125212823bl_imy
bloat75229923blo_at
bloats85215763bloats
blobbed11366563blobbed
bloc85023273blo__c
block134917843blo_ck
blocks144513943blocks
blocs95219653blo_cs
blog75723823blo__g
blogs85319233blo_gs
bloke114316633blo_ke
blokes123813883blokes
blond85618373blo_nd
blonde94813293blonde
blonds95213343blonds
blood85319523blo_od
bloods94614843bloods
blooie83913193blooie
bloom95918973blo_om
blooms104613173blooms
bloop96116153blo_op
bloops106611343bloops
blot65842323blo__t
blotch13197143blotch
blotchy17293973blotchy
blots75626173blo_ts
blotto8198443blotto
blouse84714723blouse
blowback2143993blowback
blowball1544153blowball
blowers124313593blowers
blowgun1342653blowgun
blowier1248943blowier
blowing133813053blowing
blowjob2141753blowjob
blowjobs2241573blowjobs
blowoff1843913blowoff
blowout1248403blowout
blowsed13449023blowsed
blowsily1643953blowsily
blowtube1541583blowtube
blowups1433163blowups
blowzed22435973blowzed
blowzily2542733blowzily
blub85324873bl_ub_
blubs95818153bl_ubs
bluely113310083bluely
bluesy11448983bluesy
bluey104817053bl_uey
blurb95214903blurb_
blurbs10489313blurbs
blurry11437673blurry
bob76755673b_o_b_
bobs86340653b_o_bs
body107425673b_o_dy
bogey115220233b_ogey
boggy126116073b_oggy
bogy106426193b_o_gy
boldly12399423boldly
boloney1247763boloney
bolshy1444883bolshy
bomb106927423b_omb_
bombe115519313b_ombe
bombs115818823b_ombs
bombyx2232693b_ombyx
boney105227313b_oney
bonny105816623b_onny
bony96732083b_o_ny
boob85932583b_oob_
boobs96221993b_oobs
boody115420403b_oody
boogey124711523boogey
boogy114518323b_oogy
boomy125421823b_oomy
booty106125913b_ooty
boozy194917063b_oozy
borty105522833b_orty
bosky145612393b_osky
bossy105515973b_ossy
bothy136713963b_othy
bousy104917843b_ousy
bow87051903b_ow__
bowed114533423b_owed
bowel105621203b_owel
bower107328183b_ower
bowery146012113b_owery
bowl96827703b_ow_l
bowls106121433b_owls
bows96242863b_ow_s
bowse105420633b_owse
boxy166420733b_o_xy
boy87753563b_o__y
brawly144312353brawly
brawny144710603brawny
brolly114510853brolly
bronzy20306713bronzy
broody124510083broody
broomy13449953broomy
brosy106115383bro_sy
brothy14519623brothy
brow97228443brow__
browed125216393browed
brown105619533brow_n
browns116415633browns
brows105425983brow_s
browse115713853browse
brumby15385953brumby
bubby115013933b_ubby
buoy95921783buo__y
busby126113293b_usby
byway1647533b_yway
cloddy13405233cloddy
cloggy1344873cloggy
clomb115714703clomb_
clotty11208263clotty
cloudy12517803cloudy
clown105214733clow_n
clowns114810113clowns
cloy96623833clo__y
clubby1534683clubby
cobby145516413_cobby
colby124415063_colby
corby125018533_corby
cowboy1637063_cowboy
cowry135512483_cowry
cowy126427363_cow_y
crowdy15467173crowdy
dobby136013633_dobby
doby106022163_do_by
dowdy136112543_dowdy
downy125714553_downy
dowry126312483_dowry
drowsy13487903drowsy
flabby1634573flabby
flawy145913383flaw_y
floaty124210943floaty
flocky18468423flocky
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
floppy1654873floppy
flossy12517703flossy
floury12449573floury
flow105924923flow__
flowed133513763flowed
flower124815503flower
flowery16327783flowery
flown116213993flow_n
flows115822363flow_s
flyby1676003fl_yby
flyway18134693flyway
forby135317673_forby
frowsy15498273frowsy
frowzy24485793frowzy
glob76623393glo_b_
globe84917013glo_be
globs85616403glo_bs
gloomy12528763gloomy
gloppy1454723gloppy
glory96413293glo_ry
glossy10549003glossy
glow85222523glow__
glowed114913833glowed
glower105114933glower
glowfly1742673glowfly
glows95518033glow_s
goby106021083_go_by
goodby13406283goodby
growly13499173growly
hobby155913733_hobby
howdy155711413_howdy
jowly186410903_jowly
knobby1732713knobby
lamby125114843_lamby
lawny115912013_lawny
limby125714073_limby
loamy105913343_loamy
lob57154463_lo_b_
lobe65535363_lo_be
lobo67229863_lo_bo
lobs66441083_lo_bs
lofty115813303_lofty
loggy105714193_loggy
logway1335913_logway
logy87025783_lo_gy
lolly85120663_lolly
looey84822913_looey
loony86918963_loony
loopy105316643_loopy
loppy125911663_loppy
lorry86315673_lorry
lory75931713_lo_ry
lossy85214643_lossy
loury85716753_loury
lousy84617083_lousy
low66051873_low__
lowboys1534213_lowboys
lowe75435313_low_e
lowed95233903_lowed
lower85830413_lower
lowery124112713_lowery
lowes85732463_lowes
lown76929293_low_n
lows75843013_low_s
lowse87219903_lowse
nobby125513463_nobby
noway111112843_noway
obloquy2141873obloquy
ology94113113olo_gy
orby97519603__orby
ploidy1237483ploidy
plotty11208853plotty
plow95923233plow__
plowboys1842363plowboys
plowed124213203plowed
plower114315063plower
plows105419903plow_s
ploy96123603plo__y
rowdy125711533_rowdy
showy145714003show_y
slob66029423slo_b_
slobs74419873slo_bs
sloppy1395303sloppy
sloshy12366623sloshy
slow77729493slow__
slowed104617073slowed
slower94016153slower
slows85323463slow_s
snobby1334403snobby
snowy115011563snow_y
toby96322293_to_by
towny116114493_towny
towy105325473_tow_y
womby155910093_womby
zloty17399793zlo_ty

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.1561145455.1
2DLD Change Limit1127162936.26617988.5
3Display Results2932930.1102663.6
 (SQL Overall)1786912936.53227356.2
 
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.