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

479 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
joes11663589(None) 
does56554471does
foes76543441foes
goes55644091goes
hoes75755731hoes
jees115938541jees
jobs136529431jobs
joe106642351joe_
joey145719331joey
joeys15518041joeys
jogs127129331jogs
jokes165423331jokes
joles125230831joles
jones125028181jones
joss115925591joss
jots116336141jots
jows146632091jows
joys146624661joys
noes45845391noes
oes35866191_oes
roes45954131roes
toes46956441toes
voes75432821voes
woes76440661woes
aces67645092aces
ages55844592ages
ales47067102ales
aloes54933672aloes
anes45255932anes
apes66047432apes
ares45871022ares
ates45047922ates
aves76142602aves
awes76037552awes
axes117337852axes
ayes76543512ayes
bees65453382bees
bes56557432_bes
boas66150832boas
bobs86340652bobs
bodes84935102bodes
bods76244712bods
bogs75742752bogs
boles75448602boles
bones76446532bones
boos67955032boos
bops86037982bops
bores76448252bores
bos57966812bo_s
boss65938342boss
bots66453952bots
bows96242862bows
boxes145625072boxes
boys96737332boys
byes95230532byes
cees65941592cees
cobs87043142cobs
codes86247292codes
cods76848102cods
coed77140542coed
coeds85920162coeds
cogs77340032cogs
cokes115537192cokes
coles76055062coles
cols66553082cols
comes97246992comes
cones76457422cones
cons66057692cons
coos67456492coos
copes97747102copes
cops86751372cops
cores76361852cores
cors66656442cors
cos510270392co_s
coses76949492coses
coss66143492coss
cotes76347842cotes
cots68054842cots
coves105539172coves
cows97046642cows
coxes145430862coxes
coys97537242coys
cozes166033242cozes
cues65438982cues
dees56356632dees
dies55653522dies
docs75631152docs
doe47361952doe_
doer57734702doer
doers65225712doers
doest65829522doest
doges75630162doges
dogs66440152dogs
doles67843752doles
dols56943052dols
domes85735562domes
doms76239572doms
dons56048702dons
dopes84935042dopes
dors56747602dors
dos48062312do_s
dose56442432dose
doses65938502doses
doss56235042doss
dotes65836692dotes
dots55647662dots
doves94728152doves
dows85941052dows
dozes155226302dozes
dues56045502dues
dyes85331892dyes
ekes86726602ekes
emes65434662emes
eons46638712eons
es29048222__es
eses45336102eses
eves76230462eves
ewes76328702ewes
exes116530812exes
eyes75837882eyes
fees76450602fees
fes66551672_fes
floes85528142floes
fobs96034272fobs
foe66350812foe_
fogs87035002fogs
fons76943892fons
fops96532682fops
fores85847102fores
foss76431642foss
foxes156321092foxes
foys105628292foys
froes86126692froes
gaes56348032gaes
gees55647882gees
gies55641422gies
goas55239942goas
gobs76935572gobs
gods65438042gods
goer56827102goer
goers65520252goers
goos57644912goos
gores65740372gores
gos47155132go_s
goxes135018262goxes
goys86328412goys
haes77651022haes
hes66654202_hes
hies74842832hies
hobs97038982hobs
hods87239862hods
hoe67562722hoe_
hoed87837982hoed
hoer76533982hoer
hoers85724922hoers
hogs87139662hogs
hokes126231642hokes
holes84748652holes
hols76946292hols
homes106938812homes
hones88144492hones
hons77350782hons
hopes105835642hopes
hops97942632hops
hos68364192ho_s
hose76547242hose
hoses85443172hoses
hots78349322hots
howes114730262howes
hows106345602hows
hoys107733932hoys
hues75235232hues
ices66129642ices
ides57734232ides
ions46737852ions
ires45639282ires
jabs135830092jabs
jades135222112jades
jags126132792jags
jakes165023642jakes
jams135231072jams
janes124928122janes
japes146322822japes
jars117338352jars
jaws145027292jaws
jays146328342jays
jee106648642j_ee
jeed125428502jeed
jeep135624842jeep
jeeps144715372jeeps
jeer115426462jeer
jeers124818132jeers
jeez205622032jeez
jefes155613672jefes
jeon116821442jeon
jess116022032jess
jest116738502j_est
jet106754822j_et
jetes124922842jetes
jets115834102jets
jeu105532072j_eu
jew135129082j_ew
jews145822082jews
jibes145520322jibes
jibs136724082jibs
jigs126524762jigs
jins115635012jins
jives154820812jives
jo99539602jo__
job128041772jo_b
jock176522642jock
jocks185118082jocks
jog117438312jo_g
john145512902john
johns15398712johns
join116724832join
joins125818412joins
joist125125652joist
joke155926162joke
joked175217912joked
joker165715892joker
jokers175511192jokers
jokey195014692jokey
joky186215312joky
jole117233822jole
jolt116639122jolt
jolts125018882jolts
josh145117612josh
joshes165114852joshes
josses135117682josses
jot108259022jo_t
jota116423622jota
jotas125717442jotas
jouk156015992jouk
jouks165612342jouks
joules134116822joules
joust125122292joust
jow137639302jo_w
jowed164724422jowed
jowl146120302jowl
jowls156214522jowls
joy137036362jo_y
joyed164811832joyed
jubes145420742jubes
jugs125525602jugs
jukes165319102jukes
jupes145218552jupes
jus106930222j_us
jutes125125132jutes
juts115930162juts
kaes85734062kaes
koas85635092koas
kobs105831082kobs
koel84519942koel
koels94613902koels
kois85129392kois
kops107031292kops
kors85933012kors
kos76944822ko_s
koss85224812koss
kues86426772kues
kyes115124932kyes
lees45455882lees
les35663072_les
lies46454192lies
lobes75331002lobes
lobs66441082lobs
lodes66436912lodes
loess55714702loess
loges66534202loges
logs57343112logs
loos49051122loos
lopes76437342lopes
lops66043352lops
lores55045402lores
lose45144582lose
loses56742012loses
loss45337962loss
lots47652092lots
loves85332012loves
lowes85732462lowes
lows75843012lows
loxes125227472loxes
lues45943552lues
lyes75530832lyes
maes66948392maes
moas65545342moas
mobs85737372mobs
mocs85834902mocs
modes85537412modes
mods77945052mods
mogs75439332mogs
mojoes15399522mojoes
mokes114631032mokes
moles74747922moles
mols65948572mols
momes95134472momes
moms86539482moms
mons68152252mons
moos66051302moos
mopes95134982mopes
mops85940132mops
mores76249642mores
mors65950062mors
mos57067122mo_s
moss67641032moss
motes75944002motes
mots66853162mots
moues75732842moues
moves106128422moves
mows96340832mows
nobs66436902nobs
nodes64633492nodes
nods55838222nods
noel45226552noel
noels56418702noels
nogs56534612nogs
nomes74933122nomes
noms65636402noms
nones55639132nones
nos38859322no_s
nose46739362nose
noses55435642noses
notes55034582notes
nous46136982nous
nows75738232nows
obes66036832obes
oboes75717712oboes
odes57243242odes
ods47546212_ods
oe28473062_oe_
ohs66232312_ohs
okes84936342okes
oles46453472oles
oms56337512_oms
ones46146532ones
ons36148512_ons
oohs75220692oohs
oops65232672oops
oots46446442oots
oozes145418712oozes
opes65942612opes
ops56641252_ops
ores46056682ores
ors35750112_ors
os211359882_o_s
ose38147342_ose
oses46641512oses
owes75137102owes
oxes116530722oxes
oyes74940132oyes
pees65257372pees
pes57259782_pes
pies66949602pies
pods76540152pods
poem86225772poem
poems95715552poems
poesy105014062poesy
poet65552902poet
poets76024442poets
pois66539042pois
pokes116133012pokes
poles75351002poles
pols66044562pols
pomes94833932pomes
poms87037742poms
pones74547042pones
pons65850602pons
poos65949112poos
popes95933812popes
pops86340952pops
pores75849032pores
pose66441732pose
poses74642762poses
pots66452362pots
pows95537662pows
poxes145325722poxes
pyes95528992pyes
rees45364192rees
res35565042_res
robes75133302robes
robs65837872robs
rocs65533662rocs
rodes614039082rodes
rods56442062rods
roe36861072roe_
roles56747982roles
roms67038962roms
ropes75940062ropes
rose46148902rose
roses56445772roses
rotes56143902rotes
rots46454092rots
roues56039352roues
roves84834482roves
rows75941752rows
rues46044482rues
ryes75529352ryes
sees45361052sees
shes75734352shes
shoes85429652shoes
sloes54728872sloes
sobs64941752sobs
sods54940212sods
sokes95031422sokes
soles55547922soles
sols45448162sols
soms66239372soms
sones55444142sones
sons46049552sons
sops65244562sops
sores55454282sores
sos37761602so_s
sots45552442sots
sous46947212sous
sows75342492sows
soys75233932soys
sues46247652sues
tees45353582tees
ties45248312ties
tods56141842tods
toe310166852toe_
toea46732332toea
toeas55726422toeas
toed56137042toed
togs57242432togs
tokes95234972tokes
toles55147132toles
tomes76037382tomes
toms68343492toms
tones56048662tones
tons46553052tons
topes76941762topes
tops66248122tops
tores55352672tores
tors46157382tors
toss45637972toss
totes55139682totes
tots46654122tots
tows78545552tows
toys78036342toys
tres46542902tres
tyes76433372tyes
ukes86122812ukes
uses44931112uses
utes45930882utes
vees75439432vees
vies75238622vies
voces105918052voces
voe67739052voe_
voles86234042voles
votes84627082votes
vows106626942vows
waes76048602waes
wees76249122wees
woe66651242woe_
wogs86531402wogs
woks116224902woks
wons74942042wons
woos76238802woos
wops96634152wops
wos66953532wo_s
wots76342892wots
wows104633492wows
wyes105727502wyes
yes66250612_yes
yobs96028082yobs
yods86531182yods
yokes125223022yokes
yoks116223742yoks
yores85031322yores
yous76230652yous
yowes114926372yowes
yows106433122yows
zees136331892zees
zoea137118422zoea
zoeas145815612zoeas
zones145528042zones
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.0762351197.4
2DLD Change Limit298724790.98330388.6
3Display Results4794790.1104354.5
 (SQL Overall)1786914791.169152858.0
 
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.