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

453 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
abbeys1353842(None) 
abbes96723521abbe_s
abbess10509771abbess
abbey125714931abbey_
abbas95918642abb_as
abbe87627192abbe__
abbots1039282abbots
abets75621672a_bets
ables75935542able_s
abyes105518532abye_s
abys97221882a_b_ys
alleys95113302alleys
ambers104519582ambers
babels105216722babels
babes95834112babe_s
beys913829552__beys
dabbers123813212dabbers
ebbets10376832ebbets
gabbers124612832gabbers
jabbers183610582jabbers
nabbers113710462nabbers
obeys107010642_obeys
rabbets11279422rabbets
yabbers14389352yabbers
abacas104414723abacas
abacus10349763abacus
abakas123911743abakas
abamps1236253abamps
abas68642083a_b_as
abasers95311973abasers
abases85720773abases
abaters95115203abaters
abates85825033abates
abatis84317933abatis
abaya104413173a_baya
abayas114011703abayas
abba810522653abb__a
abbacy1536623abbacy
abbesses1235333abbesses
abbot9318453abb_ot
abeam9316533a_beam
abed79734133a_be_d
abele76323253a_bele
abeles84719393abeles
abet610547943a_be_t
abhenrys1641543abhenrys
abhors11410623abhors
abiders104011083abiders
abides94719893abides
abject17137703abject
able66340533able__
abled86926833able_d
ableism1136823ableism
ableist9311773ableist
abler75624313able_r
ablest84721833ablest
ablins8316193ablins
ably99725133a_bly_
abmhos1334973abmhos
abodes94417513abodes
abohms1335003abohms
abomas101113583abomas
aborts84916183aborts
abos67734413a_b_os
aboves114512843aboves
abreast9311273abreast
abris75722603a_bris
abs59356073a_b__s
abscess1133903abscess
abseil837183abseil
abseils935973abseils
absent84016993absent
absents93510723absents
abusers94710553abusers
abuses85119103abuses
abuts75417073a_buts
aby810238063a_b_y_
abye97921003a_b_ye
abysm12598143a_b_ysm
abysms13565653abysms
abyss10669463a_byss
access1037683access
aces67645093a_ce_s
aches106132293ache_s
ackees124914583ackees
acmes96020653acme_s
acnes75922623acne_s
acres76327763acre_s
adders84315703adders
adeems946333adeems
adieus739633adieus
adobes94411533adobe_s
adzes155913803adze_s
aedes64625153aede_s
aeneus61111143aeneus
afters94717073afters
agers65027853a_gers
ages55844593a_ge_s
aggers85817793aggers
aglets73915683aglets
agley96917333agley_
agrees74915323agrees
agues64919053ague_s
aiders74524633aiders
aides65336603aide_s
aimers84621913aimers
airers64922313airers
aivers94822323aivers
akees96119243a_kees
albas75925393alb_as
albedo956123albedo
albedos1075253albedos
albeit8314343albeit
albs68628573alb__s
albums10198273albums
alders74218423alders
alecs76620733a_lecs
alefs87319663a_lefs
ales47067103a_le_s
aliens65619213aliens
allays94313743allays
allees64521483allees
alley85721673alley_
alloys94014563alloys
almehs11619493almehs
almes75126543alme_s
aloes54933673aloe_s
alters64924223alters
always12409133always
ambeer104511603ambeer
ambeers11428923ambeers
amber94523213ambe_r
ambery133811133ambery
ambits103713413ambits
amblers115213563amblers
ambles105121863ambles
ambos95321253amb_os
ambry123512103ambry_
amebas10311453amebas
ameers84015573ameers
amens75624843a_mens
amies76837693amie_s
anes45255933a_ne_s
angels74416173angels
angers75222543angers
annoys967523annoys
antes56334323ante_s
apers76629133a_pers
apes66047433a_pe_s
apneas83211383apneas
appels104312793appels
apres75426403apre_s
apses76823913apse_s
arbors84717883arbors
arbs66834733arb__s
ardebs937013ardebs
areas55935773a_reas
ares45871023a_re_s
ariels65119373ariels
arles56735743arle_s
armers85520273armers
armets84918353armets
arpens84814823arpens
arrays95311683arrays
arses55733873arse_s
artels66216233artels
ashes86230613ashe_s
askers105915403askers
aspens85013353aspens
aspers86220313aspers
assays977903assays
asses55629283asse_s
assess65710463assess
assets65617663assets
asters65631603asters
ates45047923a_te_s
augers73818703augers
aures55137093aure_s
aureus65314883aureus
avens86419333a_vens
avers85127313a_vers
aves76142603a_ve_s
awes76037553a_we_s
awless939263awless
axels126313633a_xels
axes117337853a_xe_s
axles125219473axle_s
ayes76543513a_ye_s
ays67050293a___ys
babas96325733bab_as
babblers113510353babblers
babbles104416323babbles
babe86835823babe__
babel95821693babe_l
babies106123653babies
babkas146010143babkas
baboos103517013baboos
babuls105413643babuls
babus95620333bab_us
baby116723683bab_y_
bagels95712313bagels
baileys12388933baileys
bakers125323453bakers
bakes117035373bake_s
balers85626933balers
bales76250083bale_s
banes74945583bane_s
barbels114514433barbels
barbers114317503barbers
barbes104526233barbe_s
barbets114915843barbets
bares75457133bare_s
barleys125011843barleys
barneys12569563barneys
baryes116218503baryes
bases75644353base_s
batboys1465833batboys
bates75846343bate_s
baubees11348713baubees
bawbees14337243bawbees
bays97143913__bays
beds75937783__beds
beefs105618563_beefs
beeps95320973_beeps
beers75628393_beers
bees65453383__bees
beets76131443_beets
begs75733833__begs
bels66142493__bels
bens65945703__bens
bes56557433__be_s
bets67051443__bets
bey86645423__bey_
bibbers103911353bibbers
biers76225223_biers
blabbers11308153blabbers
blebs96416153_blebs
bless75917813_bless
blets75324943_blets
blueys11419523blueys
bobbers103614283bobbers
bogeys124510913bogeys
boys96737333__boys
brays106723113_brays
brees75632553_brees
brens75823363_brens
brews105617073_brews
buoys104810633_buoys
buys95726793__buys
byes95230533_bye_s
bys85229463__b_ys
cabbed135416263cabbe_d
cabbies133115163cabbies
cabby145314563cabb_y_
cabers105023923cabers
cablers114416713cablers
cables104527553cable_s
cablets114216343cablets
cambers134017443cambers
carboys144711783carboys
carneys124310543carneys
causeys12387223causeys
clabbers14359903clabbers
cobbers134114753cobbers
coneys115218423coneys
cooeys114914483cooeys
coseys115215813coseys
coveys145413503coveys
cozeys204610913cozeys
crabbers14358753crabbers
cubebs12508683cubebs
cubers105318353cubers
cubes95028163cube_s
cuteys11569983cuteys
dabbed124416143dabbe_d
dabber114816963dabbe_r
dabblers13379363dabblers
dabbles124514773dabbles
darkeys15356533darkeys
daubers104610423daubers
daubes94913703daube_s
daybeds14234473daybeds
debyes1238103debyes
deys85027473__deys
dibbers124013173dibbers
dobbers123513253dobbers
dogeys115510663dogeys
drabbets13294823drabbets
dubbers124011823dubbers
ebbed104111003ebbe_d
ebbet93517293ebbe_t
ebbs82411993ebb__s
embays131408333embays
embeds11377903embeds
embers104116183embers
fabber134814113fabbe_r
fabbest1438033fabbest
fablers124812613fablers
fables114921673fable_s
fibbers144510603fibbers
fibers114717523fibers
fleys117015603_fleys
fogeys13509263fogeys
foleys123810463foleys
gabbed125216893gabbe_d
gabber114916603gabbe_r
gabblers134110083gabblers
gabbles124415413gabbles
gabbros12124653gabbros
gabby135512953gabb_y_
gabies93820733gabie_s
gables94222333gable_s
galleys11369713galleys
gambes116318313gambe_s
garveys14124463garveys
gibbers124710983gibbers
gibbets12417723gibbets
gibers95114663gibers
gibes84422523gibe_s
gleys96514853_gleys
gobbets12327643gobbets
grabbers13337883grabbers
greys96614853_greys
gybes115012723gybe_s
hawkeys20414703hawkeys
hebes105521673hebe_s
hobbers143512343hobbers
homeys145012873homeys
honeys124016083honeys
hooeys125512313hooeys
hoseys124614003hoseys
imbeds11456743imbeds
jabbed184213483jabbe_d
jabber173713643jabbe_r
jambes175914053jambe_s
jarveys20123413jarveys
jebels15418913jebels
jibbers18449703jibbers
jibers155912883jibers
jibes145520323jibe_s
jobbers182911133jobbers
joeys15518043_joeys
jubes145420743jube_s
keys116322163__keys
kibbehs18354183kibbehs
kibbes143811193kibbe_s
kibeis12469803kibeis
kibes115521113kibe_s
labels84515683labels
labrets939363labrets
lackeys16458263lackeys
lambers113817113lambers
lebens8310093lebens
leys76430183__leys
libbers113812833libbers
libels85112693libels
libers84721443libers
limeys11429273limeys
lobbers113713943lobbers
lobes75331003lobe_s
looeys95110123looeys
lubbers113913723lubbers
lubes74727993lube_s
mabes96331533mabe_s
magueys1333943magueys
mameys13449523mameys
mammeys13376723mammeys
mateys115610943mateys
maybes1339243maybe_s
mobbers133610923mobbers
moneys115513623moneys
moseys114711703moseys
muleys11409643muleys
nabbed115113613nabbe_d
nabber104913543nabbe_r
nabes75427093nabe_s
nabobess1242203nabobess
obes66036833_obe_s
obey96521303_obey_
objets15125323objets
oboes75717713oboe_s
obsess845943obsess
ombers104214403ombers
parleys125212373parleys
poboys1397313poboys
pogeys124110353pogeys
pokeys15529513pokeys
preys105717783_preys
pubes94423403pube_s
queys17398363_queys
rabbet103818653rabbe_t
rabbies113416053rabbies
rabbins112811343rabbins
rabbis102613163rabb_is
rabbits11299863rabbits
rabblers123810853rabblers
rabbles113517973rabbles
rabies85226023rabie_s
rebbes10313533rebbe_s
rebecs103913673rebecs
rebels84518133rebels
rebuys11428783rebuys
rekeys13347693rekeys
ribbers113913183ribbers
ribes75530173ribe_s
robbers112814163robbers
robes75133303robe_s
rubbers113913193rubbers
rubels84112993rubels
rubes74928413rube_s
sabbats1138633sabbats
sabbed114518083sabbe_d
sabers85224733sabers
sabes76437463sabe_s
sables85026693sable_s
sabres85520863sabre_s
sawneys13274643sawneys
slabbers123610123slabbers
sobbers114114263sobbers
sobers85218863sobers
stabbers12268733stabbers
subers85722643subers
swabbers15316743swabbers
tabbed114215363tabbe_d
tabbies112913503tabbies
tabbis102910863tabb_is
tabby125213893tabb_y_
tabers84621573tabers
tabes76033923tabe_s
tables84524893table_s
tablets94714383tablets
tawneys13324773tawneys
treys85018213_treys
tubbers113411253tubbers
tubers85017033tubers
tubes74826453tube_s
umbels104510593umbels
umbers104215213umbers
valleys13407483valleys
vibes104719953vibe_s
wabblers15398993wabblers
wabbles144013993wabbles
wabbly16348363wabbly_
waveys15597013waveys
webers11310943webers
wheys145911553_wheys
wifeys15425873wifeys
xebecs17355363xebecs
yabber136111833yabbe_r
yabbies14279643yabbies
yabby15389753yabb_y_
zebecs19316183zebecs
zibets1737743zibets

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 Filter1786911127160.390458182.1
2DLD Change Limit1127164537.28315476.6
3Display Results4534530.1403235.7
 (SQL Overall)1786914537.81322871.0
 
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.