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

248 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
tapers8402581(None) 
apers76629131_apers
capers105428141capers
gapers94520471gapers
japers154616171japers
papers105125321papers
rapers84327181rapers
tabers84621571tabers
takers103923741takers
talers64628151talers
tamers84224031tamers
tampers113516741tampers
taper74829771taper_
tapes75838601tape_s
tapirs84113171tapirs
tappers113416541tappers
taters64932201taters
tawers94118601tawers
taxers134015281taxers
topers85025321topers
agers65027852_agers
aper66336232_aper_
apery106517902_apery
apes66047432_ape_s
apres75426402_apres
aspers86220312aspers
avers85127312_avers
bakers125323452bakers
balers85626942balers
cabers105023922cabers
cagers95624192cagers
campers134220292campers
caners84629202caners
caper94831622caper_
capes95441922cape_s
cappers134419402cappers
carers85133962carers
carpers114521252carpers
caters85336502caters
cavers115026842cavers
copers104629842copers
dampers123915692dampers
darers75921872darers
daters74827372daters
diapers104713912diapers
dopers95522482dopers
drapers105313352drapers
dupers94615602dupers
eagers74523682eagers
eaters65535952eaters
etapes85415292etape_s
facers115519442facers
faders105117462faders
fakers134219532fakers
farers95924052farers
gagers84021332gagers
gamers94420832gamers
gaper86125122gaper_
gapes86030822gape_s
gaspers105014132gaspers
gaters74728642gaters
gawpers13448312gawpers
gazers164516302gazers
halers94926922halers
hampers143616952hampers
harpers124916202harpers
haters94930402haters
havers124721482havers
hayers124415942hayers
hazers184615952hazers
heapers123616672heapers
hopers114222972hopers
hypers144811912hypers
jagers144415722jagers
japer146218882japer_
japery18439142japery
japes146322822jape_s
jaspers164310462jaspers
lacers85225252lacers
laders74927762laders
lagers74826142lagers
lakers105225152lakers
lampers113817332lampers
lapels83712042lapels
lappers113717462lappers
lapsers93911052lapsers
lasers64925702lasers
lavers94526362lavers
layers93921182layers
leapers93716662leapers
lepers84817322lepers
lopers84424142lopers
macers105321272macers
makers123921732makers
mappers133313782mappers
masers84623452masers
maters85032392maters
mazers173917092mazers
mopers104220372mopers
namers84517332namers
napery11489812napery
napes74828462nape_s
nappers114214862nappers
oaters65029792oaters
pacers105124542pacers
pagers94423252pagers
pampers133615932pampers
paper95128662paper_
papery134812742papery
parers85530742parers
paters84935842paters
paupers114311072paupers
pavers115021822pavers
pawers114818782pawers
payers114621822payers
pipers104318662pipers
racers84725432racers
rakers104123572rakers
raper74932752raper_
rapes75740722rape_s
rapiers95012872rapiers
rappers113618442rappers
rasers64526782rasers
raspers94415922raspers
raters63936582raters
ravers94628182ravers
razers154919612razers
reapers93520452reapers
ropers84325902ropers
sabers85224732sabers
sakers104125432sakers
sapors84118812sapors
sappers113518902sappers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
shapers124016892shapers
soapers93715922soapers
stagers84116672stagers
stampers124211602stampers
stapes85028732stape_s
staplers103111202staplers
starers74522312starers
staters73922342staters
stayers103813632stayers
stopers94217372stopers
supers84622402supers
taber73825822taber_
tabes76033922tabe_s
tabors84517112tabors
taces76237802tace_s
tackers134319622tackers
taels56822072ta_els
taggers93514192taggers
tahrs85412332ta_hrs
tailers73720182tailers
tajes124920692taje_s
taker95229002taker_
takes94437792take_s
talars66021682talars
taler56034872taler_
tales55451372tale_s
talkers113513212talkers
tamer75230102tamer_
tames75242012tame_s
tamper104618512tamper_
tankers113416912tankers
tanners74018392tanners
tapas74627712tap_as
tape64538152tape__
taped85327422tape_d
tapered102612932tapered
taperer92511792taperer
taperers10269772taperers
tapeta8310692tapeta
tapir75917062tapir_
tapis75028862tap_is
tapper104419612tapper_
tappets113610012tappets
taps66050682tap__s
tapsters10318802tapsters
tares57456562tare_s
tarres64723042tarres
tars46763952ta__rs
tasters74225642tasters
tatars64619792tatars
tater54138612tater_
tates55444982tate_s
tatters74520482tatters
taupes8212672taupe_s
tavern9428932tavern
taverns10317802taverns
tawer85223442tawer_
taxer125019362taxer_
taxes124730822taxe_s
tearers75218232tearers
teasers75317242teasers
tempers113513012tempers
tepees84215242tepees
thalers106212262thalers
thawers13428482thawers
tiers55526522t_iers
tigers75616512tigers
tilers63523502tilers
timers84420992timers
tippers113414352tippers
titers64526412titers
tokers104818892tokers
toners64128002toners
topees85519702topees
toper75231022toper_
topes76941762tope_s
toppers113914602toppers
toters65026362toters
towers94423672towers
toyers95516332toyers
tracers94917842tracers
traders84316952traders
trampers123210392trampers
trapes85024462trape_s
trappers123711042trappers
triers64321522triers
tubers85017032tubers
tuners64417342tuners
tuyers94612562tuyers
twiers95410162twiers
twyers12497412twyers
tyers86220052t_yers
types105721062type_s
uppers102912292uppers
vampers143111622vampers
vapors113812692vapors
vipers114914532vipers
waders109120652waders
wafers124316152wafers
wagers105122212wagers
wakers134822502wakers
walers94824492walers
warpers123413582warpers
waters95030642waters
wavers125022482wavers
waxers164014312waxers
wipers115416082wipers
yagers105114532yagers
yappers144012252yappers
yaupers12337662yaupers
yawpers15346852yawpers
zappers203911632zappers

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.343520965.0
2DLD Change Limit825512482.78029694.6
3Display Results2482480.0932666.7
 (SQL Overall)1786912483.21655563.1
 
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.