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

430 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
discus9451211(None) 
discos94915211discos
discs85316261disc_s
discuss10357951discuss
viscus11428501viscus
ascus75013582_ascus
circus104310592circus
ciscos104711132ciscos
cistus84611342cistus
cuscus1038112cuscus
dices86434242di_ces
dicks125824692di_cks
dingus83611842dingus
disbud10165712disbud
disbuds11125242disbuds
disc76123232disc__
discase102912862discase
disced104914652disced
disci85815022disc_i
disco85616072disc_o
discuses113112862discuses
diseur738842diseur
diseurs839402diseurs
diseuse83110722diseuse
disgust937632disgust
dishes104622652dishes
disks105417472dis_ks
dismes95617672dismes
diss56434482dis__s
disses75225962disses
disuse74012842dis_use
ficus105015492fi_cus
fiscs105311882fisc_s
incus73315052_incus
miscue10412222miscue
miscues11312392miscues
miscut10614822miscut
miscuts1139182miscuts
missus85312292missus
nisus56014392nis_us
piscos105112592piscos
risus54216392ris_us
viscous1238832viscous
abacus10349763abacus
adieus739633adi_eus
adipous1037183adipous
airbus848343airbus
aisles64721143aisles
amicus103810003amicus
arcus76918863_arcus
bices95029963bi_ces
bijous1548043bijous
biscuit1147373biscuit
biscuits1245133biscuits
bisects1137133bisects
bises75435623bis_es
bisks115416803bis_ks
bisons83914373bisons
bisque17257843bisque
bisques18236893bisques
byssus1133763byssus
casus76419253cas_us
caucus1039613caucus
cercus105013153cercus
cestus84412913cestus
circusy14374593circusy
cirrus8349173cirrus
cisco95112133cisc_o
ciscoes113610733ciscoes
cists76624533cis_ts
citrus83610923citrus
coccus979283coccus
crocus104813173crocus
daces85030683d_aces
daises74318983dais_es
daisies84217093daisies
dances95120653dances
dashes106124983dashes
dashis104414393dashis
decks124822193d_ecks
decos85522123d_ecos
defocus1335283defocus
dehisces1464713dehisces
deices94119373deices
deisms94411043deis_ms
deists74916433deis_ts
descry1256183descry
desks105913073des_ks
deuces94015513deuces
diacid10310633diacid
diacids1137863diacids
dials64925343di_als
dibbuk1543503dibbuk
dibbuks1643163dibbuks
dibs76233683di__bs
dicast9315573di_cast
dice75841893di_c_e
diced95824683di_ced
dicer85426423di_cer
dicers94720743dicers
dicey114819333di_cey
dick116432383di_c_k
dicky154816243di_cky
dicot85429093di_cot
dicots94915793dicots
dicta84915633di_cta
dictum1136863dictum
dictums1235553dictums
dicty115116293di_cty
didacts1186063didacts
didies84621833didies
didoes85716963didoes
didos76820813di_dos
diecious1146873diecious
dienes75719903dienes
dies55653523di__es
diesels8429143diesels
dieses75218693dieses
diesis74013493diesis
diestrus946523diestrus
diets66026643di_ets
diffs126315483di_ffs
diffuse1444373diffuse
difs86027323di__fs
dights114016963dights
digits84114533digits
digs66036053di__gs
dikers114418793dikers
dikes105831333di_kes
dildos8179303dildos
dills65530973di_lls
dimers94321093dimers
dimes85833043di_mes
dimout9414243dimout
dimouts1037893dimouts
dims75435023di__ms
dinars75417563dinars
diners75525953diners
dines66449153di_nes
dinges83825423dinges
dings76331403di_ngs
dinks105927953di_nks
dinkum1335893dinkum
dinkums1433673dinkums
dinos65428063di_nos
dins56652043di__ns
dints67431313di_nts
diocese1036853diocese
diodes83915783diodes
dioicous1145133dioicous
diols65521013di_ols
dips75536913di__ps
dipsas9359893dipsas
dipsos95310053dipsos
dirams94413703dirams
dirdum1036033dirdum
dirdums1134383dirdums
directs102710263directs
dirges84915103dirges
dirks105619523di_rks
dirls64720503di_rls
dirts66824463di_rts
dis46459893di___s
disabuse1145553disabuse
disarm9310473disarm
disarms1039043disarms
disbar938513disbar
disbars10310323disbars
disburse1186443disburse
discant103017263discant
discants112912023discants
discard11310213discard
discards1238913discards
discased122510853discased
discases112014503discases
discept12310623discept
discepts1336743discepts
discern1038493discern
discerns1138163discerns
discing113914593discing
disclose1148743disclose
discoed11312483discoed
discoid11311243discoid
discoids1239873discoids
discord1139993discord
discords1238593discords
discount11811313discount
discounts1287823discounts
discourse1246863discourse
discussed13256763discussed
discusser12246183discusser
discusses12268253discusses
disease83213843disease
diseuses93112763diseuses
disguise1046833disguise
disgusts1045653disgusts
dish86328333dis__h
dished114318713dished
dishful1455433dishful
dishfuls1554313dishfuls
dishy125712353dis_hy
disjects18275923disjects
disk96625833dis__k
disked125015763disked
dismal92412243dismal
dismals102010243dismals
dismast10311233dismast
dismay12229473dismay
dismays13237433dismays
disme85716243dis_me
dismiss1038153dismiss
disown1036953disown
disowns1136733disowns
dispel9310323dispel
dispels10310503dispels
dispose10312763dispose
dispute1039083dispute
disputes1139653disputes
disrupt1048633disrupt
disrupts1145293disrupts
dissects11279243dissects
dissed85220183dissed
distal73615773distal
distichs1447633distichs
distil73616433distil
distils83015803distils
distrust949943distrust
disturb1046233disturb
disturbs1145403disturbs
disused93211033dis_used
disuses84015413disuses
ditas65923673di_tas
ditch115015093ditc_h
ditches133215713ditches
dites66339153di_tes
dits56450523di__ts
dittos74111973dittos
ditzes163212423ditzes
divans104612393divans
divas95418583di_vas
divers105024963divers
dives95832403di_ves
divots104712203divots
diwans105110373diwans
dixits144210313dixits
dizens164911393dizens
docks126022313d_ocks
docs75631153d_oc_s
doofus1036163doofus
dosers75723633dosers
doses65938503dos_es
doss56235043dos__s
dosses76126273dosses
drecks13459203drecks
duces86327473d_uces
ducks124823213d_ucks
ducts85319893d_ucts
dufus94010813d_ufus
dunces95215753dunces
dusks105317253dus_ks
dusts65923563dus_ts
dustup935363dustup
dustups1033913dustups
ecus65421463__ecus
edicts94911703edi_cts
fasces114914543fasces
fescue1137493fescue
fescues1236783fescues
fiascos12124743fiascos
fices106031163fi_ces
fichus14388113fichus
fincas113512073fincas
fisc96819753fisc__
fiscal1139333fiscal
fiscals1238003fiscals
fishes125221343fishes
fists85527543fis_ts
focus105815883_focus
fucus105515893_fucus
fuscous1256673fuscous
gismos957183gismos
gists66026193gis_ts
hiatus938223hiatus
hibiscus1541583hibiscus
hiccup1554393hiccup
hiccups1643223hiccups
hicks145322173hi_cks
hilus84817643hi_lus
hiss75629213his__s
hisses94719353hisses
hists86328373his_ts
hocus104715203_hocus
ices66129643_i_ces
ichs96214713_i_chs
ictus7249703_ictus
iglus6609933_iglus
ileus54616893_ileus
incur72212253_incur
incurs83012283_incurs
incuse83513573_incuse
isbas71010403_isbas
isles54220563_isles
isms66213473_is_ms
issue559213_issue
issues648803_issues
jisms14458003jis_ms
kicks104420083ki_cks
kiss85227403kis__s
kisses104217333kisses
kists95822113kis_ts
licks115325393li_cks
lieus56218483li_eus
limbus105710383limbus
lisles63416283lisles
lisps76913913lis_ps
lists56628693lis_ts
litmus836323litmus
locus74819993_locus
lusus54813873lus_us
meniscus1243783meniscus
miaous8511693miaous
micas96823053mi_cas
micks135525373mi_cks
mics87435153mi_c_s
minces104420803minces
minus75223933mi_nus
misacts1139353misacts
miscast11312423miscast
miscued1239293miscued
misers85025703misers
mises74740563mis_es
misfocus1543453misfocus
misos76523293mis_os
miss65339423mis__s
misses85130873misses
missis84417503missis
mists76633903mis_ts
misuse83213643mis_use
mucus94015743_mucus
nicks114920493ni_cks
nidus65913573ni_dus
nieces84112713nieces
nimbus10377283nimbus
niseis63512023niseis
odious749933odi_ous
odists749853odis_ts
oilcup1044253oilcup
oilcups1143333oilcups
passus83610293passus
picas94626523pi_cas
picks135226143pi_cks
pics85633913pi_c_s
picul95015363pi_cul
piculs103511753pi_culs
pieces104217273pieces
pignus937953pignus
pilaus84114133pilaus
pileus84514943pileus
pilous84717753pilous
pilus75921063pi_lus
pious74621273pi_ous
pisco96314983pisc_o
pishes114722103pishes
pisos76021063pis_os
piss65033333pis__s
pisses84525083pisses
pistes85325633pistes
pistous92714383pistous
rediscuss1242293rediscuss
rescue8313003rescue
rescues9312753rescues
rices75536153ri_ces
ricks115126133ri_cks
rictus8379193rictus
rimous8311913rimous
risers64624783risers
rises55244043ris_es
rishis9312453rishis
risks94917063ris_ks
risque15227453risque
scud76221283__scud
scuds85116243__scuds
scum85924523__scum
scums95017423__scums
scup84822383__scup
scups95316653__scups
scut65835543__scut
scuts74522523__scuts
sices75637273si_ces
sicks115127623si_cks
sics65234093si_c_s
sinus55523853si_nus
sisals63013573sisals
sises55233833sis_es
sisses64520603sisses
situs55019233si_tus
sous46947213__sous
sulcus8410493sulcus
ticks115823293ti_cks
tics65729633ti_c_s
tincts84510803tincts
tissue637333tissue
tissues737463tissues
trismus935563trismus
uncus74014983_uncus
vices105725533vi_ces
villus93611223villus
vincas113912453vincas
vinous93914173vinous
virtus94310143virtus
virus85316843vi_rus
visas84317653vis_as
viscid1237473viscid
viscose1237863viscose
vises84427773vis_es
visits9311423visits
visors92912223visors
vistas94513273vistas
wiccas1336543wiccas
wicks144619363wi_cks
winces114819113winces
wises85633193wis_es
wishes124920953wishes
wisps105214183wis_ps
wiss75630543wis__s
wisses94619603wisses
wists86728523wis_ts
xystus16354423xystus
zincous1837053zincous
zincs165312933zinc_s

Search took 8 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.390458182.1
2DLD Change Limit1127164306.78316617.4
3Display Results4304300.1403071.4
 (SQL Overall)1786914307.31324434.7
 
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.