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 “blot” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

246 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
blot6584232(None) 
blat66550951blat
blet66247671blet
bloat75229921bloat
blob86027091blob
bloc85023271bloc
blog75723821blog
blots75626171blots
blow95827191blow
bolt66254171bolt
boot67759371boot
bot59680401b_ot
clot66542421clot
lot38179261_lot
plot66141231plot
slot46049831slot
abbot9318452abbot
alit46155692alit
allot54933872allot
aloe45540192aloe
aloft8423432aloft
alow75328592alow
alt36467962al_t
alto47831262alto
baht96740012baht
bait66556002bait
ballot84624092ballot
bast66362412bast
bat510988952b_at
batt65053872batt
beat66168302beat
beet66457542beet
begot84625952begot
belon73924112belon
below104617192below
belt65754032belt
bent67759912bent
besot76429712besot
best66355322best
bet58376672b_et
bhoot104322102bhoot
bhut95425712bhut
bigot84828322bigot
bint67355042bint
bio57846082bio_
biog76122322biog
biont7727162biont
bios66335322bios
biota74516822biota
bit57070902b_it
bitt65545812bitt
blab86629132blab
blae66134642blae
blah98625062blah
blam86131702blam
blast76532572blast
blate75933782blate
blats75132502blats
blaw97026722blaw
bleat75737002bleat
bleb85425222bleb
bled75729312bled
blent76230952blent
blest76431722blest
blets75324942blets
blew94722432blew
blin67228172blin
blip88322772blip
blite76225352blite
blitz165318132blitz
bloats85215762bloats
blobs95620032blobs
block134917842block
blocs95219652blocs
blogs85319232blogs
bloke114316632bloke
blond85618372blond
blood85319522blood
bloom95918972bloom
bloop96116152bloop
blotch13197142blotch
blotto8198442blotto
blotty11178342blotty
blown105716672blown
blows105423832blows
blowy134315322blowy
blub85324872blub
blue65328462blue
bluet75631192bluet
blunt75525022blunt
blur66020532blur
blurt77625622blurt
bo410957572b_o_
boa56954032b_oa
boat66360312boat
bob76755672b_ob
bod67055542b_od
bog67852412b_og
bola66035562bola
bold75432812bold
bole66448692bole
boll65634752boll
bolo65535952bolo
bolos75531372bolos
bolts76232112bolts
boo58163662b_oo
boob85932582boob
book106836332book
boom87435672boom
boon67142172boon
boor66130682boor
boos67955032boos
boost75132472boost
booth105522012booth
boots75837972boots
booty106125912booty
bop77549482b_op
bort65960962bort
bos57966812b_os
bota66236502b_ota
both96533432b_oth
bots66453952b_ots
bott66548572bott
bout66353292bout
bow87051902b_ow
box1210142342b_ox
boy87753562b_oy
brat66055542brat
brit66350152brit
bro56236602bro_
broo65129822broo
bros65635662bros
broth106521092broth
brow97228442brow
brulot8912212brulot
brut66537962brut
bunt65850852bunt
buoy95921782buoy
bust65947782bust
but55963022b_ut
butt65143742butt
clod76124612clod
clog76123242clog
clon66232482clon
cloot76127052cloot
clop86929892clop
cloth105817542cloth
clots75627642clots
clout75330462clout
cloy96623832cloy
colt67158242colt
coot67860382coot
cot510483222_cot
dolt56649422dolt
dot47573182_dot
flat77147822flat
flit76539272flit
float85928572float
floc95922122floc
floe76129772floe
flog85523892flog
flop96925452flop
flota85315642flota
flout86226202flout
flow105924922flow
foot76248012foot
gloat65427682gloat
glob76623392glob
glom75424382glom
glop76724632glop
glost65422932glost
glout65925812glout
glow85222522glow
glut56331292glut
got49870442_got
grot55942052grot
helot85332682helot
holt77852582holt
hoot75752102hoot
hot67776062_hot
jolt116639122jolt
jot108259022_jot
knot85630502knot
lat37593402_lat
let36481472_let
lit39377312_lit
lo28053442_lo_
lob57154462_lob
loft76539142_loft
log46252682_log
loo38359822_loo
loot46955822loot
lop58255312_lop
lost47951492_lost
lota47233502_lota
loth76132132_loth
loti46431842_loti
lots47652092_lots
lout45952142_lout
low66051872_low
lox108240962_lox
molt66356162molt
moot67653622moot
mot57279422_mot
not39474662_not
oot311274692_oot
phot95534362phot
pilot77435062pilot
plat66048872plat
plod76723272plod
plop86625742plop
plots75025672plots
plotz164617002plotz
plow95923232plow
ploy96123602ploy
pot58078432_pot
riot45947212riot
root45655922root
rot37282952_rot
ryot75528562ryot
scot66242612scot
shot76150262shot
slat46959022slat
slit46250102slit
slob66029422slob
sloe45534952sloe
slog56728272slog
slop66533872slop
sloth85019452sloth
slots54830532slots
slow77729492slow
slut45040592slut
snot44745452snot
soot45761062soot
sot310384302_sot
spot65540692spot
stot46347332stot
sublot82315522sublot
swot75134662swot
toot45958882toot
tot38884772_tot
trot46351312trot
volt76439532volt
wot610467482_wot
zlote143912942zlote
zloty17399792zloty

Search took 1 second 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 Filter178691298720.0632836365.1
2DLD Change Limit298722460.75039829.3
3Display Results2462460.0633904.8
 (SQL Overall)1786912460.876203985.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.