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

220 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
barker12482286(None) 
backer144525521backer
baker115629541ba_ker
balker124519161balker
banker124222731banker
barber104419321barber
barer74535801bar_er
barked135027311barked
barkers134318511barkers
barkier133814481barkier
barter85525371barter
burker125221171burker
darker114718691darker
larker104519241larker
marker124420391marker
parker124121371parker
armer76924442_armer
asker96418782_asker
babier103515572babier
backed155725722backed
backers153821882backers
badder103817512badder
badger105415072badger
bagger104619202bagger
bailer85425252bailer
baiter84422552baiter
bake105637512ba_ke_
baked126130772ba_ked
bakers125323452ba_kers
bakery155911002ba_kery
bakes117035372ba_kes
balder95318862balder
baler75635272ba_ler
balked135219412balked
balkers134915722balkers
balkier134111982balkier
baller83825202baller
bander93928222bander
banger94423632banger
banked135021442banked
bankers133919092bankers
banner84421502banner
banter84825332banter
barbe95328282barbe_
barbed115121312barbed
barbel104317072barbel
barbers114317502barbers
barbes104526232barbes
barbet104427882barbet
barde85330772barde_
barded105426422barded
bardes95026932bardes
bare65460522bar_e_
bared85144482bar_ed
bares75457132bar_es
barfed125416382barfed
barge85631022barge_
barged105822642barged
bargee94624442bargee
barges94528252barges
bark106242152bark__
barkeep1536362barkeep
barks115735812bark_s
barky145721612bark_y
barley115116762barley
barmen105418532barmen
barmier114313042barmier
barned95623582barned
barney115314452barney
barnier93213672barnier
barre75929542barre_
barred95725792barred
barrel84517872barrel
barren85317612barren
barres84427542barres
barret84930482barret
barrier94017732barrier
barters94223032barters
barye105021492barye_
baryes116218502baryes
baser74828922ba_ser
basher115123812basher
basked135218602basked
basket125722912basket
baster85333592baster
bather115322512bather
batter84928872batter
bawler114315052bawler
beaker125520692beaker
bearer85323912bear_er
bicker144819172bicker
biker116022562b_iker
bilker124913442bilker
birder94915492birder
birler85715082birler
blacker154513512blacker
blanker134612022blanker
boarder103910322boarder
booker124719192booker
border94419972border
borer75131272bor_er
borked135117292borked
bosker123813652bosker
bracer104620582bracer
brake116025342brake_
braked135318692braked
brakes124923122brakes
brakier133812362brakier
braver114719042braver
brawer114216332brawer
brayer115315312brayer
brazer174917532brazer
brier74527402b_rier
broker124314242broker
bucker145420462bucker
bunker124519372bunker
burger94020792burger
burier84324652burier
burke115122762burke_
burked135220882burked
burkers133716622burkers
burkes124421312burkes
burler84723832burler
burner83819202burner
burrer83718472burrer
busker125517832busker
calker124917082calker
canker124422522canker
carder94524182carder
career85822242career
carer74942332car_er
carked134024822carked
carper104923632carper
carter84932272carter
carver114420142carver
corker124720852corker
dacker134920752dacker
daiker115113032daiker
danker114319662danker
darer65230792dar_er
darked123919632darked
darken114013442darken
darkey145212422darkey
darner74017302darner
darter75320362darter
debarker15155502debarker
earner63617222earner
faker124824592fa_ker
farcer115016082farcer
farer86733142far_er
farmer115017372farmer
forker134717902forker
garner73917002garner
garter74420512garter
gawker14559352gawker
hacker154822692hacker
hanker134622092hanker
harder105022402harder
harked145422552harked
harken135116342harken
harmer114719552harmer
harper115018402harper
hawker164812662hawker
jacker194417582jacker
jerker17369042jerker
lacker125325622lacker
laker95432872la_ker
lanker104123002lanker
larder73720972larder
larger74417512larger
larked114519472larked
larkers113014512larkers
larkier113711522larkier
lurker103613292lurker
maker114127812ma_ker
marked133921622marked
markers133516102markers
market123226042market
marrer83716672marrer
masker124416102masker
mirker123712692mirker
murker123715242murker
narked114116742narked
packer144223402packer
parer75839902par_er
parked134425142parked
parkers133816872parkers
parser84822372parser
porker124917542porker
racker124824552racker
raker94529792ra_ker
ranker105021902ranker
rarer54731702rar_er
sacker125124842sacker
saker95132022sa_ker
sarkier113413312sarkier
sharker144313812sharker
sparker133914362sparker
starker114114692starker
tacker124224502tacker
taker95229002ta_ker
talker103916222talker
tanker104521122tanker
tarter64023562tarter
varier94619352varier
wacker154920122wacker
waker125526592wa_ker
walker133913992walker
wanker134219972wanker
warder104020272warder
warier93722892warier
warked144421212warked
warmer113816732warmer
warner93717222warner
warper114015582warper
worker134715112worker
yakker12405532yakker
yarder103813972yarder
yarer84321572yar_er
yarner93313062yarner

Search took 3 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.1061685764.2
2DLD Change Limit825512202.23636919.1
3Display Results2202200.0633492.1
 (SQL Overall)1786912202.40574299.8
 
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.