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

357 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
aper6633623(None) 
ager55935841ager
ape57251181ape_
aped78538151aped
apers76629131apers
apery106517901apery
apes66047431apes
apex137220211apex
apter76120201apter
asper75520431asper
aver75931881aver
caper94831621caper
gaper86125121gaper
japer146218881japer
paper95128661paper
per56353091_per
raper74932751raper
taper74829771taper
abed79734132abed
abet610547942abet
abler75624312abler
ace59656832ace_
aced79540882aced
acerb9312762acerb
aces67645092aces
acre67330772acre
adder75419592adder
ae212590292a_e_
aero45435342a_ero
aery77231682a_ery
afar76720782afar
after85719792after
agar58726412agar
age47154332age_
aged67334252aged
agee56241492agee
agers65027852agers
ages55844592ages
agger76420892agger
ahed89536252ahed
ahem97225362ahem
aider65431132aider
aimer75926822aimer
air38058392a_ir
airer54927892airer
aiver85725162aiver
ajar116217702ajar
ajee115928232ajee
akee85936812akee
alar46340072alar
alder65421912alder
ale36572342ale_
alec66430062alec
alee46652322alee
alef76340692alef
alert54740652alert
ales47067102ales
alter54828502alter
amber94523212amber
ameer75618982ameer
amen66733152amen
amir65129752amir
amped104820512amped
ampere10514412ampere
ampler104313302ampler
ane37866952ane_
anear55420322anear
anes45255932anes
anew76623132anew
anger66225872anger
apart74330672apart
apeak115513452apeak
apeek114711872apeek
apercu1057382apercu
apnea73413412apnea
apo511142122ap_o
apod78123182apod
aport75432172aport
apos65433822apos
app76827602ap_p
appear10379342appear
appel94615892appel
apps86319692apps
apres75426402apres
apse67725382apse
apses76823912apses
apt57352542ap_t
ar211379382a__r
are37874572are_
area45843392area
ares45871022ares
armer76924442armer
arpen74418042arpen
asea46327182asea
asker96418782asker
aspen75216092aspen
aspers86220312aspers
aster55434892aster
ate37059242ate_
ates45047922ates
auger64922472auger
ave67748702ave_
avers85127312avers
avert86029492avert
aves76142602aves
awe67746622awe_
awed88436032awed
awee76336642awee
awes76037552awes
axe108239492axe_
axed128829612axed
axel115222072axel
axes117337852axes
aye67151762aye_
ayes76543512ayes
baker115629542baker
baler75635272baler
barer74535802barer
baser74828922baser
beer65635992beer
bier65531832bier
caber95126832caber
cager85229222cager
camper124722212camper
caner75334772caner
cape87242782cape_
caped104931802caped
capers105428142capers
capes95441922capes
capper124421982capper
carer74942332carer
carper104923632carper
cater74840722cater
caver105629062caver
coper95336092coper
damper114117752damper
dapper114016632dapper
darer65230792darer
dater65332312dater
deer56739022deer
diaper94513112diaper
doer57734702doer
doper86128392doper
draper94315692draper
duper85519002duper
dyer85522112dyer
eager65526962eager
eater54639842eater
eger55923562eger
epee64628502epee
er28345142__er
ever77027692ever
ewer77523982ewer
eyer76127282eyer
facer105525052facer
fader94421512fader
faker124824592faker
farer86733142farer
fer66646122_fer
gager74726292gager
gamer84928942gamer
gape75134512gape_
gaped96123532gaped
gapers94520472gapers
gapes86030822gapes
gasper94515542gasper
gater64533652gater
gawper12499692gawper
gayer94519192gayer
gazer155720072gazer
goer56827102goer
haler85033522haler
hamper134518652hamper
harper115018402harper
hater85034752hater
haver115124462haver
hayer114620242hayer
hazer174820232hazer
heaper114119522heaper
her66547812_her
hoer76533982hoer
hoper105829142hoper
hyper135213902hyper
jager134318132jager
jape134923422jape_
japed156217632japed
japers154616172japers
japery18439142japery
japes146322822japes
jasper154610382jasper
jeer115426462jeer
kier86526802kier
lacer75833752lacer
lader65633722lader
lager65132862lager
laker95432872laker
lamer75233702lamer
lapel73716682lapel
lapper104319952lapper
lapser84113142lapser
laser54633322laser
later54843922later
laver85031792laver
laxer125420332laxer
layer84626472layer
leaper88118942leaper
leer46239352leer
leper74820742leper
lier45942462lier
loper75129232loper
macer912126942macer
maker114127812maker
mapper124516092mapper
maser75029972maser
mater74438862mater
mazer165722422mazer
moper94925922moper
namer75622102namer
nape65230802nape_
napery11489812napery
napes74828462napes
napper103718282napper
oater55433732oater
omer67028392omer
ope56845242ope_
oped76230152oped
open66427002open
opera7313572opera
opes65942612opes
over77227342over
oyer75927652oyer
pacer96131612pacer
pager84728202pager
pair66031512pair
paler75436932paler
pamper124316662pamper
papers105125322papers
papery134812742papery
par57467022_par
pare66760842pare
parer75839902parer
parr65731152parr
pater74740722pater
pauper103511942pauper
paver104225832paver
pawer104422972pawer
payer105125722payer
pe47649032_pe_
pea56657242_pea
pear69745232_pear
pec76744412_pec
ped66751522_ped
pee56066512_pee
peer66238352peer
peg65843062_peg
peh86740962_peh
pen56558842_pen
pep76447082_pep
pere66450262_pere
peri65636972_peri
perk106232842_perk
perm85834632_perm
perp89029892_perp
pert66759322_pert
perv97224812_perv
pes57259782_pes
pet56477302_pet
pew86442302_pew
pier66035292pier
piper96523192piper
pur56840552_pur
racer75233022racer
raker94529792raker
rape65041632rape_
raped85334622raped
rapers84327182rapers
rapes75740722rapes
rapier84019992rapier
rapper104621572rapper
rarer54731702rarer
raser55633412raser
rasper83917332rasper
rater54943282rater
raver85631492raver
rawer84623732rawer
razer144824272razer
reaper84223142reaper
riper74328402riper
roper75431912roper
ruer46127562ruer
saber75330242saber
safer84721812safer
sager65432052sager
saker95132022saker
saner54334322saner
sapor75119252sapor
sapper103822352sapper
saver84831252saver
sawer85026212sawer
sayer84926552sayer
seer45547042seer
ser36752402_ser
shaper114119932shaper
soaper84517872soaper
spar65433302spar
spear75821062spear
spec85821972spec
sped76031492sped
speer74623902speer
speir75315362speir
sperm93216012sperm
spew95421872spew
spier75728032spier
spur65321192spur
suer45334032suer
super74924482super
taber73825822taber
taker95229002taker
taler56034862taler
tamer75230102tamer
tamper104618512tamper
tape64538142tape_
taped85327422taped
tapers84025812tapers
tapes75838602tapes
tapir75917062tapir
tapper104419612tapper
tater54138612tater
tawer85223442tawer
taxer125019362taxer
tier44936142tier
toper75231022toper
tyer75323392tyer
upper93714262upper
user45023002user
vamper134212652vamper
vapor104013092vapor
veer76229572veer
vier75428152vier
viper105017302viper
wader95325362wader
wafer114417642wafer
wager95925052wager
waker125526592waker
waler84229262waler
warper114015582warper
water84733312water
waver115025702waver
waxer154317482waxer
weer75535092weer
wiper105421292wiper
yager95616752yager
yapper133714512yapper
yarer84321572yarer
yauper11368542yauper
yawper14437952yawper
zapper193414022zapper

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 Filter178691298720.1401276364.3
2DLD Change Limit298723571.92315534.1
3Display Results3573570.1702100.0
 (SQL Overall)1786913572.23380022.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.