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

161 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
aspers8622031(None) 
apers76629131a_pers
askers105915401askers
aspens85013351aspens
asper75520431asper_
asperse94210661asperse
asters65631601asters
gaspers105014131gaspers
jaspers164310461jaspers
raspers94415921raspers
adders84315702adders
afters94717072afters
agers65027852a_gers
aggers85817792aggers
aiders74524632aiders
aimers84621912aimers
airers64922312airers
aivers94822322aivers
alders74218422alders
alters64924222alters
ambers104519582ambers
ameers84015572ameers
ampere10514412ampere
amperes11313982amperes
angers75222542angers
answers1037042answers
aper66336232a_per_
apery106517902a_pery
apes66047432a_pe_s
appears11308952appears
appels104312792appels
apres75426402a_pres
apses76823912apse_s
armers85520272armers
arpens84814822arpens
ashes86230612ashe_s
ashlers10319582ashlers
asker96418782asker_
aspect10612822aspect
aspects1146742aspects
aspen75216092aspe_n
asperges11318092asperges
aspersed11428302aspersed
asperser10408302asperser
asperses104111672asperses
aspersor10336232aspersor
aspics104211562aspics
aspire8612122aspire
aspirers1066492aspirers
aspires9612042aspires
aspis74618142asp_is
asps65622092asp__s
assert64922582assert
asserts74311792asserts
asses55629282asse_s
assess65710462assess
assets65617662assets
aster55434892aster_
astern64815812astern
augers73818702augers
avers85127312a_vers
bashers124820832bashers
basters94930312basters
campers134220292campers
capers105428142capers
cappers134419402cappers
carpers114521252carpers
casters94729902casters
claspers124410912claspers
copers104629842copers
dampers123915692dampers
dashers115016862dashers
dopers95522482dopers
dupers94615602dupers
easters75125682easters
eskers105312222eskers
esters64627732esters
gapers94520472gapers
gasper94515542gasper_
gassers84714632gassers
gasters85624302gasters
gawpers13448312gawpers
graspers11338402graspers
hampers143616952hampers
harpers124916202harpers
hopers114222972hopers
hypers144811912hypers
japers154616172japers
jasper154610382jasper_
jaspery19405252jaspery
kashers143914022kashers
lampers113817332lampers
lappers113717462lappers
lapsers93911052lapsers
lasers64925702las_ers
lashers104121832lashers
lasters75627692lasters
lepers84817322lepers
lispers94514322lispers
lopers84424142lopers
mappers133313782mappers
masers84623452mas_ers
mashers124621052mashers
maskers133913842maskers
masters94628922masters
mopers104220372mopers
nappers114214862nappers
osiers63412792osiers
pampers133615932pampers
papers105125322papers
passers94717752passers
pasters94531732pasters
paupers114311072paupers
pipers104318662pipers
rapers84327182rapers
rappers113618442rappers
rasers64526782ras_ers
rashers104020912rashers
rasper83917332rasper_
rasters74629022rasters
ropers84325902ropers
sabers85224732sabers
sakers104125432sakers
sapors84118812sapors
sappers113518902sappers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
seers55136382_seers
sers45746652_s_ers
spars75431542_spars
spears84019472_spears
specs96916672_specs
speers85019952_speers
speirs85013232_speirs
sperm93216022_sperm
sperms102512602_sperms
spews105015922_spews
spiers84421742_spiers
spurs74621522_spurs
suers55128482_suers
supers84622402supers
tampers113516742tampers
tapers84025812tapers
tappers113416542tappers
tasters74225642tasters
topers85025322topers
uppers102912292uppers
users55817572us_ers
ushers94415532ushers
vampers143111622vampers
vespers1239032vespers
vipers114914532vipers
warpers123413582warpers
washers134517522washers
wasters104026592wasters
wipers115416082wipers
yappers144012252yappers
yaupers12337662yaupers
yawpers15346852yawpers
zappers203911632zappers

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.343520965.0
2DLD Change Limit825511612.31335690.0
3Display Results1611610.0463500.0
 (SQL Overall)1786911612.70266132.9
 
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.