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

352 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
allyls943727(None) 
alkyls13465721alkyls
allyl85310541allyl_
acyls104211522a_cyls
alanyls1084352alanyls
aldols7109712aldols
aliyas93911802aliyas
aliyos9349532aliyos
alkyds14404362alkyds
alkyl12518042alkyl_
allays94313742allays
allees64521482allees
allele64514562allele
alleles73812032alleles
alleys95113302alleys
allies63827672allies
allods73615082allods
allots64019172allots
allows94517682allows
alloys94014562alloys
alls46740922a_l_ls
ally76935642ally__
allylic12155842allylic
alphyls15113952alphyls
amyls104512692a_myls
aryls87015812a_ryls
fallals103310192fallals
hallels103310132hallels
lalls55324132lal_ls
rallyes10348552rallyes
tallols73311362tallols
tolyls9436962tolyls
xylyls1931832xylyls
aaliis6312903aaliis
aals49941143a__als
abayas114011703abayas
ables75935543abl_es
ablins8316193ablins
ably99725133ably__
abyes105518533a_byes
abys97221883a_by_s
abyss10669463a_byss
acetyls12285353acetyls
acyl95314293a_cyl_
adenyls1143923adenyls
aglets73915683aglets
agly86821803agly__
ails45654713a__ils
alamos8415003alamos
alands75418373alands
alans55636173a_lans
alants67722023alants
alanyl955483alanyl_
alarms85913053alarms
alas46358123a_l_as
alates64833973alates
albas75925393a_lbas
albs68628573a_l_bs
albums10198273albums
alcids94812293alcids
alders74218423alders
aldol61212333aldol_
alecs76620733a_lecs
alefs87319663a_lefs
alephs1136533alephs
alerts64418223alerts
ales47067103a_l_es
alfas87219043a_lfas
algal66518223algal_
algas65624933a_lgas
algins74816433algins
algors7312553algors
algums9208043algums
alias55834603a_lias
alibis8311073alibis
alible8311973alible
aliens65619213aliens
alifs86121263a_lifs
aligns75312953aligns
alines65735223alines
aliya83713483aliy_a
aliyah12397493aliyah
aliyahs13395323aliyahs
aliyot93611713aliyot
alkali10127563alkali
alkalis11148793alkalis
alkies104518093alkies
alky115920343alky__
alkyd13537093alky_d
alkylic16174233alkylic
alkyne13436863alkyne
alkynes14336463alkynes
all36148233a_l_l_
allay85620393all_ay
allayed11138063allayed
allayer10148213allayer
allayers11156633allayers
allee54932123all_ee
allege74314653allege
alleges84212573alleges
allelic9118173allelic
allelism1046973allelism
alley85721673all_ey
allheals1143913allheals
allied74217153allied
allium8311243allium
alliums957973alliums
allod64418383all_od
allonyms1344363allonyms
allot54933873all_ot
allow85420663all_ow
alloy85519973all_oy
alloyed11158033alloyed
allude73910903allude
alludes83610333alludes
allure63012943allure
allures72913113allures
allying113011663allying
almahs118611613almahs
almas76629773a_lmas
almehs11619493almehs
almes75126543a_lmes
alms65834923a_l_ms
almuds9378773almuds
almugs9396423almugs
aloes54933673a_loes
alohas9411703alohas
aloins65022203aloins
alphas1139513alphas
alphyl1484083alphyl_
alps65529243a_l_ps
als36663023a___ls
altars64518153altars
alters64924223alters
altos55822953a_ltos
alts46639903a_l_ts
aludels835303aludels
alula5317093a_lula
alums75720603a_lums
always12409133always
ampuls1098893ampuls
amyl95515103a_myl_
angels74416173angels
anils56326723a_nils
anlas55626933anl_as
annals66415923annals
annuls64711733annuls
anvils9219713anvils
appals104812943appals
appels104312793appels
argals75517713argals
argils75213623argils
argols74514613argols
argyle1066063argyle
argyles1136053argyles
argyll1033643argyll
argylls1143463argylls
ariels65119373ariels
arils58732203a_rils
arles56735743arl_es
artels66216233artels
aryl75922343a_ryl_
asyla839333a_syla
atlas55821583atl_as
atlatls744773atlatls
atolls65511353atolls
avails939693avails
awless939263awless
awls75926093a__wls
awols84713523a_wols
axels126313633a_xels
axils127217503a_xils
axles125219473axl_es
ayes76543513a__yes
ays67050293a__y_s
azlons154110423azlons
ballads104212913ballads
ballers94421013ballers
ballets93719513ballets
ballies93725743ballies
ballons93916963ballons
ballots94116033ballots
balls76236413bal_ls
bally105530103bally__
bells76432163bel_ls
beryls11107883beryls
bills75632863bil_ls
bolls75531313bol_ls
bulls75629573bul_ls
butyls1176753butyls
callans94518473callans
callas84526753call_as
callees94117783callees
callers94221963callers
callets93821703callets
callous93516603callous
calls75634733cal_ls
callus85317073call_us
cells75428063cel_ls
clays105521333clay_s
cloys104916943cloy_s
culls75425813cul_ls
dactyls1333913dactyls
dalles74222063dall_es
dallies84023193dallies
dally95324743dally__
dells66630943del_ls
dills65530973dil_ls
dolls66126923dol_ls
dulls64523743dul_ls
ells46431353_el_ls
ethyls1235903ethyls
fallal93612693fallal_
fallers103917993fallers
fallows133713973fallows
falls85727653fal_ls
fells85327383fel_ls
fills84632373fil_ls
flails94313003flails
flays116321053flay_s
fleys117015603fley_s
fluyts12367153fluyts
fulls84623523ful_ls
gallets83517403gallets
galleys11369713galleys
gallfly1433523gallfly
gallies84122713gallies
gallons83015953gallons
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
galls64729323gal_ls
gallus74313203gall_us
gally95026173gally__
ghylls1335143ghylls
gills64728193gil_ls
gleys96514853gley_s
glycyls1642063glycyls
gulls65222983gul_ls
halals95018313halals
hallahs133912463hallahs
hallal94415563hallal_
hallel93514093hallel_
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hall_os
hallows134417393hallows
halls85633783hal_ls
hells85032043hel_ls
hexyls1933443hexyls
hills85431353hil_ls
hulls84923563hul_ls
idylls10425253idylls
idyls9498803_idyls
ills47030423_il_ls
illy76925333illy__
jells125522163jel_ls
jills125122823jil_ls
kills94526173kil_ls
labels84515683labels
lall45531313lal_l_
lallans74113543lallans
lapels83712043lapels
lays76043253_lay_s
leys76430183_ley_s
lolls512121733_lolls
lulls54119653_lulls
lyes75530833__lyes
maills84215283mail_ls
mallees93315973mallees
mallets93318493mallets
malleus92911313malleus
mallows123714323mallows
malls76233433mal_ls
maltols939403maltols
mells75031333mel_ls
mills75435053mil_ls
molls75129783mol_ls
mulls75124153mul_ls
nills54926673nil_ls
nonyls957853nonyls
nulls55019983nul_ls
octyls11135323octyls
odyls9428653_odyls
ollas54218283oll_as
pallets93919303pallets
pallors9314363pallors
palls74332563pal_ls
pally105727123pally__
pills74130973pil_ls
playas114612283playas
plays106320773play_s
ploys105816593ploy_s
polls74627723pol_ls
polyols1238493polyols
polyps13479763polyps
polys105718763poly_s
pulls74425053pul_ls
rallies73823343rallies
rally84725903rally__
rallye95110163rally_e
rallyist1145363rallyist
rills55032713ril_ls
rolls55326233rol_ls
salals65120083salals
sallets73719653sallets
sallies73227813sallies
sallows103915553sallows
sally85129713sally__
salols64017873salols
sells55134433sel_ls
sibyls1135303sibyls
sills55135993sil_ls
slays85723683slay_s
sloyds10346293sloyds
slyly11489533_slyly
tallies73624603tallies
tallis63319963tall_is
tallits73215993tallits
tallol63612223tallol_
tallows103313743tallows
talls55133433tal_ls
tally84526863tally__
tallyho1343043tallyho
tallyhos1443333tallyhos
tells55828943tel_ls
tellys9348843telly_s
tills54631713til_ls
tolls54728433tol_ls
toluyls1032833toluyls
tolyl84710093tolyl_
valkyrs1732163valkyrs
valleys13407483valleys
vills86429323vil_ls
vinyls12467003vinyls
wallahs13409473wallahs
wallas95719393wall_as
wallets103914833wallets
walleyes1435603walleyes
wallies103320743wallies
wallops123410413wallops
wallows133613533wallows
walls85529383wal_ls
wally114625093wally__
wells85426193wel_ls
wills84528963wil_ls
xylols1634173xylols
xylyl1842563xylyl_
yells85821943yel_ls
yills83921553yil_ls
zills144020783zil_ls

Search took 7 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 Limit1127163525.98618829.9
3Display Results3523520.1232861.8
 (SQL Overall)1786913526.49927495.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.