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

377 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
tomes7603738(None) 
comes97246991comes
domes85735561domes
homes106938811homes
momes95134471momes
nomes74933121nomes
pomes94833931pomes
tames75242011tames
times75630821times
toes46956441to_es
tokes95234971tokes
toles55147131toles
tombs97818731tombs
tome67543191tome_
toms68343491tom_s
tones56048661tones
topes76941761topes
tores55352671tores
totes55139681totes
acmes96020652acmes
almes75126542almes
atomies93918362atomies
atoms76817562atom_s
atones65225772atones
biomes103815252biomes
bodes84935102bodes
boles75448602boles
bombes124916822bombes
bombs115818822bombs
bones76446532bones
bores76448252bores
boxes145625072boxes
bromes104719762bromes
cames97047312cames
codes86247292codes
cokes115537192cokes
coles76055062coles
comas95833002comas
combes125321732combes
combs116122962combs
come87547702come_
comer95832692comer
comers105328082comers
comet95946072comet
comets105823582comets
comps115526052comps
comtes106222812comtes
cones76457422cones
copes97747102copes
cores76361852cores
coses76949492coses
cotes76347842cotes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
cymes1210118922cymes
dames85435852dames
demes86032692demes
dimes85833042dimes
does56554472do_es
doges75630162doges
doles67843752doles
dome77240732dome_
domed95423262domed
doms76239572dom_s
dopes84935042dopes
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
emes65434662_emes
fames105735922fames
femes105626222femes
foes76543442fo_es
fores85847102fores
formes114623712formes
foxes156321092foxes
fumes105224702fumes
games86238552games
gnomes93812972gnomes
goes55644092go_es
gomer85220652gomer
gomers94116882gomers
gores65740372gores
goxes135018262goxes
hames106138702hames
hemes105031082hemes
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
home98042442home_
homed115425422homed
homer105828452homer
homers114821972homers
homey135924842homey
homeys145012872homeys
homies114524722homies
homos105921782homos
hones88144492hones
hopes105835642hopes
hoses85443172hoses
howes114730262howes
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
kames115024692kames
lames75445542lames
limes75636502limes
lobes75331002lobes
lodes66436912lodes
loges66534202loges
lopes76437342lopes
lores55045402lores
loses56742012loses
loves85332012loves
lowes85732462lowes
loxes125227472loxes
memes94927702memes
mimes95732022mimes
modes85537412modes
mokes114631032mokes
moles74747922moles
mome85239352mome_
moms86539482mom_s
momus96116112momus
mopes95134982mopes
mores76249642mores
motes75944002motes
moues75732842moues
moves106128422moves
names74833362names
nodes64633492nodes
noes45845392no_es
nomas74726412nomas
nome66038422nome_
nomen75621622nomen
nomos75919742nomos
noms65636402nom_s
nones55639132nones
noses55435642noses
notes55034582notes
obes66036832_obes
odes57243242_odes
oes35866192_o_es
okes84936342_okes
oles46453472_oles
omen66828182_omen
omens75618962_omens
omer67028392_omer
omers76923192_omers
oms56337512_om_s
ones46146532_ones
oozes145418712oozes
opes65942612_opes
ores46056682_ores
oses46641512_oses
owes75137102_owes
oxes116530722_oxes
oyes74940132_oyes
poems95715552poems
pokes116133012pokes
poles75351002poles
pome85636692pome_
pomos95321582pomos
pomps115316192pomps
poms87037742pom_s
pones74547042pones
popes95933812popes
pores75849032pores
poses74642762poses
poxes145325722poxes
ptoses83514672ptoses
rimes75634542rimes
robes75133302robes
rodes614039082rodes
roes45954142ro_es
roles56747982roles
romeo73719702romeo
romeos84013172romeos
romps94617542romps
roms67038962rom_s
ropes75940062ropes
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
semes75731582semes
sokes95031422sokes
soles55547922soles
somas76030372somas
some66040382some_
soms66239372som_s
sones55444142sones
sores55454282sores
stimes85920572stimes
stokes104821792stokes
stoles63927672stoles
stomas84816322stomas
stomps105612832stomps
stones65130032stones
stopes84525892stopes
stores65533662stores
stoves93818922stoves
tabes76033922tabes
taces76237802taces
tajes124920692tajes
takes94437792takes
tales55451372tales
tame66343662tame_
tamed85528512tamed
tamer75230102tamer
tamers84224032tamers
tamest85721292tamest
tamis76728732tamis
tamps95524082tamps
tams67247932tam_s
tapes75838602tapes
tares57456562tares
tates55444982tates
taxes124730822taxes
teems76019782teems
tees45353582t_ees
teles54536002teles
telomes9310532telomes
temps95417132temps
themes115319252themes
tholes94919782tholes
thymes144810742thymes
tides64830152tides
ties45248312t_ies
tikes95628902tikes
tiles55542102tiles
time66235012time_
timed85223612timed
timer75626042timer
timers84420992timers
tines54848422tines
tires55437492tires
toads65621072toads
tobies84521022tobies
todies74223552todies
tods56141842to_ds
toe310166852to_e_
toea46732332to_ea
toeas55726422toeas
toed56137042to_ed
toffs116016722toffs
tofts84919242tofts
tofus86415422tofus
togas67823002togas
togs57242432to_gs
togues76014242togues
toiles63923512toiles
toils54527492toils
toits55327472toits
toke86738492toke_
toked105626492toked
token95419312token
tokens104711562tokens
toker95924912toker
tokers104818892tokers
tolas54532772tolas
tole46052902tole_
toled65934922toled
tolls54728432tolls
tolus55024482tolus
tom514358052tom__
toman75724052toman
tomans85419132tomans
tomb89029652tom_b
tombed113812132tombed
tommed113310142tommed
tommies113812982tommies
tommy124712232tommy
tone46953742tone_
toned65435342toned
tonemes9311682tonemes
toner55336242toner
toners64128002toners
toney86027412toney
tongs65928462tongs
tonnes65320852tonnes
tons46553052to_ns
tonus56324302tonus
tools55325242tools
toons55027532toons
toots55331872toots
tope65946382tope_
toped85631312toped
topee76029952topee
topees85519702topees
toper75231022toper
topers85025322topers
tophes115218422tophes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122to_ps
toques154612352toques
toras55540372toras
torcs75123762torcs
tore47359322tore_
tories65435882tories
toros54336192toros
torrs53923562torrs
tors46157382to_rs
torse55833332torse
torses64727952torses
tortes64826052tortes
torts56138122torts
torus54329762torus
toshes94520102toshes
toss45637972to_ss
tosses65225392tosses
tote46643672tote_
toted64929482toted
totem74819372totem
totems86810762totems
toter55932132toter
toters65026362toters
tots46654122to_ts
tours55325892tours
touse55430672touse
touses64229672touses
touts54830392touts
towed95134582towed
towel84920522towel
towels94314642towels
tower85729202tower
towers94423672towers
towies93521192towies
towns86018882towns
tows78545552to_ws
toyed96019802toyed
toyer84521552toyer
toyers95516332toyers
toyos87519142toyos
toys78036342to_ys
trees55835762trees
tres46542902t_res
tries55742812tries
trokes104019262trokes
trompes114111622trompes
tromps104911702tromps
trones65629282trones
tropes84824352tropes
troves94719112troves
trues54925322trues
tsores65113662tsores
tubes74826452tubes
tules54532792tules
tumps95420792tumps
tunes55332192tunes
tuxes124316042tuxes
twaes86513662twaes
tyees86019452tyees
tyes76433372t_yes
tykes125817062tykes
tynes85920302tynes
types105721062types
tyres84725232tyres
voces105918052voces
voes75432822vo_es
voles86234042voles
vomer105517382vomer
vomers115614942vomers
votes84627082votes
wames106432802wames
woes76440662wo_es
wombs125813342wombs
women104619252women
yokes125223022yokes
yores85031322yores
yowes114926372yowes
zones145528042zones
zymes1924712942zymes

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 Filter178691538000.0931921408.6
2DLD Change Limit538003771.39038705.0
3Display Results3773770.1103427.3
 (SQL Overall)1786913771.593112172.6
 
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.