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

301 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
allowed11161007(None) 
alloyed11158031alloyed
fallowed15127751fallowed
hallowed15179491hallowed
sallowed12149031sallowed
tallowed12157711tallowed
wallowed15148161wallowed
alcoved1375612alcoved
allayed11138062allayed
alleged9389312alleged
allied74217152all_ied
allod64418372allo__d
allotted986872allotted
allover1038582allover
allow85420662allow__
allowedly1642302allowedly
allows94517682allow_s
allseed835952allseed
alluded9327092alluded
allured8299172allured
arrowed1148102arrowed
avowed1335952a_vowed
balloted1189042balloted
bellowed14158602bellowed
billowed14137062billowed
blowed125016692_blowed
callower13159072callower
elbowed13235472elbowed
fellowed15136832fellowed
flowed133513762_flowed
followed15146272followed
galloped12107142galloped
glowed114913832_glowed
halloaed121510152halloaed
halloed113314912hallo_ed
hallooed12168772hallooed
hallower14139812hallower
hollowed15157022hollowed
lowed95233902__lowed
mellowed14166922mellowed
pillowed14156382pillowed
plowed124213202_plowed
sallower11139502sallower
shallowed1655082shallowed
slowed104617072_slowed
swallowed1663582swallowed
unallowed1344412unallowed
walloped14146832walloped
wallower14158932wallower
willowed15156762willowed
yellowed15185742yellowed
ablated102513443ablated
abled86926833abl__ed
abluted10188363abluted
aboded104912513a_boded
adored84714233a_dored
aglow94711963aglow__
ailed66240283ail__ed
alarmed1037733alarmed
alated75625143a_lated
alcove1178083alcove_
alcoves1297873alcoves
aldose7311093aldose_
aldoses8311203aldoses
alerted82512223alerted
algoid83011463algo_id
alibied1038143alibied
aliened81011743aliened
aligned9128553aligned
alined75221403a_lined
aliped95414283a_liped
allayer10148213allayer
allee54932123all__ee
allees64521483all_ees
allege74314643allege_
alleger8319623alleger
alleges84212563alleges
allele64514563allele_
alleles73812033alleles
alley85721673all__ey
allies63827673all_ies
allobar946663allobar
allocated1248093allocated
allodia8128793allodia
allods73615083allo_ds
allonge837023allonge
allonges937313allonges
allonym1244733allonym
allot54933873allo__t
allots64019173allo_ts
allottee887123allottee
allotter866473allotter
allovers1137673allovers
allowanced1652303allowanced
allowing12369093allowing
alloxan1445773alloxan
alloy85519973allo__y
alloys94014563allo_ys
allseeds943393allseeds
allude73910903allude_
alludes83610333alludes
allure63012943allure_
allurer7348433allurer
allures72913113allures
almond91410433almo_nd
almoner949383almoner
aloe45540193a_lo_e_
aloes54933673a_lo_es
alone55732963a_lone_
aloud65018063a_lo_ud
alow75328593a_low__
altered83215733altered
annoyed1185863annoyed
apposed1247853apposed
aproned10311503aproned
arbored103811603arbored
armored102610473armored
aslope839013aslope_
atoned75417543a_toned
autoed7712823auto_ed
avower1236823a_vower
awed88436033a___wed
axled135315813axl__ed
azoted16388593a_zoted
balled94926893ball__ed
ballonet10314503ballonet
ballooned1245103ballooned
balloter1078893balloter
bellower13159063bellower
beloved13188393beloved
bilobed1235913bilobed
blawed124713893_blawed
blooded11379803blooded
bloomed12439433bloomed
blooped12398543blooped
blower115316573_blower
blowsed13449023_blowsed
blowzed22435973_blowzed
bolloxed1834473bolloxed
bowed114533423__bowed
browed125216393_browed
called94126733call__ed
callose9313663callose_
calloses10313393calloses
calloused1244403calloused
callow114714663callow__
callowest1445823callowest
callused1135853callused
chowed154914643_chowed
clawed125115073_clawed
clewed1225113203_clewed
cloned94518803_cloned
closed95317963_closed
clowned13447723_clowned
cloyed125111563_cloyed
colored10313473colored
cowed115637843__cowed
crowed124717293_crowed
dallied93713603dall_ied
disallowed1543263disallowed
dolloped1234983dolloped
dowed104632613__dowed
eloped95914143_eloped
embowed15236903embowed
endowed1248173endowed
fallow124713853fallow__
fallows133713973fallow_s
farrowed1545283farrowed
flawed134712723_flawed
flooded12307933flooded
floored11268683floored
flower124815503_flower
follower14137073follower
galled84622853gall__ed
galleted1038213galleted
gallied94114993gall_ied
gallooned1144463gallooned
galloper11137183galloper
gallows113513513gallow_s
gallowses1374943gallowses
gallused1034193gallused
galoped11138063galoped
globed104811763_globed
gloomed11337413gloomed
gloved114811873_gloved
glower105114933_glower
glozed173711223_glozed
halloes104021523hallo_es
hallow124818323hallow__
hallowers15137723hallowers
hallows134417393hallow_s
haloed104717593halo_ed
harrowed1556263harrowed
helloed113512423hello_ed
hilloaed12136923hilloaed
hilloed113211293hillo_ed
holloaed12157393holloaed
holloed113812753hollo_ed
hollooed12146493hollooed
hollower14127393hollower
hulloaed12105803hulloaed
hulloed11369793hullo_ed
hullooed12135093hullooed
illuded9305763illuded
illumed10285863illumed
indowed1237443indowed
jowed164724423__jowed
kotowed1533773kotowed
labored102810243labored
lalled74218753lal_led
lawed96028323__lawed
lobed86022133__lobed
lolled74315823_lolled
lolloped1134463lolloped
looed64626133__looed
looked114717073_looked
loomed94616763_loomed
looped95217173_looped
loosed75520893_loosed
looted74421113_looted
loped85128333__loped
loved95021363__loved
lowe75435313__lowe_
lower85830413__lower
lowes85732463__lowes
loxed135017053__loxed
malled94626103mall__ed
mallow114014743mallow__
mallows123714323mallow_s
malposed1344563malposed
marrowed1445973marrowed
mellower13167403mellower
meowed12148003_meowed
miaowed1333883miaowed
mowed113629013__mowed
narrowed1235203narrowed
owed86833873___owed
palled94625163pall__ed
palleted1139863palleted
piloted10310323piloted
plower114315063_plower
ployed124310563_ployed
rallied83514083rall_ied
reflowed15126903reflowed
reglowed13125853reglowed
replowed14127563replowed
resowed113712253resowed
rowed94034323__rowed
sallied83316953sall_ied
sallow94315753sallow__
sallowest1246563sallowest
sallowly14344833sallowly
sallows103915543sallow_s
sallowy13369343sallow_y
salvoed11307063salvo_ed
scalloped1444463scalloped
scowed124413823_scowed
shallower1555673shallower
showed135016963_showed
siloed74615303silo_ed
slalomed1134283slalomed
slewed104815523_slewed
sloped94216853_sloped
slower94016153_slower
snowed104613613_snowed
soloed74515743solo_ed
sowed94933863__sowed
stowed105817203_stowed
strowed115312143strowed
swallower1554333swallower
tailored936203tailored
tallaged10257923tallaged
tallied83314753tall_ied
tallow93714203tallow__
tallows103313733tallow_s
tallowy13347633tallow_y
taloned8310223taloned
towed95134583__towed
trowed104714653_trowed
ullaged937033ullaged
unalloyed1343723unalloyed
unbowed132610243unbowed
unhallowed1742193unhallowed
unlobed10219743unlobed
unloved112310533unloved
unplowed1436353unplowed
unsowed112511053unsowed
upflowed1742893upflowed
valleyed1534013valleyed
vowed124424573__vowed
walled104021293wall__ed
walleyed1534153walleyed
walloper13147113walloper
wallow123913513wallow__
wallowers15127653wallowers
wallows133613533wallow_s
widowed1534843widowed
willower14127453willower
wowed124023773__wowed
yellower14186213yellower
yowed1253025183__yowed

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.1561145455.1
2DLD Change Limit1340273017.59317651.4
3Display Results3013010.1102736.4
 (SQL Overall)1786913017.85922737.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.