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

318 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
duos5672813(None) 
dos48062311d_os
dubs78432191dubs
duds65530141duds
dues56045501dues
dugs614832281dugs
duns55140431duns
duo48536141duo_
dups75929511dups
duros65422691duros
udos56619901udos
abos67734412abos
adios65822862adios
ados57633512ados
apos65433822apos
auks85525262auks
autos56523322autos
avos77227012avos
bios66335322bios
boos67955032boos
bos57966812_bos
bros65635662bros
bubs86235502bubs
buds75235172buds
bugs76035912bugs
bums85934592bums
buns66243722buns
buoy95921782buoy
buoys104810632buoys
burs65847422burs
bus56950972bu_s
buss65134912buss
buts67247692buts
buys95726792buys
coos67456492coos
cos510270392_cos
cubs85832382cubs
cuds76730472cuds
cues65438982cues
cups85430822cups
curs65645542curs
cuss65430612cuss
cuts65841152cuts
dabs77139402dabs
dados75522432dados
dads67442772dads
dagos76419442dagos
dags66642602dags
dahs88231812dahs
dais57040702dais
daks97130602daks
dals57145122dals
dams77444372dams
dans56748152dans
daps77239162daps
datos65222782datos
daubs85014562daubs
dauts67822242dauts
daws86638242daws
days87637132days
debs76530242debs
decos85522122decos
dees56356632dees
dels56745472dels
demos86022992demos
dens55945072dens
devs86424032devs
dews86230602dews
deys85027472deys
dhow116614002dhow
dhows125911222dhows
dibs76233682dibs
didos76820812didos
dies55653522dies
difs86027322difs
digs66036052digs
dims75435022dims
dinos65428062dinos
dins56652042dins
diol57329132diol
diols65521012diols
dips75536912dips
dis46459892d_is
diss56434482diss
dits56450522dits
do310155252d_o_
doc66841512d_oc
docs75631152docs
dodos75819392dodos
doe47361952d_oe
does56554472does
dog57449752d_og
dogs66440152dogs
dojos135111792dojos
dol47150652d_ol
dols56943052dols
dom69752442d_om
doms76239572doms
don46757652d_on
dons56048702dons
doom76430072doom
dooms85321342dooms
door56928512door
doors65022132doors
dor47253922d_or
dors56747602dors
dose56442432d_ose
doss56235042doss
dost57248352d_ost
dot47573182d_ot
dots55647662dots
doum76226672doum
doums85417642doums
dour56330432dour
douse66329722douse
doux125817982doux
dow76749972d_ow
dows85941052dows
drop75324402drop
drops85719502drops
dross65418092dross
drubs85913832drubs
drugs75214652drugs
drums85415872drums
drys86314802drys
duad66521412duad
duads76515342duads
dual55928172dual
duals65620082duals
dub66642202du_b
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
dumbos114111082dumbos
dumbs105915752dumbs
dump95927092dump
dumps105220102dumps
dun46545582du_n
dune56137582dune
dunes65332172dunes
dung66328432dung
dungs75821972dungs
dunk96228572dunk
dunks105621192dunks
dunt55746872dunt
dunts65828412dunts
duomi8310132duomi
duomo839752duomo
duomos936822duomos
dup67637882du_p
dupe76630602dupe
dupes86425932dupes
dura55232112dura
duras65727732duras
dure56341812dure
dures65635922dures
durn56127632durn
durns64819872durns
duro56228022duro
duroc84513142duroc
durocs9569702durocs
durr55624352durr
durrs65519992durrs
durst66125172durst
dusk95724152dusk
dusks105317252dusks
dust57142532dust
dusts65923562dusts
duty85321452duty
dyes85331892dyes
egos55821652egos
epos66723732epos
eros45238452eros
euros54920242euros
fubs96328792fubs
fuds86528562fuds
fugs85730692fugs
funs75235732funs
furs76735042furs
fuss76027932fuss
goos57644912goos
gos47155132_gos
guls55930852guls
gums75030942gums
guns55533482guns
guts56637252guts
guvs85816812guvs
guys85019642guys
hos68364192_hos
hubs96027142hubs
hues75235232hues
hugs86129752hugs
hums96831422hums
huns76136932huns
huts76737442huts
jucos144111712jucos
judos134711732judos
jugs125525602jugs
jus106930222ju_s
juts115930162juts
kos76944822_kos
kudos105011252kudos
kues86426772kues
loos49051122loos
lues45943552lues
lugs55233522lugs
lums65734242lums
luvs75818502luvs
mhos95517772mhos
moos66051302moos
mos57067122_mos
muds75530652muds
mugs76232042mugs
mums85732772mums
muns65535922muns
muon65722732muon
muons75816172muons
mus55946752mu_s
muss64933762muss
muts64839982muts
naos47429732naos
nos38859322_nos
nous46136982nous
nubs65927142nubs
nuns45228232nuns
nus37939392nu_s
nuts45032672nuts
onos46229002onos
os211359882__os
ouds56430102ouds
ours47237562ours
outs45746962outs
ouzos143210412ouzos
poos65949112poos
pros65742782pros
pubs85029212pubs
puds75630512puds
pugs76332772pugs
puls65437562puls
puns66641482puns
pups86032232pups
purs65641042purs
pus55547842pu_s
puss64830132puss
puts65641752puts
quod145413622quod
quods154610222quods
rhos76319062rhos
rubs66133492rubs
rues46044482rues
rugs56033682rugs
rums64833472rums
runs46438082runs
ruts44541492ruts
sos37761602_sos
sous46947212sous
subs66037122subs
suds56135292suds
sues46247652sues
suks85927122suks
sumos75720092sumos
sums65837582sums
suns45841902suns
sups64834432sups
suqs134319652suqs
suss45229302suss
taos45541002taos
tubs65430062tubs
tugs56231672tugs
tuis44829642tuis
tuns45138662tuns
tups65628762tups
tuts45838452tuts
twos76718022twos
udo49027302udo_
udon56017742udon
udons65411462udons
uns35936762_uns
ups55629052_ups
us26937432_u_s
uts35534372_uts
vugs87022872vugs
woos76238802woos
wos66953532_wos
wuss75219332wuss
yous76230652yous
yuks116418022yuks
yups96121602yups
zoos135828802zoos

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.283631417.0
2DLD Change Limit298723180.92032469.6
3Display Results3183180.0803975.0
 (SQL Overall)1786913181.283139275.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.