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

394 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
abetter95832(None) 
abetted1058321abetted
abetters1057171abetters
abettor956191abettor
abutter957511abutter
better84723701_better
abater85518122ab_ater
abettal946072abettal
abettors1056132abettors
aborter939932aborter
absenter1086772absenter
abutted1056982abutted
abutters1056992abutters
adepter1036112adepter
aether94213672a_ether
alerter72111512alerter
averter102410552averter
batter84928872_batter
beater84729392_beater
belter84720962_belter
betted94721162_betted
betters94422092_betters
bettor83612222_bettor
bitter84622672_bitter
butter84724232_butter
fetter94120382_fetter
fretter103412752fretter
getter74117612_getter
letter63722582_letter
netter63722022_netter
petter83924772_petter
setter64023722_setter
tetter64322452_tetter
vetter93417642_vetter
wetter93919442_wetter
whetter13348802whetter
abaser86414343ab_aser
abate76627843ab_ate_
abated95918453ab_ated
abaters95115203ab_aters
abates85825033ab_ates
abator84512713ab_ator
abattis9297823abattis
abattoir1042043abattoir
abele76323253abe_le_
abeles84719393abe_les
abet610547943abe_t__
abetment1248233abetment
abets75621673abe_t_s
abettals1054723abettals
abetting1158293abetting
abider95314463ab_ider
abjurer1634753abjurer
ablate82219213ablate_
ablated102513443ablated
ablates92416903ablates
ablator939843ablator
abler75624313ab__ler
abluted10188363abluted
aborted10310423aborted
aborters1038573aborters
abrader1038643abrader
abrupter1243793abrupter
absented1156613absented
absentee1067663absentee
absenters1156173absenters
abuser85413683ab_user
abuttal954553abuttal
accepter14144933accepter
acerber1135243acerber
acetate92514753acetate_
acetated112010683acetated
acetates102013063acetates
acuter84412863a_cuter
adapter1036173adapter
admitter1135113admitter
adopter1036763adopter
aerier64823153a_erier
aethers103614943a_ethers
affecter1644523affecter
aflutter1163813aflutter
after85719793a__fter
agented939423agented
aglitter935093aglitter
alerted82512223alerted
allotter866473allotter
alter54828503a__lter
alterer72713993alterer
ambeer104511603ambe__er
ameer75618983ame__er
amender10349613amender
amercer1146373amercer
ammeter1148393ammeter
another10289153another
anteater8311603anteater
anther93715063a_nther
antler64615553a_ntler
apter76120203a__pter
arbiter939933arbiter
arete56031353are_te_
aretes64425353are_tes
ariette7312373ariette_
ariettes8411353ariettes
arrester839253arrester
artier63419733a_rtier
assenter867703assenter
asserter877573asserter
aster55434893a__ster
atelier7311623atelier
attar56516693a__ttar
attester836503attester
atwitter1143673atwitter
avenger1135493avenger
averted112211613averted
averters11249513averters
awaiter1057443awaiter
aweather1434263aweather
baiter84422553_baiter
banter84825333_banter
barbette1249113barbette_
barbettes1348163barbettes
barter85525373_barter
baster85333593_baster
bather115322513_bather
batted95623653_batted
batten85217123_batten
batters94626013_batters
battery124911813_battery
battier93515713battier
battler94113383battler
beader94623793_beader
beaker125520693_beaker
bearer85323913_bearer
beaten84617063_beaten
beaters94925043_beaters
beaver114819253_beaver
bedder104215793_bedder
beeper103714093_beeper
beer65635993_be__er
beetler938033beetler
beezer174010523_beezer
begetter11136313begetter
belier84423563_belier
belted94020633_belted
belters93819413_belters
bender95223303_bender
besetter10137973besetter
bested94922753_bested
bestir8311163_bestir
betatter1035453_betatter
betel74419903_be_tel
bethel1169643_bethel
betta74916843_bett_a
bettas84913923_bettas
bettered113011833_bettered
bettors93312473_bettors
bister84922763_bister
biter75030033_b_iter
bitted94418483_bitted
bitten84715123_bitten
bittern94810683_bittern
bitters94920363_bitters
bittier94211663_bittier
blatter94415653blatter
bleater94515303bleater
blether12459913blether
blotter94612853blotter
boater84622093_boater
bolter83920753_bolter
bother115218063_bother
bottler94211883_bottler
bunter85020383_bunter
buster84726493_buster
butler84220033_butler
butte74924293_butte_
butted94722063_butted
butters94521723_butters
buttery124311193_buttery
buttes84822563_buttes
casette9310393casette_
casettes1039653casettes
center84421413_center
chatter124416643chatter
cheater124816963cheater
chitter124112963chitter
clatter94014973clatter
clutter94211663clutter
cotter84926673_cotter
crabeater1345593crabeater
critter94113033critter
cutter84521003_cutter
dabster1036703dab_ster
debater104114693debater
defter104215923_defter
deter65028043_de_ter
dexter143810893_dexter
diester83013683diester
dieter73516773die_ter
diether1147443diether
dotter74419343_dotter
duetted937023duetted
eater54639843__eater
embitter12245623embitter
emitter93211083emitter
enfetter1145353enfetter
enter54726383__enter
erecter93113393erecter
ester54727713__ester
ether84518773__ether
facetted1445743facetted
fatter94523213_fatter
feater95224053_feater
fester94723513_fester
fetted104817893_fetted
fetters103517903_fetters
fitter94120033_fitter
flatter103815963flatter
fleeter103210363fleeter
flitter103413903flitter
flutter104012093flutter
fretted113411853fretted
fretters113410303fretters
frettier1156593frettier
fritter103912773fritter
galette84212693galette_
galettes93111153galettes
gamester1137323gamester
garotter965943garotter
gazette17357363gazette_
gazetted19234853gazetted
gazetteer1941393gazetteer
gazettes18296863gazettes
getters84216103_getters
glitter84211803glitter
greater84416493greater
greeter82812673greeter
gritter83913353gritter
gutter73817713_gutter
hatter94724873_hatter
heater94828303_heater
hefter124313923_hefter
hitter94419863_hitter
hotter94720083_hotter
imbitter12265283imbitter
insetter8218593insetter
jester134319153_jester
jetted143915083_jetted
jettier14358693_jettier
jitter133314993_jitter
jotter134315633_jotter
keester11319913keester
kelter103214383_kelter
kiester11329973kiester
knitter11348133knitter
knotter11317643knotter
labeler92310183labe_ler
labeller10248073labeller
lamenter1038863lamenter
latter65027893_latter
layette1037133layette_
layettes1136263layettes
lefter93613433_lefter
letted74118543_letted
letters73819853_letters
litter64324853_litter
lotter64025603_lotter
matter84325343_matter
meeter83616503_meeter
melter83520113_melter
meter75130323_me_ter
metier83517693_metier
mutter84418883_mutter
natter64420743_natter
navette1036983navette_
navettes1136613navettes
neater64424313_neater
nester64124183_nester
nether94014163_nether
netted74118713_netted
netters73618583_netters
nettier74211813_nettier
nettler7349503_nettler
neuter63713793_neuter
nutter63918053_nutter
obeyer1135893obe_yer
omitter9298503omitter
otter54423973__otter
palette93613983palette_
palettes103112833palettes
patter84628263_patter
pelter83321623_pelter
perter84422283_perter
pester84827593_pester
peter74427593_pe_ter
petted94121523_petted
petters93722363_petters
pettier94213613_pettier
pewter114013673_pewter
phatter123810203phatter
platter93917413platter
pleater93916333pleater
plotter94113663plotter
potter83926983_potter
prester93519623prester
prettier1069043prettier
putter83921443_putter
quester161410023quester
quitter162910753quitter
rabbiter1234673rabbiter
ratter64326313_ratter
rebater93517913rebater
rebutter10106273rebutter
reenter73217793reenter
reletter81311023reletter
renter64527413_renter
resetter81511833resetter
rester63832433_rester
retted74826313_retted
reutter71010093reutter
ritter63822423_ritter
rotter64325463_rotter
scatter93815173scatter
scepter1138363scepter
scutter93512173scutter
seater64534163_seater
settee63721023_settee
setters73822063_setters
settler73410653_settler
shatter103615703shatter
sheeter103814913sheeter
shelter103214963shelter
shutter103712143shutter
sitter63323383_sitter
skeeter113410413skeeter
skelter113610003skelter
skitter113810403skitter
slitter73615873slitter
slotter73314453slotter
smatter93613333smatter
smelter93311913smelter
spatter94016523spatter
specter113111733specter
spelter94113703spelter
spitter94015183spitter
spotter94514883spotter
sputter94014053sputter
stetted82610403stetted
stutter72911463stutter
svelter10359673svelter
swatter104113323swatter
sweater103712723sweater
sweeter103212003sweeter
swelter103711173swelter
swotter10399473swotter
tabletted1244833tabletted
tatter64024573_tatter
teeter65420313_teeter
teether10349693teether
tenter64623933_tenter
tester64227153_tester
tether93716103_tether
tetters74320473_tetters
theater104014253theater
titter63421163_titter
totter65021463_totter
treater74219833treater
trotter73312253trotter
tweeter10288533tweeter
twitter10278093twitter
unabetted1244993unabetted
unbitter1046173unbitter
unfetter1136753unfetter
upsetter1034643upsetter
ureter6313203ure_ter
utter54218763__utter
venter94218723_venter
vetoer93410063_vetoer
vetted104316323_vetted
vetters104016323_vetters
watter93221983_watter
webster1236093webster
welter93417383_welter
wester94222893_wester
wether123315393_wether
wetted103717023_wetted
wetters103817753_wetters
whether16346623whether
whetted14256693whetted
whetters14246653whetters
whitter139110893whitter
wrester102812413wrester
yatter94116213_yatter
yester93417983_yester
zester153617793_zester

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.423422437.4
2DLD Change Limit1340273946.87319500.5
3Display Results3943940.1402814.3
 (SQL Overall)1786913947.43624030.5
 
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.