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

257 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
alloyed1115803(None) 
allayed11138061allayed
allowed111610081allowed
alcoved1375622alcoved
allayer10148212allayer
alleged9389322alleged
allied74217152all_ied
allod64418382allo__d
allotted986872allotted
allover1038582allover
alloy85519972alloy__
alloys94014562alloy_s
allseed835952allseed
alluded9327092alluded
allured8299172allured
annoyed1185872annoyed
balloted1189042balloted
cloyed125111562_cloyed
fallowed15127752fallowed
galloped12107152galloped
halloaed121510152halloaed
halloed113314912hallo_ed
hallooed12168772hallooed
hallowed15179502hallowed
ployed124310562_ployed
sallowed12149032sallowed
tallowed12157712tallowed
unalloyed1343722unalloyed
valleyed1534012valleyed
walleyed1534152walleyed
walloped14146832walloped
wallowed15148172wallowed
ablated102513443ablated
abled86926833abl__ed
abluted10188363abluted
aboded104912513a_boded
adored84714243a_dored
ailed66240283ail__ed
alarmed1037743alarmed
alated75625153a_lated
alcayde13103723alcayde
alcove1178093alcove_
alcoves1297883alcoves
aldose7311093aldose_
aldoses8311203aldoses
alerted82512233alerted
algoid83011473algo_id
alibied1038143alibied
aliened81011743aliened
aligned9128553aligned
alined75221403a_lined
aliped95414283a_liped
alkyd13537093a_lky_d
allay85620393allay__
allayers11156633allayers
allays94313743allay_s
allee54932123all__ee
allees64521483all_ees
allege74314653allege_
alleger8319633alleger
alleges84212573alleges
allele64514563allele_
alleles73812033alleles
alley85721673all__ey
alleys95113303alley_s
allies63827673all_ies
allobar946663allobar
allocated1248093allocated
allodia8128793allodia
allods73615083allo_ds
allonge837023allonge
allonges937313allonges
allonym1244733allonym
allonyms1344363allonyms
allot54933873allo__t
allots64019173allo_ts
allottee887123allottee
allotter866473allotter
allotype1344823allotype
allotypes1445103allotypes
allotypy1643003allotypy
allovers1137673allovers
allow85420663allo__w
allowedly1642323allowedly
allows94517683allo_ws
alloxan1445773alloxan
alloying12339143alloying
allseeds943393allseeds
allude73910903allude_
alludes83610333alludes
allure63012943allure_
allurer7348433allurer
allures72913113allures
ally76935643all_y__
allyl85310543all_y_l
allyls9437273all_yls
almond91410433almo_nd
almoner949383almoner
aloe45540193a_lo_e_
aloes54933673a_lo_es
alone55732963a_lone_
aloud65018073a_lo_ud
altered83215753altered
annoyer1095603annoyer
apposed1247853apposed
aproned10311503aproned
arbored103811603arbored
armored102610473armored
arrayed11117163arrayed
arrowed1148133arrowed
aslope839013aslope_
assayed1135593assayed
atoned75417543a_toned
autoed7712823auto_ed
avowed1335963a_vowed
axled135315813axl__ed
azoted16388593a_zoted
balled94926893ball__ed
ballonet10314503ballonet
ballooned1245103ballooned
balloter1078893balloter
belayed133610083belayed
bellowed14158613bellowed
beloved13188393beloved
billowed14137063billowed
bilobed1235913bilobed
blooded11379803blooded
bloomed12439433bloomed
blooped12398543blooped
blowed125016693_blowed
bolloxed1834473bolloxed
buoyed1236693_buoyed
called94126733call__ed
callose9313663callose_
calloses10313393calloses
calloused1244403calloused
callower13159073callower
callused1135853callused
caloyer1238143caloyer
carboyed1637183carboyed
clayed125013043_clayed
cloned94518803_cloned
closed95317973_closed
colored10313473colored
coyed114623803__coyed
dallied93713613dall_ied
decoyed14358343decoyed
delayed123310763delayed
deployed1535913deployed
dolloped1234983dolloped
elbowed13235483elbowed
eloped95914153_eloped
employed1654953employed
enjoyed1834523enjoyed
fellowed15136843fellowed
flayed134414053_flayed
fleyed13408813_fleyed
flooded12307933flooded
floored11268683floored
flowed133513763_flowed
followed15146273followed
galled84622863gall__ed
galleted1038223galleted
gallied94115003gall_ied
gallooned1144473gallooned
galloper11137193galloper
gallused1034193gallused
galoped11138083galoped
gleyed11478153_gleyed
globed104811763_globed
gloomed11337413gloomed
gloved114811873_gloved
glowed114913833_glowed
glozed173711223_glozed
halloes104021523hallo_es
hallower14139823hallower
haloed104717603halo_ed
helloed113512433hello_ed
hilloaed12136923hilloaed
hilloed113211293hillo_ed
holloaed12157393holloaed
holloed113812753hollo_ed
hollooed12146493hollooed
hollowed15157033hollowed
hulloaed12105803hulloaed
hulloed11369793hullo_ed
hullooed12135093hullooed
illuded9305763illuded
illumed10285863illumed
joyed164811833__joyed
labored102810253labored
lalled74218753lal_led
layed95127383__layed
lobed86022133__lobed
lolled74315823_lolled
lolloped1134463lolloped
looed64626133__looed
looked114717073_looked
loomed94616763_loomed
looped95217173_looped
loosed75520893_loosed
looted74421113_looted
loped85128333__loped
loved95021363__loved
lowed95233903__lowed
loxed135017053__loxed
malled94626113mall__ed
malposed1344563malposed
mellowed14166933mellowed
palled94625163pall__ed
palleted1139873palleted
parlayed1435823parlayed
parleyed1436243parleyed
pillowed14156383pillowed
piloted10310323piloted
played124815033_played
plowed124213203_plowed
rallied83514083rall_ied
rallye95110163rall_ye_
rallyes10348553rall_yes
relayed113212753relayed
sallied83316953sall_ied
sallower11139503sallower
salvoed11307063salvo_ed
samoyed1335893samoyed
scalloped1444463scalloped
shallowed1655093shallowed
siloed74615303silo_ed
slalomed1134283slalomed
slayed104716223_slayed
sloped94216853_sloped
slowed104617073_slowed
sloyd9409683_sloy_d
soloed74515743solo_ed
splayed13357813splayed
stroyed114110863stroyed
swallowed1663583swallowed
tailored936203tailored
tallaged10257923tallaged
tallied83314753tall_ied
taloned8310223taloned
toyed96019803__toyed
tutoyed1133943tutoyed
ullaged937033ullaged
unallayed1344073unallayed
unallowed1344413unallowed
uncloyed1487343uncloyed
unlobed10219743unlobed
unloved112310533unloved
volleyed1543533volleyed
walled104021293wall__ed
walleye1336243walleye_
walleyes1435603walleyes
walloper13147113walloper
wallower14158943wallower
willowed15156773willowed
yellowed15185753yellowed

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.406440125.6
2DLD Change Limit1340272576.82619634.8
3Display Results2572570.0932763.4
 (SQL Overall)1786912577.32524394.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.