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

286 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
juncoes1633807(None) 
juncos15449231junco_s
bunches144116032bunches
buncoed12378442buncoed
buncos104011592bunco_s
dunces95215752dunc_es
dunches133312582dunches
fungoes11388812fungoes
hunches153913462hunches
jaunces16307422jaunc_es
jingoes153811442jingoes
jounces16369852jounc_es
jucos144111712ju_co_s
juices1549422juic_es
junco144612202junco__
jungles154112542jungles
juniors1475782juniors
junkies183711692junkies
juntos134110842junto_s
lunches124115442lunches
munches144215792munches
mungoes103510462mungoes
nuncles939842nuncles
ounces83617772ounc_es
punches144816132punches
uncles8317162_uncles
uncos74117032_unco_s
undoes73917402_undoes
aduncous1143163aduncous
ancones93116343_ancones
aunties73920073aunties
bancos104713893banco_s
banjoes16317313banjoes
benches143918603benches
bingoes104013983bingoes
bongoes104314113bongoes
bounces113813683bounc_es
brunches153710453brunches
buboes104513993bu_boes
buckoes153810393buckoes
bunched154312413bunched
bunco94616083bunco__
buncombes1742113buncombes
bundles103515773bundles
bungees104513103bungees
bungles104116763bungles
bunions92210473bunions
bunkoed14356663bunkoed
bunkos124210323bunko_s
bunnies94415003bunnies
butches144315363butches
canoes84725883can_oes
cinches144215773cinches
ciscoes113610733ciscoes
conches144019813conches
condoes104319203condoes
congoes103617303congoes
crunches153711353crunches
culches143710743culches
curches143512743curches
cutches143216463cutches
dances95120653danc_es
dingoes94114833dingoes
duces86327473du_c_es
dunce86319263dunc_e_
dunes65332173dun__es
dunites8313593dunites
encodes10310643_encodes
encores9315213_encores
fancies124018783fancies
fences114617113fenc_es
ficoes114613463_ficoes
finches153914193finches
fucose11167683fu_cose
fucoses12148303fu_coses
fucous11399863fu_cous
functors1335743functors
fungous11367433fungous
funicles13246833funicles
funnies104113603funnies
fuscous1256673fuscous
ginzoes1735433ginzoes
glunches1436263glunches
guacos94410313guaco_s
gulches13398103gulches
gundogs1034603gundogs
gunites8313123gunites
gunnies83413123gunnies
gustoes879873gustoes
hances115621283hanc_es
haunches1656963haunches
hulloes104113923hulloes
hunched163710493hunched
hunkies143214503hunkies
hutches153613523hutches
inches114419673_inches
incogs937903_incogs
incomes11712373_incomes
janes124928123jan__es
jangles154015683jangles
jaunce15367433jaunc_e_
jaunced17335473jaunc_ed
jennies143511623jennies
jingkoes20273723jingkoes
jingles153816383jingles
jinxes20428233jin_xes
jocose1537103j_ocose
joes116635893j___oes
jones125028183jon__es
joneses1438963joneses
jounce153310733jounc_e_
jounced17337613jounc_ed
jouncier1734423jouncier
jounciest1844613jounciest
jubes145420743ju__bes
jubiles16289373jubiles
juco134716203ju_co__
judases1534443judases
judges153713453ju_dges
judos134711733ju_do_s
juggles164510843juggles
juice14311323juic_e_
juiced1636513juic_ed
juicer1536283juic_er
juicers1636153juicers
juicier1635463juicier
juiciest1736923juiciest
jujubes1542083jujubes
jukes165319103ju__kes
jumbles183013323jumbles
jumbos17379123jumbo_s
junctions1835943junctions
junctures1844033junctures
jungle144012653jungle_
jungled16349643jungled
junior1386143junio_r
juniper1634023juniper
junipers1733933junipers
junked184311693jun_ked
junker174213653jun_ker
junkers184010863junkers
junket173815023jun_ket
junkets18377623junkets
junkie17339603junkie_
junkier18339493junkier
junkiest192610173junkiest
junkmen2033633junkmen
junks164815973jun__ks
juntas134210503jun_tas
junto125114563junto__
jupes145218553ju__pes
jupons15377803ju_pons
juries134120633ju_ries
jurors1338283ju_rors
justles143311433justles
jutes125125133ju__tes
jutties143814003jutties
kenches163912273kenches
lances84824103lanc_es
launces9329003launc_es
launches1387903launches
lingoes84014693lingoes
locoes85516583_locoes
luces75528433lu_c_es
lucres84513303lu_cres
lunacies1038013lunacies
lunched133911823lunched
luncher123111413luncher
lunchers13349563lunchers
lunes55337773lun__es
lungees84412143lungees
lunges76123423lun_ges
lunies64723013lun_ies
lunules738953lunules
lurches123311663lurches
lynches15378873lynches
manches143818623manches
mangoes104316133mangoes
minces104420803minc_es
mongoes103415713mongoes
muches134718993mu_ches
mucors104410853mu_cors
mucose10149313mu_cose
mucous104411653mu_cous
mulches143210673mulches
munched153411073munched
muncher143610373muncher
munchers15318773munchers
munchies1539253munchies
mungos94311373mungo_s
muscles11310563muscles
mutches143314283mutches
nances83618643nanc_es
nancies93516843nancies
noes45845393__n_oes
nonces84418833nonc_es
noncoms1139203noncoms
nuances938523nuanc_es
nuncios937113nuncios
nuncle839363nuncle_
ouches114322183ou_ches
ounce77019933ounc_e_
outcomes1239763outcomes
outdoes8313123outdoes
outgoes8312643outgoes
paunches1568173paunches
pinches144117933pinches
pingoes105116523pingoes
pinkoes135512313pinkoes
pintoes95117713pintoes
ponces104720843ponc_es
pounces114113893pounc_es
puces94924633pu_c_es
punched153512173punched
puncher143311673puncher
punchers152610073punchers
pungles104013713pungles
punkies134216803punkies
punties94520783punties
puntos85915793punto_s
quenches2236013quenches
quiches2139333quiches
quinces183210433quinc_es
rances84625443ranc_es
ranches123620113ranches
rancors9811373rancors
raunches1368053raunches
roscoes9310923roscoes
ruches114819583ru_ches
rundles83214713rundles
runes55530223run__es
runkles114111943runkles
stuccoes1254273stuccoes
subcodes1338143subcodes
succors1137413succors
sucres84218893su_cres
sunbows1236023sunbows
sunchokes1864733sunchokes
sundaes8313093sundaes
sundogs947103sundogs
syncoms1435943syncoms
syncopes1545763syncopes
tenches123515523tenches
tunes55332193tun__es
tunicles10217133tunicles
tunnies73614263tunnies
tusches1237903tusches
unboxes16208303_unboxes
uncages103213773_uncages
uncakes133012743_uncakes
uncaps1039813_uncaps
uncase83817433_uncase
uncases93516553_uncases
unchokes17227273_unchokes
uncle7317053_uncle_
unclogs1036803_unclogs
unclose91111643_unclose
uncloses10910943_uncloses
unco66021403_unco__
uncock1438563_uncock
uncocks1537233_uncocks
uncoded11312743_uncoded
uncoil8811853_uncoil
uncoils979533_uncoils
uncool8610113_uncool
uncork1239043_uncork
uncorks1337443_uncorks
uncover1239003_uncover
uncovers1336573_uncovers
uncoy104111413_unco_y
uncross938193_uncross
uncus74014983_unc_us
undies73821963_undies
undoer73113043_undoer
undoers82910583_undoers
ungues7412123_ungues
unions64216753_unions
unites65024853_unites
unrobes9269733_unrobes
unties64326923_unties
unyokes1466733_unyokes
wenches152914133wenches
winces114819113winc_es
winches154714373winches
winoes94317013win_oes
zincous1837053zincous

Search took 9 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272868.25016245.7
3Display Results2862860.0962979.2
 (SQL Overall)1786912868.50221017.5
 
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.