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

343 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
duds6553014(None) 
buds75235171buds
cuds76730471cuds
dads67442771dads
duads76515341duads
dubs78432191dubs
dud56737591dud_
dude65629661dude
dudes75424371dudes
dues56045501dues
dugs614832281dugs
duns55140431duns
duos56728131duos
dups75929511dups
fuds86528561fuds
muds75530651muds
ouds56430101ouds
puds75630511puds
suds56135291suds
adds67622452adds
ads49755732_ads
aids57846362aids
ands57833612ands
auks85525262auks
bads77048862bads
bauds85821042bauds
beds75937782beds
bids75838452bids
bods76244712bods
bubs86235502bubs
bud67041272bud_
bugs76035912bugs
bums85934592bums
bunds85523542bunds
buns66243722buns
burds84626062burds
burs65847422burs
bus56950972bu_s
buss65134912buss
buts67247692buts
buys95726792buys
cads76144522cads
cods76848102cods
cruds85815852cruds
cubs85832382cubs
cud67937452cud_
cues65438982cues
cups85430822cups
curds85725612curds
curs65645542curs
cuss65430612cuss
cuts65841152cuts
dabs77139402dabs
dad58456162dad_
dada66422442dada
dadas75819862dadas
dado67126332dado
dados75522432dados
dags66642602dags
dahs88231812dahs
dais57040702dais
daks97130602daks
dals57145122dals
dams77444372dams
dans56748152dans
daps77239162daps
daubs85014562daubs
dauts67822242dauts
daws86638242daws
days87637132days
deads75726912deads
debs76530242debs
deeds75423762deeds
dees56356632dees
dels56745472dels
dens55945072dens
devs86424032devs
dews86230602dews
deys85027472deys
dibs76233682dibs
did56850522did_
dido66528202dido
didos76820812didos
didst74619612didst
didy99121512didy
dies55653522dies
difs86027322difs
digs66036052digs
dims75435022dims
dins56652042dins
dips75536912dips
dis46459892d_is
diss56434482diss
dits56450522dits
docs75631152docs
dodo66024912dodo
dodos75819392dodos
does56554472does
dogs66440152dogs
dols56943052dols
doms76239572doms
dons56048702dons
dors56747602dors
dos48062312d_os
doss56235042doss
dots55647662dots
doums85417642doums
dows85941052dows
drubs85913832drubs
drugs75214652drugs
druids8368092druids
drums85415872drums
drys86314802drys
duad66521412duad
dual55928172dual
duals65620082duals
dub66642202du_b
duce76933502duce
duces86327472duces
duci76422622duci
duck115929172duck
ducks124823212ducks
duct75735462duct
ducts85319892ducts
duddy114911032duddy
duded84417132duded
dudish1148312dudish
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
dumbs105915752dumbs
dump95927092dump
dumps105220102dumps
dun46545582du_n
dune56137582dune
dunes65332172dunes
dung66328432dung
dungs75821972dungs
dunk96228572dunk
dunks105621192dunks
dunt55746872dunt
dunts65828412dunts
duo48536142du_o
dup67637882du_p
dupe76630602dupe
dupes86425932dupes
dura55232112dura
duras65727732duras
dure56341812dure
dures65635922dures
durn56127632durn
durns64819872durns
duro56228022duro
duros65422692duros
durr55624352durr
durrs65519992durrs
durst66125172durst
dusk95724152dusk
dusks105317252dusks
dust57142532dust
dusts65923562dusts
duty85321452duty
dyads10549972dyads
dyes85331892dyes
eds46638922_eds
elds56324852elds
ends56528522ends
fads86939872fads
feds85234312feds
feuds95914882feuds
fids87034742fids
fubs96328792fubs
fud76335152fud_
fugs85730692fugs
funds94119252funds
funs75235732funs
furs76735042furs
fuss76027932fuss
gads67843382gads
gauds75717722gauds
geds66730812geds
gids65933742gids
gods65438042gods
gude65423332gude
gudes74520812gudes
guids75516152guids
guls55930852guls
gums75030942gums
guns55533482guns
guts56637252guts
guvs85816812guvs
guys85019642guys
hods87239862hods
hubs96027142hubs
hues75235232hues
hugs86129752hugs
hums96831422hums
huns76136932huns
hurds95219072hurds
huts76737442huts
ids47535472_ids
judas134911882judas
judo125315302judo
judos134711732judos
jugs125525602jugs
jus106930222ju_s
juts115930162juts
kids96029642kids
kudo96115112kudo
kudos105011252kudos
kudu95815432kudu
kudus104910802kudus
kues86426772kues
lads56549132lads
lauds65618482lauds
leuds66214812leuds
lids56336462lids
lude55331642lude
ludes65728852ludes
lues45943552lues
lugs55233522lugs
lums65734242lums
luvs75818502luvs
mads76845372mads
mauds85519272mauds
meds75735362meds
mids76541792mids
mods77945052mods
mud67336862mud_
mugs76232042mugs
mums85732772mums
muns65535922muns
mus55946752mu_s
muss64933762muss
muts64839982muts
nods55838222nods
nubs65927142nubs
nude56626272nude
nudes64723292nudes
nuns45228232nuns
nurds65518522nurds
nus37939392nu_s
nuts45032672nuts
odds68919922odds
ods47546212_ods
olds55926572olds
oud47439072oud_
ours47237562ours
outs45746962outs
pads76742952pads
peds75835242peds
pods76540152pods
pubs85029212pubs
pud65836652pud_
pugs76332772pugs
puls65437562puls
puns66641482puns
pups86032232pups
purs65641042purs
pus55547842pu_s
puss64830132puss
puts65641752puts
quads154515842quads
quids154917462quids
quods154610222quods
rads56046602rads
reds56042862reds
rids56539552rids
rods56442062rods
rubs66133492rubs
rudd65917472rudd
rudds74811702rudds
rude55632782rude
rues46044482rues
rugs56033682rugs
rums64833472rums
runs46438082runs
ruts44541492ruts
scuds85116242scuds
sods54940212sods
spuds85113672spuds
studs64415872studs
subs66037122subs
sudd64719772sudd
sudds75513592sudds
sudsy95010682sudsy
sues46247652sues
suks85927122suks
sums65837582sums
suns45841902suns
sups64834432sups
suqs134319652suqs
surds65624662surds
suss45229302suss
tads57143942tads
teds54932572teds
thuds95110132thuds
tods56141842tods
tubs65430062tubs
tugs56231672tugs
tuis44829642tuis
tuns45138662tuns
tups65628762tups
turds65021692turds
tuts45838452tuts
udo49027302_udo
udos56619902udos
uns35936762_uns
ups55629052_ups
urds55922432urds
us26937432_u_s
uts35534372_uts
vids85627542vids
vugs87022872vugs
wads87343142wads
weds86628932weds
wud76227152wud_
wuss75219332wuss
yauds95013222yauds
yids85224962yids
yods86531182yods
yuks116418022yuks
yups96121602yups
zeds145821802zeds

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.313570897.8
2DLD Change Limit298723430.89033564.0
3Display Results3433430.0933688.2
 (SQL Overall)1786913431.296137878.9
 
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.