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

144 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
askers10591540(None) 
asker96418781asker_
aspers86220311aspers
asters65631601asters
eskers105312221eskers
maskers133913841maskers
sakers104125431sakers
ackees124914582ackees
adders84315702adders
afters94717072afters
agers65027852a_gers
aggers85817792aggers
aiders74524632aiders
aimers84621912aimers
airers64922312airers
aivers94822322aivers
akees96119242a_kees
alders74218422alders
alters64924222alters
ambers104519582ambers
ameers84015572ameers
angers75222542angers
answers1037042answers
apers76629132a_pers
armers85520272armers
ashes86230612ashe_s
ashlers10319582ashlers
asked106919312aske_d
askeses1136462askeses
askesis1136122askesis
askew12529412aske_w
askos95011772ask_os
asks85721212ask__s
aspens85013352aspens
asper75520432asper_
asperse94210662asperse
assert64922582assert
asserts74311792asserts
asses55629282asse_s
assess65710462assess
assets65617662assets
aster55434892aster_
astern64815812astern
augers73818702augers
avers85127312a_vers
backers153821892backers
bakers125323452bakers
balkers134915722balkers
bankers133919092bankers
barkers134318512barkers
bashers124820832bashers
baskets135111832baskets
basters94930312basters
bikers124517552bikers
buskers133414092buskers
calkers134414692calkers
cankers134418752cankers
caskets133910172caskets
casters94729902casters
dackers143417042dackers
daikers124010312daikers
dashers115016862dashers
dikers114418792dikers
easters75125682easters
eskars10357592eskars
esker94412982esker_
esters64627732esters
fakers134219532fakers
gaskets12348152gaskets
gaspers105014132gaspers
gassers84714632gassers
gasters85624292gasters
gawkers15347452gawkers
hackers164619042hackers
hankers144218132hankers
hawkers174210332hawkers
hikers135014352hikers
huskers143510042huskers
ickers123914182ickers
inkers104018832inkers
jackers204214452jackers
jaspers164310462jaspers
jokers175511192jokers
kashers143914022kashers
lackers134120542lackers
lakers105225152lakers
larkers113014512larkers
lasers64925702las_ers
lashers104121832lashers
lasters75627692lasters
likers104620912likers
makers123921732makers
markers133516102markers
masers84623452mas_ers
mashers124621052mashers
maskegs14375412maskegs
masker124416102masker_
masters94628922masters
ockers123813902ockers
osiers63412792osiers
packers153818892packers
parkers133816872parkers
passers94717752passers
pasters94531732pasters
pikers124717392pikers
pokers124617922pokers
rackers134320452rackers
rakers104123572rakers
rankers113217462rankers
rasers64526782ras_ers
rashers104020912rashers
raspers94415922raspers
rasters74629022rasters
riskers114011992riskers
sabers85224732sabers
sackers133820222sackers
saker95132022saker_
sakes95540752sake_s
savers93825922savers
sawers94620162sawers
sayers94221592sayers
seers55136382_seers
sers45746652_s_ers
skees95023122_skees
skegs105011232_skegs
skeps115614252_skeps
skews125413802_skews
skiers104713702_skiers
suers55128482_suers
tackers134319622tackers
takers103923742takers
talkers113513212talkers
tankers113416912tankers
tasters74225642tasters
tokers104818892tokers
tuskers113710042tuskers
users55817572us_ers
ushers94415532ushers
wakers134822492wakers
walkers143411472walkers
wankers144514712wankers
washers134517522washers
wasters104026592wasters
yakkers13304272yakkers

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.360496363.9
2DLD Change Limit825511442.48333246.5
3Display Results1441440.0463130.4
 (SQL Overall)1786911442.88961852.2
 
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.