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 “amassers” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

245 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
amassers1033784(None) 
amasser9418731amasser_
amasses93912851amasse_s
abasers95311972aba_sers
admasses1135412admasse_s
amassed10388632amasse_d
amusers94610192am_users
camasses12388972camasse_s
classers104111832classers
gassers84714632_gassers
harassers1246202harassers
masers84623452_ma_sers
mashers124621052_mashers
maskers133913842_maskers
masses85028712_masse_s
masseurs1034922_masseurs
masters94628922_masters
mossers94116192_mossers
passers94717752_passers
smashers13339592smashers
abaser86414343aba_ser_
abases85720773aba_se_s
abashes12510373abashe_s
abaters95115203aba_ters
abusers94710553a_busers
abysses1234863abysse_s
accusers12285903accusers
adapters1136103adapters
advisers12135003advisers
alastors8311223alastors
amass77119683ama_s__s
amassing1138003amassing
amassment1346413amassment
amassments1444493amassments
amateurs1043653amateurs
amazes175613473ama_ze_s
ambeers11428923am_beers
ambers104519583am__bers
amblers115213563am_blers
ambushers1643433ambushers
ameers84015573am__eers
amenders11288353amenders
amercers1256133amercers
ammeters1237693ammeters
amuser84712623am_user_
amuses85117943am_use_s
analysers12124603analysers
answers1037043a_nswers
apposers1236283apposers
arousers84810983arousers
askers105915403__askers
aspers86220313__aspers
assayers1144843assayers
assert64922583__assert
asserts74311793__asserts
asses55629283__asse_s
assess65710463__assess
assets65617663__assets
asters65631603__asters
avgasses1284193avgasse_s
awaiters1146643awaiters
awarders1245073awarders
badasses1136173badasse_s
bagasses1136313bagasse_s
bashers124820833_bashers
basses85428303_basse_s
bassets96414823_bassets
basters94930303_basters
biasses94911653biasse_s
blasters104116143blasters
blessers10277633blessers
boasters103915663boasters
brasiers103710513brasiers
brasses93818353brasse_s
cadasters1236833cadasters
camases114216343cama_se_s
canvassers15273583canvassers
caressers1137443caressers
casters94729903_casters
causers94014793_causers
chasers123714923cha_sers
chasses124017503chasse_s
chasseurs1443323chasseurs
clashers134213993clashers
claspers124410913claspers
classer93614613classer_
classes94717943classe_s
coasters104317333coasters
crashers134013233crashers
crasser94114343crasser_
crossers103912703crossers
cussers94213403_cussers
damagers1237073dama_gers
dashers115016863_dashers
degassers11354833degassers
diasters92913183diasters
dossers84516233_dossers
dressers9359863dressers
easters75125683_easters
embossers1343413embossers
erasers74413943era_sers
eyasses10388023eyasse_s
feasters11511563feasters
flashers143912653flashers
flossers11307863flossers
frasses104314513frasse_s
fussers104210813_fussers
gamashes1456953gamashe_s
gamesters1236733gamesters
gaspers105014133_gaspers
gasser75017773_gasser_
gasses75724783_gasse_s
gasters85624293_gasters
glasses84414273glasse_s
glossers9319053glossers
graspers11338403graspers
grasses84117343grasse_s
grossers94410973grossers
guessers9174903guessers
hamsters13710423ham_sters
harasser1137043harasser_
harasses11311033harasse_s
hassels104311023_hassels
hawsers13409483_hawsers
hissers104112313_hissers
imagers10107763ima_gers
impasses12257523impasse_s
imposers12278463imposers
jaspers164310463_jaspers
kaisers11369273_kaisers
kashers143914023_kashers
kavasses1544303kavasse_s
kissers114211293_kissers
kvasses14365503kvasse_s
lamasery1343953lama_sery
lamisters1157123lamisters
lamsters1099753lam_sters
lapsers93911053_lapsers
lasers64925703_la_sers
lashers104121833_lashers
lasses64827593_lasse_s
lassoers8338513_lassoers
lasters75627693_lasters
leasers74717843lea_sers
macers105321273_ma_cers
madders113513213_madders
mailers94420333_mailers
maimers113813043_maimers
makers123921733_ma_kers
mammers104615693_mammers
mamzers20409163_mamzers
mangers103521263_mangers
manners93417833_manners
manses84225513_manse_s
mappers133313783_mappers
markers133516103_markers
marrers93414313_marrers
marses84827113_marse_s
maser75029973_ma_ser_
masher114123203_masher_
mashes115030003_mashe_s
maskegs14375413_maskegs
masker124416103_masker_
masquers19195703_masquers
massagers1245513_massagers
massas85116463_mass_as
masse75125293_masse__
massed94421323_masse_d
masseters1136283_masseters
masseur935703_masseur
masseuse1044253_masseuse
massier93615223_massier_
massifs1237743_massifs
massless10277113_massless
master84831343_master_
mastery124214323_mastery
maters85032393_ma_ters
matters94421753_matters
maulers94213303_maulers
mazers173917093_ma_zers
messes84924343_messe_s
misers85025703_m_isers
missels94614813_missels
misses85130873_misse_s
missets94516573_missets
misters93927513_misters
misusers10348083_misusers
momsers113810853_momsers
moshers124017843_moshers
mosser84618273_mosser_
mosses85527683_mosse_s
mousers95216443_mousers
musers84719103_m_users
mushers124016443_mushers
mussels9419843_mussels
musses84624783_musse_s
musters94522513_musters
parsers94118153_parsers
passels93913023_passels
passer84721033_passer_
passes86030473_passe_s
pasters94531733_pasters
pausers94113223_pausers
paymasters1743843paymasters
piasters102912813piasters
pissers95014753_pissers
plashers133813453plashers
plasters103518133plasters
praisers103410833praisers
pressers103215023pressers
quashers20186803quashers
quasses16209503quasse_s
raisers73617393_raisers
rasers64526783_ra_sers
rashers104020913_rashers
raspers94415923_raspers
rasters74629023_rasters
reassert8313673reassert
reasserts945983reasserts
reassess836513reassess
remasters11310583remasters
roasters83615933roasters
sasses64124393_sasse_s
slashers113313613slashers
smackers16318713smackers
smasher123911023smasher_
smashes123914613smashe_s
smatters104011713smatters
swashers14389533swashers
tassels74510853_tassels
tasses64826763_tasse_s
tassets75012773_tassets
tasters74225643_tasters
teasers75317243tea_sers
toasters83912723toasters
tossers74713503_tossers
trashers113013643trashers
trasses74819323trasse_s
trussers8348283trussers
tussers74313563_tussers
unmaskers15243723unmaskers
vavassors1541843vavassors
washers134517523_washers
wasters104026593_wasters
wrasses103812593wrasse_s

Search took 10 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 Filter1786911461620.436409841.7
2DLD Change Limit1461622458.55017095.0
3Display Results2452450.0932634.4
 (SQL Overall)1786912459.07919681.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.