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

246 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
junior138614(None) 
juniors1475781juniors
bunion83111312bunion
janitor1436482janitor
junco144612202junco_
juncos15449232juncos
juniper1634022juniper
junker174213652junker
junkier18339492junkier
junto125114562junto_
juntos134110842juntos
juror1239562ju_ror
lunier64617602lunier
punier84519222punier
senior63214052senior
union54519792_union
amnio75218053amnio_
amnion84812053amnion
amnios84912523amnios
anion55028813_anion
audio62917103audio_
audios72312283audios
auditor837313auditor
author939763author
bonier84321993bonier
bunco94616083bunco_
buncos104011593buncos
bunions92210473bunions
bunker124519373bunker
bunko115514513bunko_
bunkos124210323bunkos
bunter85020383bunter
burier84324653burier
busier85219723busier
candor94516423candor
cantor85621523cantor
censor84011293censor
condor94616973condor
cuniform1555023cuniform
cunner83915003cunner
curio74221213curio_
curios83218333curios
cursor84110293cursor
danio6319783danio_
danios7314603danios
denier74420693denier
donor64418193don_or
dungier9368583dungier
dunite7315013dunite
dunker113616463dunker
dunner73913823dunner
durion7510963durion
fanion94514323fanion
fugio9310923fugio_
fugios1037583fugios
fumier11310903fumier
functor1235203functor
funder104016083funder
fungo94413133fungo_
funker133915763funker
funkier14349983funkier
funner93414103funner
funnier103210173funnier
furor8312393fu_ror
fusion939773fusion
genitor837273genitor
gonion73612833gonion
grunion835433grunion
guiro63712093gu_iro
gundog935793gundog
gunite7414403gunite
gunkier12369553gunkier
gunner73813983gunner
havior1248203havior
honor85718623hon_or
humidor1343533humidor
humor101110513hu_mor
hunger104015203hunger
hunker133917673hunker
hunkier144512143hunkier
hunter94817773hunter
ignitor8125263ignitor
inion54620183_inion
jailor13418573jailor
janiform2044723janiform
janitors1536853janitors
jauntier1535233jauntier
jingo134615213jingo_
jinker174013543jinker
jivier16438613jivier
joiner134114133joiner
jokier17618753jokier
jouncier1734423jouncier
jubile152910263jubile
juco134716203ju_co_
jucos144111713ju_cos
judder15439423judder
judger154411453judger
judo125315313ju_do_
judos134711733ju_dos
juice14311323ju_ice
juicer1536283juicer
juicier1635463juicier
juicy1738283ju_icy
juking183810473juking
jumbo164311073jumbo_
jumbos17379123jumbos
jumper173612373jumper
jumpier18317943jumpier
jun105932063jun___
juncoes16338073juncoes
junction1736203junction
jungle144012653jungle
junglier1644303junglier
jungly17407693jungly
juniorate1644013juniorate
juniority1943113juniority
junipers1733933junipers
junk155121033jun__k
junked184311693junked
junkers184010863junkers
junket173815023junket
junkie17339603junkie
junkies183711693junkies
junking193910073junking
junks164815973jun_ks
junky194513233jun_ky
junta123713673jun_ta
juntas134210503juntas
jupon14479193ju_pon
juried144212443juried
juries134120633juries
jurist134616393jurist
jurors1338283ju_rors
juster134617013juster
linier64423793linier
lunar57017313lun_ar
lunger75720423lunger
lunies64723013lunies
lunker104718343lunker
manioc103914823manioc
manor78023933man_or
mentor8414363mentor
minion83416243minion
minor74920063min_or
monitor9310723monitor
mucor94011943mu_cor
mungo84916053mungo_
mungos94311373mungos
muni65824413muni__
munis75022003muni_s
munnion935863munnion
noir46722433__noir
nor38048823__n_or
nuncio837973nuncio_
nuncios937113nuncios
onion54320973_onion
panier84425503panier
pavior1138533pavior
pinier84024693pinier
pinion83815893pinion
prior74316173_prior
punily11311773punily
punish111411513punish
punitory1345603punitory
punker123718823punker
punkier133512793punkier
punner84918153punner
punnier93511263punnier
punter84320023punter
punto75121323punto_
puntos85915793puntos
quinoa15377653quinoa
quinol15357973quinol
rancor8810373rancor
reunion737673reunion
ronion63315643ronion
rubier84814743rubier
ruiner64013643ruiner
rulier65016353rulier
rumor71011323ru_mor
runic73615773runi_c
runner63814463runner
runnier74010113runnier
runtier73512853runtier
savior9710173savior
senhor93010813senhor
seniors73413623seniors
senor53822803sen_or
sensor63813843sensor
signior835043signior
spinor839943spinor
succor1036623succor
sudor6312623su_dor
suitor63311053suitor
sunbow1145823sunbow
sunder74019823sunder
sundog837613sundog
sunnier73412153sunnier
tenor53620253ten_or
tensor63812673tensor
tinier63622233tinier
tonier65520713tonier
tumor71110693tu_mor
tuner56022683tun_er
tunic74018223tuni_c
tunica8379813tunica
tunics83811263tunics
tuning74016843tuning
turgor736863turgor
turion6313163turion
tussor6378233tussor
tutor5712493tu_tor
unbar71913613_unbar
unborn83310813_unborn
unbox1438753_unbox
unco66021403_unco_
uncork1239043_uncork
uncos74117033_uncos
uncoy104111413_uncoy
under64624213_under
undo55620163_undo_
undoer73113043_undoer
ungot61718063_ungot
unicorn946513_unicorn
uniform1247053_uniform
unify113611113_unify
unions64216753_unions
unipod946853_unipod
unison649033_unison
unit45140073_uni_t
unite54828383_unite
uniter64619143_uniter
units54923433_units
unity84918493_unity
unmoor836313_unmoor
unto45824283_unto_
untorn63012343_untorn
unwon84512343_unwon
unworn93411333_unworn
vendor10359803vendor
vinier93716743vinier
wanier93920683wanier
wanion93213063wanion
winier94522453winier
zanier154314713zanier

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.406440125.6
2DLD Change Limit1127162465.83019333.8
3Display Results2462460.0763236.8
 (SQL Overall)1786912466.31228309.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.