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

396 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
answers103704(None) 
answer936891answer_
angers75222542an_gers
anglers84014822anglers
answered1235492answered
answerer1144272answerer
answerers1243742answerers
anthers103715202anthers
antlers74014742antlers
askers105915402a_skers
aspers86220312a_spers
asters65631602a_sters
avowers1336332avowers
gnawers11356392gnawers
knowers1436352knowers
unswears1144022unswears
abasers95311973abasers
abaters95115203abaters
abiders104011083abiders
abscess1133903abscess
abusers94710553abusers
adders84315703a_dders
adorers84411733adorers
aethers103614943aethers
afters94717073a_fters
agers65027853a__gers
aggers85817793a_ggers
aiders74524633a_iders
aimers84621913a_imers
airers64922313a_irers
aisles64721143aisle_s
aivers94822323a_ivers
alders74218423a_lders
aliners74717723aliners
almners9399563almners
alters64924223a_lters
amassers10337843amassers
ambeers11428923ambeers
ambers104519583a_mbers
amblers115213563amblers
ameers84015573a_meers
amusers94610193amusers
anadems1036143anadems
anchors123912953anchors
ancress978613ancress
anears63717183an_ears
aneles64626293anele_s
anes45255933an__e_s
angels74416173an_gels
anger66225873an_ger_
angler74017863angler_
angles74426703angle_s
animes84719593anime_s
aniseeds944393aniseeds
anises64826693anise_s
ankles104818383ankle_s
anklets114310413anklets
annoyers1185033annoyers
anodes74418763anode_s
anoles64827433anole_s
ansae55720973ansae__
anserous8410543ans_erous
answering1345803answering
antbears1044963antbears
antes56334323an_te_s
anthems12309423anthems
anther93715063anther_
antiars7314623antiars
antler64615553antler_
antres65021003antre_s
antsier7410773antsier_
anuses66218773anuse_s
anyways1644423anyways
anywhere1742563anywhere
anywheres1842343anywheres
apers76629133a__pers
apses76823913aps_e_s
archers124414573archers
arguers8489033arguers
armers85520273a_rmers
arses55733873ars_e_s
ashes86230613a_she_s
ashlers10319583ashlers
asker96418783a_sker_
aspens85013353a_spens
asper75520433a_sper_
asperse94210663a_sperse
assayers1144843assayers
assert64922583a_ssert
asserts74311793a_sserts
asses55629283a_sse_s
assess65710463a_ssess
assets65617663a_ssets
assumers1064963assumers
assurers866313assurers
assures7611403assures
aster55434893a_ster_
astern64815813a_stern
aswarm11107913a_swarm
aswirl935093a_swirl
atoners75013953atoners
augers73818703a_ugers
austere7312993austere
avers85127313a__vers
avower1236823avower_
awes76037553a__we_s
axseeds1533393axseeds
banders104324563ban_ders
bangers104020353ban_gers
banishers14258053banishers
banisters11189473banisters
bankers133919093ban_kers
banners94018713ban_ners
banshees13127863banshees
banters94623113ban_ters
bashers124820833bashers
basters94930303basters
bisters93922613bisters
blowers124313593blowers
bowers115523703_bowers
brewers123811053brewers
bushers124018803bushers
buskers133414093buskers
busters94724133busters
cancers114018583can_cers
candlers114214103candlers
caners84629203can__ers
canisters112310193canisters
cankers134418753can_kers
canners93822663can_ners
canoers94318373can_oers
canters94827733can_ters
casters94729903casters
causers94014793caus_ers
censers94313903cens_ers
chawers154412053chawers
chewers154111133chewers
clawers123910973clawers
coshers123618183coshers
costers94128333costers
cowers114625533_cowers
crowers124614893crowers
cussers94213403cussers
dabsters1137053dabsters
dancers103413093dan_cers
danders93921183dan_ders
dandlers103912053dandlers
dangers94818213dan_gers
danglers103610593danglers
danseurs933433danseurs
dashers115016863dashers
dosers75723633dos_ers
dossers84516233dossers
dowers104523293_dowers
dowsers115013533dowsers
drawers113610073drawers
dusters84918363dusters
easters75125683easters
enders74324053en_ders
endowers1238233endowers
enserf9310763ens_erf
enserfs1035483ens_erfs
ensues63313813ensue_s
ensurers8279373ensurers
ensures73315903ensures
enters64425643en_ters
enviers1036993enviers
eskers105312223_eskers
esters64627733_esters
ewers86018823__ewers
fanciers13358083fanciers
fanners103914653fan_ners
festers104121393festers
fishers134714723fishers
flowers133413173flowers
fosters104220103fosters
fussers104210813fussers
gagsters10317083gagsters
ganders93521703gan_ders
gangers94418603gan_gers
gangsters11205733gangsters
ganisters10248313ganisters
gaspers105014133gaspers
gassers84714633gassers
gasters85624293gasters
glowers113412093glowers
gnawer10386953gnawer_
growers113612723growers
gushers113512513gushers
hamsters13710423hamsters
hanapers1346963hanapers
handers114224333han_ders
handlers124014143handlers
hangers113120813han_gers
hankers144218133han_kers
hansels104011653hans_els
hanses95022633hans_e_s
hawsers13409483haws_ers
hewers123715273_hewers
hissers104112313hissers
hosers95223963hos_ers
hosiers104212643hosiers
huskers143510043huskers
inchers123912523inchers
infers93615443in_fers
inkers104018833in_kers
inliers73110743inliers
inners63919353in_ners
insert64325253ins_ert
inserts74013993ins_erts
insets64016133ins_ets
insiders947763insiders
instars7411133instars
insteps936573insteps
insurers83710133insurers
insures73117263insures
inswept1245733inswept
inters64328053in_ters
issuers746123issuers
janglers16319373janglers
jaspers164310463jaspers
jesters144118193jesters
joshers174111593joshers
justers143815733justers
kaisers11369273kais_ers
kashers143914023kashers
kissers114211293kissers
knawels14344683knawels
knawes13328393knawe_s
knifers14537083knifers
knower1337083knower_
koshers144811803koshers
lamsters1099753lamsters
lancers93616643lan_cers
lanciers10308543lanciers
landers84026213lan_ders
landlers94312833landlers
lanners73618333lan_ners
lapsers93911053laps_ers
lasers64925703las_ers
lashers104121833lashers
lassoers8338513lassoers
lasters75627693lasters
lispers94514323lispers
listers74026533listers
losers65123583los_ers
lowers94624923_lowers
lusters73921443lusters
managers112911003managers
mangers103521263man_gers
manglers113311903manglers
manners93417833man_ners
manpowers1644463manpowers
manses84225513mans_e_s
manurers1037593manurers
masers84623453mas_ers
mashers124621053mashers
maskers133913843maskers
masters94628923masters
minsters103813923minsters
misers85025703mis_ers
misters93927513misters
monsters103314553monsters
moshers124017843moshers
mossers94116193mossers
mowers113219403_mowers
munsters104010553munsters
musers84719103mus_ers
mushers124016443mushers
musters94522513musters
nabbers113710463nabbers
naggers93812653naggers
nailers73215893nailers
namers84517333_namers
nappers114214863nappers
natters73718063natters
nesters74422793nesters
newels93710823_newels
newer85717463_newer_
niters64624213_niters
nonanswers1352843nonanswers
noshers103614333noshers
noters64021003_noters
onagers838103onagers
onsets64013543ons_ets
osiers63412793_osiers
ousters74122793ousters
oysters103411693oysters
panders103423733pan_ders
paniers94717333pan_iers
panners93621273pan_ners
panniers10488853panniers
pansies94521983pansie_s
panthers13510783panthers
panzers184012013pan_zers
parsers94118153pars_ers
passers94717753passers
pasters94531733pasters
pausers94113223paus_ers
pawers114818783_pawers
pensters103012123pensters
pesters93827093pesters
pishers123815753pishers
pissers95014753pissers
plowers123812243plowers
posers84223973pos_ers
posters93928013posters
powers113822323_powers
punsters103310583punsters
pushers123814503pushers
raisers73617393rais_ers
ranchers133311793ranchers
rangers83621043ran_gers
rankers113217463ran_kers
ransomers1146873ransomers
ranters73323643ran_ters
rasers64526783ras_ers
rashers104020913rashers
raspers94415923raspers
rasters74629023rasters
renewers11238183renewers
resters74130403resters
rinsers73815743rins_ers
risers64624783ris_ers
riskers114011993riskers
rosters73727543rosters
rowers94924573_rowers
rushers103816103rushers
sanders84025943san_ders
sangers84421943san_gers
sansars73313913sans_ars
sanseis73011603sans_eis
sawers94620163_sawers
seers55136383__seers
sers45746653__s_ers
sewers94719713_sewers
shewers134312043shewers
showers134612683showers
sisters73721593sisters
skewers14498373skewers
snarers74216663snarers
sneers64016173sn_eers
snipers93311773snipers
snorers74313803snorers
sowers94923443_sowers
spewers124210653spewers
suers55128483__suers
swears94114073__swears
tanagers9259003tanagers
tanglers92911973tanglers
tankers113416913tan_kers
tanners74018393tan_ners
tansies74521243tansie_s
tapsters10318803tapsters
tarsiers8298533tarsiers
tasters74225643tasters
tawers94118603_tawers
testers74124543testers
thawers13428483thawers
tossers74713503tossers
towers94423673_towers
transfers1238053transfers
tuskers113710043tuskers
tussers74313563tussers
ulsters72711983ulsters
undoers82910583undoers
uniters73814173uniters
unsets64116163uns_ets
unsews9379363uns_ews
unsteps936213unsteps
unswear1035003unswear
unswept1246013unswept
unswore1039053unswore
unsworn1046843unsworn
users55817573_us_ers
ushers94415533_ushers
vanishers15186613vanishers
vanners103612843van_ners
vespers1239033vespers
viewers1337173viewers
vowers124317183_vowers
waisters113811523waisters
wanders114221333wan_ders
wanglers123310033wanglers
wankers144514713wan_kers
wanters104420093wan_ters
warslers11328073warslers
washers134517523washers
wasters104026593wasters
westers105221963westers
wishers133215213wishers
wowsers13488763wowsers
xysters17307163xysters
zanders173015793zan_ders
zesters163517293zesters
zosters163015413zosters

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit1340273966.83019623.3
3Display Results3963960.1402828.6
 (SQL Overall)1786913967.36024278.7
 
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.