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

327 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
dubs7843219(None) 
bubs86235501bubs
cubs85832381cubs
dabs77139401dabs
daubs85014561daubs
debs76530241debs
dibs76233681dibs
drubs85913831drubs
dub66642201dub_
duds65530141duds
dues56045501dues
dugs614832281dugs
dumbs105915751dumbs
duns55140431duns
duos56728131duos
dups75929511dups
fubs96328791fubs
hubs96027141hubs
nubs65927141nubs
pubs85029211pubs
rubs66133491rubs
subs66037121subs
tubs65430061tubs
abs59356072_abs
albs68628572albs
arbs66834732arbs
auks85525262auks
bibs84830992bibs
blubs95818152blubs
bobs86340652bobs
bub76343982bub_
bubo85621912bubo
bubu85022672bubu
bubus95115452bubus
buds75235172buds
bugs76035912bugs
bulbs96016932bulbs
bums85934592bums
buns66243722buns
burbs95423492burbs
burs65847422burs
bus56950972bu_s
buss65134912buss
buts67247692buts
buys95726792buys
cabs86739422cabs
chubs125412622chubs
clubs95415102clubs
cobs87043142cobs
cub76940942cub_
cube85830212cube
cubes95028162cubes
cuds76730472cuds
cues65438982cues
cups85430822cups
curbs94821652curbs
curs65645542curs
cuss65430612cuss
cuts65841152cuts
dab67455562dab_
dads67442772dads
dags66642602dags
dahs88231812dahs
dais57040702dais
daks97130602daks
dals57145122dals
dams77444372dams
dans56748152dans
daps77239162daps
darbs85323262darbs
daub77423442daub_
daube85015302daube
daubes94913702daubes
dauby115211222dauby
dauts67822242dauts
daws86638242daws
days87637132days
deb66342692deb_
debt77139022debt
debts86418372debts
dees56356632dees
dels56745472dels
dens55945072dens
devs86424032devs
dews86230602dews
deys85027472deys
dib65746942dib_
dies55653522dies
difs86027322difs
digs66036052digs
dims75435022dims
dins56652042dins
dips75536912dips
dis46459892d_is
diss56434482diss
dits56450522dits
doby106022162doby
docs75631152docs
does56554472does
dogs66440152dogs
dols56943052dols
doms76239572doms
dons56048702dons
dors56747602dors
dos48062312d_os
doss56235042doss
dots55647662dots
doubt8720092doubt
doubts968732doubts
doums85417642doums
dows85941052dows
drabs85119672drabs
dribs85115062dribs
drub75920132drub_
drugs75214652drugs
drums85415872drums
drys86314802drys
duad66521412duad
duads76515342duads
dual55928172dual
duals65620082duals
duce76933502duce
duces86327472duces
duci76422622duci
duck115929172duck
ducks124823212ducks
duct75735462duct
ducts85319892ducts
dud56737592du_d
dude65629662dude
dudes75424372dudes
due45249862du_e
duel56729702duel
duels65619232duels
duet56446262duet
duets65323882duets
duff114326642duff
duffs125216622duffs
dufus94010812dufus
dug58138692du_g
duh77930382du_h
dui46433382du_i
duit56241582duit
duits65021882duits
duke95628102duke
dukes105023472dukes
dull56430442dull
dulls64523742dulls
dulse65415042dulse
duly85323032duly
duma75524452duma
dumas85420432dumas
dumb97124102dumb
dumbo105614062dumbo
dumbos114111082dumbos
dump95927092dump
dumps105220102dumps
dun46545582du_n
dune56137582dune
dunes65332172dunes
dung66328432dung
dungs75821972dungs
dunk96228572dunk
dunks105621192dunks
dunt55746872dunt
dunts65828412dunts
duo48536142du_o
dup67637882du_p
dupe76630602dupe
dupes86425932dupes
dura55232112dura
duras65727732duras
dure56341812dure
dures65635922dures
durn56127622durn
durns64819862durns
duro56228022duro
duros65422692duros
durr55624352durr
durrs65519992durrs
durst66125172durst
dusk95724152dusk
dusks105317252dusks
dust57142532dust
dusts65923562dusts
duty85321452duty
dyes85331892dyes
ebbs82411992ebbs
fabs98635862fabs
fibs96329502fibs
flubs105515442flubs
fobs96034272fobs
fub86337392fub_
fubsy13589272fubsy
fuds86528562fuds
fugs85730692fugs
funs75235732funs
furs76735042furs
fuss76027932fuss
gabs76740422gabs
gibs75529272gibs
gobs76935572gobs
grubs86312602grubs
guls55930852guls
gums75030942gums
guns55533482guns
guts56637252guts
guvs85816812guvs
guys85019642guys
hobs97038982hobs
hub86437482hub_
hues75235232hues
hugs86129752hugs
hums96831422hums
huns76136932huns
huts76737442huts
jabs135830092jabs
jibs136724082jibs
jobs136529432jobs
juba134916982juba
jubas144614222jubas
jube136322782jube
jubes145420742jubes
jugs125525602jugs
jus106930222ju_s
juts115930162juts
kabs107130842kabs
kobs105831082kobs
kues86426772kues
labs67145122labs
libs66732762libs
lobs66441082lobs
lube64731562lube
lubes74727992lubes
lues45943552lues
lugs55233522lugs
lums65734242lums
luvs75818502luvs
mibs85330482mibs
mobs85737372mobs
muds75530652muds
mugs76232042mugs
mums85732772mums
muns65535922muns
mus55946752mu_s
muss64933762muss
muts64839982muts
nabs66236192nabs
nebs66124982nebs
nibs65028312nibs
nobs66436902nobs
nub56439142nub_
numbs94913092numbs
nuns45228232nuns
nus37939392nu_s
nuts45032672nuts
orbs66626252orbs
ouds56430102ouds
ours47237562ours
outs45746962outs
pub76037692pub_
pubes94423402pubes
pubis94616472pubis
puds75630512puds
pugs76332772pugs
puls65437562puls
puns66641482puns
pups86032232pups
purs65641042purs
pus55547842pu_s
puss64830132puss
puts65641752puts
rebs65733562rebs
redubs9358382redubs
ribs65833022ribs
robs65837872robs
rub56342822rub_
rube65532012rube
rubes74928412rubes
rubus76415062rubus
ruby97819942ruby
rues46044482rues
rugs56033682rugs
rums64833472rums
runs46438072runs
ruts44541492ruts
sabs66643742sabs
sibs65933542sibs
slubs74719532slubs
snubs75412552snubs
sobs64941752sobs
stubs75016072stubs
sub55445552sub_
suba64926602suba
subas74724072subas
suds56135292suds
sues46247652sues
suks85927122suks
sums65837582sums
suns45841902suns
sups64834432sups
suqs134319652suqs
suss45229302suss
tabs66842982tabs
tub55640032tub_
tuba65422362tuba
tubas75119582tubas
tube65828662tube
tubes74826452tubes
tugs56231672tugs
tuis44829642tuis
tuns45138662tuns
tups65628762tups
tuts45838452tuts
udos56619902udos
uns35936752_uns
ups55629052_ups
urbs65922052urbs
us26937432_u_s
uts35534372_uts
vugs87022872vugs
wabs97337232wabs
webs96622122webs
wuss75219332wuss
yobs96028082yobs
yuks116418022yuks
yups96121602yups

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298723270.89033564.0
3Display Results3273270.0804087.5
 (SQL Overall)1786913271.250142952.8
 
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.