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

249 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
tamers8422403(None) 
gamers94420831gamers
namers84517331namers
tabers84621571tabers
takers103923741takers
talers64628141talers
tamer75230101tamer_
tames75242011tame_s
tampers113516741tampers
tapers84025811tapers
taters64932201taters
tawers94118601tawers
taxers134015281taxers
timers84420991timers
agers65027852_agers
aimers84621912aimers
ambers104519582_ambers
ameers84015572_ameers
amens75624842_amens
amirs75924922_amirs
apers76629132_apers
armers85520272armers
avers85127312_avers
bakers125323452bakers
balers85626932balers
blamers115314212blamers
cabers105023922cabers
cagers95624192cagers
cambers134017442cambers
camels105217082camels
cameos105818002cameos
camera10313692camera
cameras11313362cameras
cames97047312came_s
campers134220292campers
caners84629202caners
capers105428142capers
carers85133962carers
caters85336502caters
cavers115026842cavers
comers105328082comers
damars93815002damars
dames85435852dame_s
dammers123214272dammers
damners104112112damners
dampers123915692dampers
darers75921872darers
daters74827372daters
dimers94321092dimers
eagers74523682eagers
eaters65535952eaters
emmers104013222emmers
facers115519442facers
faders105117462faders
fakers134219532fakers
fames105735922fame_s
farers95924052farers
farmers124315262farmers
flamers124616362flamers
foamers123812102foamers
framers125113822framers
fumers113613382fumers
gagers84021332gagers
gamer84928942gamer_
games86238552game_s
gammers123214562gammers
gapers94520472gapers
gaters74728642gaters
gazers164516302gazers
gomers94116882gomers
halers94926912halers
hames106138702hame_s
hammers144216062hammers
hampers143616952hampers
harmers124116592harmers
haters94930402haters
havers124721482havers
hayers124415942hayers
hazers184615952hazers
homers114821982homers
jagers144415722jagers
jammers183710702jammers
japers154616172japers
kames115024692kame_s
lacers85225252lacers
laders74927762laders
lagers74826142lagers
lakers105225152lakers
lambers113817112lambers
lameds94812032lameds
lamer75233702lamer_
lames75445542lame_s
lampers113817332lampers
lasers64925702lasers
lavers94526362lavers
layers93921182layers
macers105321272macers
maimers113813042maimers
makers123921732makers
mameys13449522mameys
mammers104615692mammers
mamzers20409162mamzers
masers84623452masers
maters85032392maters
mazers173917092mazers
metamers1249622metamers
mimers105520182mimers
namer75622102namer_
names74833362name_s
oaters65029792oaters
omers76923192_omers
ormers84316142ormers
pacers105124542pacers
pagers94423252pagers
palmers113513622palmers
pampers133615932pampers
papers105125322papers
parers85530742parers
paters84935832paters
pavers115021822pavers
pawers114818782pawers
payers114621822payers
racers84725432racers
rakers104123572rakers
ramees84620892ramees
ramets83517392ramets
rammers113715042rammers
rapers84327182rapers
rasers64526782rasers
raters63936582raters
ravers94628182ravers
razers154919612razers
reamers94221082reamers
rimers84522552rimers
roamers93713462roamers
sabers85224732sabers
sakers104125432sakers
sameks12409322sameks
savers93825922savers
sawers94620162sawers
sayers94221592sayers
seamers94719432seamers
stagers84116672stagers
stamens93411482stamens
stammers123611522stammers
stampers124211602stampers
starers74522312starers
staters73922342staters
stayers103813632stayers
steamers103410872steamers
taber73825822taber_
tabes76033922tabe_s
tabors84517112tabors
taces76237802tace_s
tackers134319622tackers
taels56822072ta_els
taggers93514192taggers
tahrs85412332ta_hrs
tailers73720182tailers
tajes124920692taje_s
taker95229002taker_
takes94437792take_s
talars66021682talars
taler56034862taler_
tales55451372tale_s
talkers113513212talkers
tamals84116632tamals
tamari8313412tamari
tamaris9413602tamaris
tamburs11288612tamburs
tame66343662tame__
tamed85528512tame_d
tamein8313092tamein
tameins9311422tameins
tamely113711952tamely
tamest85721292tamest
tamis76728732tam_is
tamper104618512tamper_
tamps95524082tam_ps
tams67247932tam__s
tankers113416912tankers
tanners74018392tanners
taper74829772taper_
tapes75838602tape_s
tapirs84113172tapirs
tappers113416542tappers
tares57456562tare_s
tarres64723042tarres
tars46763952ta__rs
tasters74225642tasters
tatars64619792tatars
tater54138612tater_
tates55444982tate_s
tatters74520482tatters
tavern9428932tavern
taverns10317802taverns
tawer85223442tawer_
taxer125019362taxer_
taxes124730822taxe_s
tearers75218232tearers
teasers75317242teasers
teemers95012902teemers
tempers113513012tempers
termers95414502termers
thalers106212262thalers
thawers13428482thawers
tiers55526522t_iers
tigers75616512tigers
tilers63523502tilers
timbers113111852timbers
timer75626042timer_
times75630822time_s
titers64526412titers
tokers104818892tokers
tomes76037382tome_s
toners64128002toners
topers85025322topers
toters65026362toters
towers94423672towers
toyers95516332toyers
tracers94917842tracers
traders84316952traders
tramels93812492tramels
trampers123210392trampers
triers64321522triers
trimers94615142trimers
tubers85017032tubers
tumors8810612tumors
tuners64417342tuners
tuyers94612562tuyers
twiers95410162twiers
twyers12497412twyers
tyers86220052t_yers
vampers143111622vampers
vitamers1334682vitamers
vomers115614942vomers
waders109120642waders
wafers124316142wafers
wagers105122202wagers
wakers134822492wakers
walers94824462walers
wames106432802wame_s
warmers124514292warmers
waters95030632waters
wavers125022472wavers
waxers164014302waxers
yagers105114532yagers
yamens114010822yamens
yammers143410322yammers

Search took 4 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 Filter178691825510.360496363.9
2DLD Change Limit825512492.57632046.2
3Display Results2492490.0803112.5
 (SQL Overall)1786912493.01659247.7
 
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.