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

182 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
asper7552043(None) 
aper66336231a_per
asker96418781asker
aspen75216091aspen
aspers86220311aspers
aster55434891aster
gasper94515541gasper
jasper154610381jasper
rasper83917331rasper
abler75624312abler
adder75419592adder
after85719792after
ager55935842a_ger
agger76420892agger
aider65431132aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
alder65421912alder
alter54828502alter
amber94523212amber
ameer75618982ameer
amped104820512amped
ampere10514412ampere
ampler104313302ampler
anger66225872anger
answer936892answer
ape57251182a_pe_
aped78538152a_ped
apers76629132a_pers
apery106517902a_pery
apes66047432a_pes
apex137220212a_pex
appear10379342appear
appel94615892appel
apse67725382apse_
apses76823912apses
apter76120202apter
armer76924442armer
arpen74418042arpen
asea46327182as_ea
ashed97829772ashed
ashen87818672ashen
ashes86230612ashes
ashier94714832ashier
ashler9459972ashler
asked106919312asked
askers105915402askers
askew12529412askew
asp57235342asp__
aspect10612822aspect
aspens85013352aspens
asperse94210662asperse
aspic95114732aspic
aspire8612122aspire
aspirer967902aspirer
aspis74618142aspis
asps65622092asp_s
assert64922582assert
asses55629282asses
asset55932262asset
astern64815812astern
asters65631602asters
astir55517092astir
auger64922472auger
auspex1574792auspex
aver75931882a_ver
baser74828922bas_er
basher115123812basher
baster85333592baster
camper124722212camper
caper94831622caper
capper124421982capper
carper104923632carper
caster85232572caster
clasper113811862clasper
coper95336092coper
damper114117752damper
dapper114016632dapper
dasher104318982dasher
doper86128392doper
duper85519002duper
easier64218462easier
easter65027982easter
esker94412982esker
ester54727712ester
faster94625772faster
gaper86125122gaper
gasher104320372gasher
gasped104814292gasped
gaspers105014132gaspers
gasser75017772gasser
gaster75027352gaster
gawper12499692gawper
grasper10389792grasper
hamper134518652hamper
harper115018402harper
hasped125014442hasped
hoper105829142hoper
hyper135213902hyper
japer146218882japer
jaspers164310462jaspers
jaspery19405252jaspery
kasher134915032kasher
lapper104319952lapper
lapser84113142lapser
laser54633322las_er
lasher94824532lasher
laster64830632laster
leper74820742leper
lisper84114432lisper
loper75129232loper
mapper124516092mapper
maser75029972mas_er
masher114123202masher
masker124416102masker
master84831342master
moper94925922moper
napper103718282napper
osier53518012osier
pamper124316662pamper
paper95128662paper
passer84721032passer
paster85734372paster
pauper103511942pauper
per56353092__per
piper96523192piper
raper74932752raper
rapper104621572rapper
raser55633412ras_er
rasher95024122rasher
rasped94715202rasped
raspers94415922raspers
raspier93110642raspier
raster64731442raster
riper74328402riper
roper75431912roper
saber75330242saber
safer84721812safer
sager65432052sager
saker95132022saker
saner54334322saner
sapor75119252sapor
sapper103822352sapper
saver84831252saver
sawer85026212sawer
sayer84926552sayer
seer45547042_seer
ser36752402_s_er
spar65433302_spar
spear75821062_spear
spec85821972_spec
sped76031492_sped
speer74623902_speer
speir75315362_speir
sperm93216012_sperm
spew95421872_spew
spier75728032_spier
spur65321192_spur
suer45334032_suer
super74924482super
tamper104618512tamper
taper74829772taper
tapper104419612tapper
taster64930572taster
toper75231022toper
upper93714262upper
user45023002us_er
usher84517762usher
vamper134212652vamper
vaster94521022vaster
vesper1138082vesper
viper105017302viper
warper114015582warper
washer124720392washer
waspier12259052waspier
waster95228942waster
wiper105421292wiper
yapper133714512yapper
yauper11368542yauper
yawper14437952yawper
zapper193414022zapper

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.0961861364.6
2DLD Change Limit538001821.65332546.9
3Display Results1821820.0463956.5
 (SQL Overall)1786911821.79599549.3
 
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.