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

397 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
juncos1544923(None) 
buncos104011591buncos
jucos144111711ju_cos
junco144612201junco_
juncoes16338071juncoes
juntos134110841juntos
uncos74117031_uncos
bancos104713892bancos
bunco94616082bunco_
bunkos124210322bunkos
dunces95215752dunces
guacos94410312guacos
jaunces16307422jaunces
jounces16369852jounces
juco134716202ju_co_
judos134711732ju_dos
juices1549422juices
jumbos17379122jumbos
junior1386142junior
juniors1475782juniors
junks164815972jun_ks
juntas134210502juntas
junto125114562junto_
mungos94311372mungos
nuncios937112nuncios
ounces83617772ounces
puntos85915792puntos
unco66021402_unco_
uncoy104111412_uncoy
uncus74014982_uncus
adjuncts1842453adjuncts
aduncous1143153aduncous
alnicos985533alnicos
amnios84912513amnios
anchos114214893_anchos
ancon75718233_ancon
audios72312283audios
aunts55227633aun_ts
autos56523323au_tos
banco94019393banco_
banjos15378893banjos
bentos86218303bentos
bingos95514793bingos
binocs1039923binocs
bongos95316653bongos
bounces113813683bounces
broncos11188073broncos
buckos143710893buckos
bucks134824293bu_cks
buffos14447853buffos
bunas75126573bun_as
bunch125118603bunc_h
bunches144116033bunches
bunchy16437463bunchy
buncoed12378443buncoed
bunds85523543bun_ds
bundts95010843bundts
bungs85323863bun_gs
bunion83111313bunion
bunions92210473bunions
bunko115514513bunko_
bunks115125083bun_ks
bunns74718293bun_ns
buns66243723bun__s
bunts75729803bun_ts
bunyas11359433bunyas
burros85114993burros
buteos84913413buteos
cansos84915383cansos
cantos84826973cantos
centos85920463centos
chicos134614833chicos
ciscos104711133ciscos
cocos95624693_cocos
conchos144313953conchos
conchs134714903conchs
condos94322333condos
congos94219883congos
contos84923233contos
cos510270393___cos
cunts76125123cun_ts
curios83218333curios
cuscus1038113cuscus
cussos84210003cussos
custos84014313custos
dances95120653dances
danios7314603danios
decos85522123_decos
dinos65428063din_os
discos94915213discos
duces86327473du_ces
ducks124823213du_cks
ducts85319893du_cts
dumbos114111083dumbos
dunams937833dunams
dunce86319263dunc_e
dunch115316263dunc_h
dunches133312583dunches
duncish1335793duncish
dunes65332173dun_es
dungs75821973dun_gs
dunks105621193dun_ks
duns55140433dun__s
dunts65828413dun_ts
duomos936823duomos
duos56728133du__os
durocs9569703durocs
duros65422693du_ros
eunuchs1272683eunuchs
euros54920243eu_ros
fanos85926503fan_os
fences114617113fences
fincas113512073fincas
finos86226953fin_os
fucks144419253fu_cks
fucose11167683fu_cose
fucous11399863fu_cous
fucus105515893fu_cus
fugios1037583fugios
functor1235203functor
functors1335743functors
funds94119253fun_ds
fundus10429173fundus
fungo94413133fungo_
fungoes11388813fungoes
fungous11367433fungous
fungus10418183fungus
funks125318913fun_ks
funs75235733fun__s
fuscous1256673fuscous
fynbos1433283fynbos
genros74211333genros
guaco85012163guaco_
guanacos1163813guanacos
guanos73811993guanos
gucks123917303gu_cks
guiros7389093guiros
gumbos114610873gumbos
gundog935793gundog
gundogs1034603gundogs
gunks104517723gun_ks
guns55533483gun__s
hances115621283hances
honchos15369573honchos
hucks144322173hu_cks
hullos94916293hullos
hunch136416213hunc_h
hunches153913463hunches
hunks125321453hun_ks
huns76136933hun__s
hunts86826173hun_ts
incog838253_incog
incogs937903_incogs
incus73315053_incus
infos84311673_infos
jacks185219833j_acks
janes124928123jan_es
jatos125116823j_atos
jaunce15367433jaunc_e
jaunced17335473jaunced
jaunts137511883jaun_ts
jellos134714283jellos
jingo134615213jingo_
jingoes153811433jingoes
jinks165019333jin_ks
jinnis13489053jinnis
jinns126013843jin_ns
jins115635013jin__s
jinxes20428233jinxes
jockos19527563jockos
jocks185118083j_ocks
jocose1537103j_ocose
jones125028183jon_es
jounce153310733jounc_e
jounced17337613jounced
jouncy18336203jounc_y
journos14134943journos
jubas144614223ju_bas
jubes145420743ju_bes
judas134911883ju_das
judges153713453judges
judo125315303ju_do_
jugs125525603ju__gs
jugums16104673jugums
juice14311323juic_e
juiced1636513juiced
juicer1536283juicer
juicers1636153juicers
juicy1738283juic_y
jujus11347463ju_jus
jukes165319103ju_kes
jukus16398673ju_kus
juleps1535623juleps
jumbo164311073jumbo_
jumps165116493ju_mps
jun105932063jun___
junction1736203junction
junctions1835943junctions
jungle144012653jungle
jungles154112543jungles
jungly17407693jungly
junk155121033jun__k
junked184311693junked
junker174213653junker
junkers184010863junkers
junket173815023junket
junkets18377623junkets
junkie17339603junkie
junkies183711693junkies
junky194513233jun_ky
junta123713673jun_ta
jupes145218553ju_pes
jupon14479193ju_pon
jupons15377803jupons
jurats134213203jurats
jurels133710583jurels
juries134120633juries
juror1239563ju_ror
jurors1338283jurors
jus106930223ju___s
justs124918263ju_sts
jutes125125133ju_tes
juts115930163ju__ts
kendos114510663kendos
kenos95220623ken_os
kinos96626143kin_os
kudos105011253ku_dos
kussos10336423kussos
lances84824103lances
launces9329003launces
lenos56024863len_os
lentos65317403lentos
linos55631503lin_os
locos75822603_locos
luces75528433lu_ces
lucks115723563lu_cks
lunars65012813lunars
lunas55025013lun_as
lunch104917243lunc_h
lunches124115443lunches
lunes55337773lun_es
lunets66914763lunets
lunges76123423lunges
lungis77113023lungis
lungs65223883lun_gs
lunies64723013lunies
lunks94822453lun_ks
lunts55826903lun_ts
mangos94319333mangos
manos74933613man_os
minces104420803minces
mondos95217333mondos
mongos94318623mongos
monos75930863mon_os
mucks134622643mu_cks
mucor94011943mu_cor
mucors104410843mu_cors
mucosa10166273mu_cosa
mucose10149313mu_cose
mucous104411653mu_cous
mucus94015743mu_cus
mulcts10298713mulcts
munch124917103munc_h
munches144215793munches
mungo84916053mungo_
mungoes103510463mungoes
munis75022003mun_is
muns65535913mun__s
nances83618643nances
naos47429733__naos
narcos86714203narcos
nonces84418833nonces
noncom1039683noncom
noncoms1139183noncoms
nos38859323__n_os
nuances938523nuances
nuncio837973nuncio
nuncle839363nuncle
nuncles939843nuncles
nuns45228233nun__s
onos46229003_on_os
ounce77019933ounc_e
ouzos143210413ou_zos
pantos85222743pantos
pengos94612413pengos
pingos95317673pingos
pinkos125313873pinkos
pintos86021293pintos
piscos105112593piscos
ponces104720843ponces
ponchos143410703ponchos
pounces114113893pounces
puces94924633pu_ces
pucks134322103pu_cks
punas74826753pun_as
punch125118423punc_h
punches144816133punches
punchy16398523punchy
pungs85422223pun_gs
punjis1536693punjis
punkas123410673punkas
punks114822683pun_ks
puns66641483pun__s
punto75121323punto_
punts75828003pun_ts
quacks214710103quacks
quangos1734653quangos
quicks21389303quicks
quinces183210433quinces
rances84625443rances
ranchos123911393ranchos
rancor8810373rancor
rancors9811373rancors
rondos74616723rondos
rucks114422053ru_cks
runes55530223run_es
rungs611819403run_gs
runs46438073run__s
runts55927633run_ts
santos64421833santos
seccos1039923seccos
stuccos1153933stuccos
succor1036623succor
succors1137413succors
sucks114523073su_cks
sulcus8410493sulcus
sumos75720093su_mos
sunbow1145823sunbow
sunbows1236023sunbows
sundog837613sundog
sundogs947103sundogs
sunnas63914563sunnas
sunns55017353sun_ns
suns45841903sun__s
sunups837263sunups
synchs14408453synchs
syncom1336093syncom
syncoms1435943syncoms
syncs104610173sync_s
tacos77023553_tacos
tangos74216303tangos
telcos8710683telcos
tincts84510803tincts
tondos75115913tondos
tucks114721123tu_cks
tunas54224123tun_as
tuners64417343tuners
tunes55332193tun_es
tungs65520623tun_gs
tunics83811263tunics
tuns45138663tun__s
turacos938623turacos
turbos8910783turbos
udos56619903_u_dos
umbos94613063_umbos
unais53420773_unais
unaus53216573_unaus
unbox1438753_unbox
uncap9312283_uncap
uncaps1039813_uncaps
uncase83817433_uncase
uncast84215713_uncast
unci65019463_unc_i
uncia75015163_uncia
uncle7317053_uncle
uncles8317163_uncles
unclog956603_unclog
unclogs1036803_unclogs
unclose91111643_unclose
uncock1438563_uncock
uncocks1537233_uncocks
uncoil8811853_uncoil
uncoils979533_uncoils
uncool8610113_uncool
uncork1239043_uncork
uncorks1337443_uncorks
uncross938193_uncross
uncut73219173_uncut
undo55620153_undo_
undoes73917403_undoes
ungot61718063_ungot
union54519793_union
unions64216753_unions
units54923433_units
uns35936753_un__s
unto45824283_unto_
unwon84512343_unwon
updos8389513_updos
vincas113912453vincas
vinos84723073vin_os
winces114819113winces
winos84625043win_os
yucas106013913yu_cas
yuccas13426553yuccas
yucks144717193yu_cks
zincous1837053zincous
zincs165312933zinc_s

Search took 7 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.1531167915.0
2DLD Change Limit1127163976.20618162.4
3Display Results3973970.1233227.6
 (SQL Overall)1786913976.48227567.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.