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

482 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
greened9311126(None) 
greener83111711greener
greeted93111381greeted
preened103214981preened
breezed19287052breezed
careened1139192careened
creeled104012012creeled
creeped12329712creeped
gardened1137002gardened
geeked124510162g_eeked
gleaned9349422gleaned
gleeked13346332gleeked
gleeted9379322gleeted
grained93814272grained
greased93812392greased
greatened1144582greatened
greaved12408912greaved
greed75125692gr_e_ed
green65522142green__
greenery12265922greenery
greenest9312622greenest
greenhead1443162greenhead
greenie8310122greenie
greenier938712greenier
greenies9312672greenies
greenlet948512greenlet
greenly11408182greenly
greens75716872green_s
greenth11116722greenth
greeny104811452green_y
greeter82812672greeter
greyed114610602gr_eyed
grieved1235282grieved
grinned9378552grinned
groaned9259972groaned
groined92710812groined
grueled937132grueled
keened114013622_keened
peened94318152_peened
preener93114832preener
queened17105862queened
reeded84022562_reeded
reefed103816582_reefed
reeked113717642_reeked
reeled74725532_reeled
reeved104118712_reeved
regreened1145552regreened
reined74425522_reined
screened1137402screened
sheened113511702sheened
weened104013732_weened
adeemed1145393adeemed
agreed84712503agr_e_ed
aliened81011743aliened
arene55329413ar_ene_
arenes64928393ar_enes
beaned95621473_beaned
beefed123510873_beefed
beeped115313453_beeped
bleeped12287273bleeped
brained103816103brained
branned104311693branned
brazened20134903brazened
breaded115014063breaded
breamed124011593breamed
breeched16337383breeched
breed85526693br_e_ed
breeder103210043breeder
breeze17298963breeze_
breezes18318693breezes
breveted1435623breveted
brewed125411873br_ewed
briefed1335743briefed
brined95118413br_ined
browned134710973browned
burdened1236423burdened
careener1039323careener
careered1139493careered
cheeked17399663cheeked
cheeped153410593cheeped
cheered133713293cheered
cheesed133910683cheesed
cleaned103512003cleaned
cleeked14357733cleeked
cozened19349183cozened
craned96121653cr_aned
cravened1476713cravened
creaked143413233creaked
creamed123913713creamed
creased104315583creased
created104323443created
creed85727393cr_e_ed
creeper11339973creeper
creese84014333creese_
creeses93914623creeses
creeshed1435693creeshed
crenel84213063cr_enel
creneled11326893creneled
creped114115703cr_eped
crested103416533crested
crewed125316553cr_ewed
crooned103813343crooned
crowned133912423crowned
darkened1435943darkened
davened124610073davened
deaned84620453_deaned
deeded94615543_deeded
deemed104713063_deemed
deepened1235653deepened
denned84215633_denned
dizened18267333dizened
dovened12389063dovened
dozened18377453dozened
drained93713253drained
dreaded103612023dreaded
dreamed114310633dreamed
dredged11346883dredged
dreed75222843dr_e_ed
dressed93511873dressed
droned84616863dr_oned
drowned12419903drowned
egressed1046873egressed
erected103213993erected
ermined10410603ermined
evened101010313_evened
feezed19439993_feezed
fleeced13358153fleeced
fleered11309503fleered
fleeted113310233fleeted
freaked15399703freaked
freebee1238043freebee
freed95223543fr_e_ed
freemen1238463freemen
freeness11710443freeness
freeze18349513freeze_
freezer19348523freezer
freezes193310353freezes
freshed143312593freshed
freshened1645253freshened
fresnel1035893fresnel
fretted113411853fretted
friend10388933frien_d
friended1335033friended
frowned14348833frowned
gained84617463g_ained
gardener1037103gardener
garmented1345883garmented
garnered10247113garnered
garreted1057523garreted
gartered10319583gartered
gaveled12399133gaveled
geared85317743g_eared
gecked146911933g_ecked
geed65435503g__e_ed
geese64316003g_eese_
geezer16278013g_eezer
gelded94512113g_elded
gelled84718893g_elled
gemmed12329573g_emmed
gene56237223g__ene_
genes65133093g__enes
genet66038683g__enet
gerent73223093geren_t
gerents82612923gerents
gerenuk1243843gerenuk
gerund836163gerun_d
ginned83813983g_inned
girned84010513g_irned
gleamed11327933gleamed
gleaner8379773gleaner
gleed75320573g_le_ed
gleemen1035723gleemen
gleyed11478153g_leyed
gorgeted1135353gorgeted
governed1335193governed
gowaned1235763gowaned
gowned114410133g_owned
grabbed13368643grabbed
graced105217903gr_aced
graded94919553gr_aded
grafted124110223grafted
grainer83714063grainer
grand75122693gr_an_d
granted94715103granted
graphed1498473graphed
grapnel1035603grapnel
grasped11409063grasped
grassed93812793grassed
grated84523923gr_ated
graved114818813gr_aved
graveled13417363graveled
grayed115415643gr_ayed
grazed174115913gr_azed
grease75416233grease_
greaser83913083greaser
greases84816713greases
greaten83610643greaten
greater84416493greater
greave104611493greave_
greaves113311443greaves
grebe85114943gr_ebe_
grebes93813613gr_ebes
grecized2134433grecized
gree56641563gr_e_e_
greedier1036083greedier
greeds84314283gree_ds
greedy11518843gree_dy
greegree1044483greegree
greeing93613783greeing
greek105915943gr_e_ek
greenbelt1243973greenbelt
greenbug1242633greenbug
greenfield1552153greenfield
greenfly1554083greenfly
greenheads1542993greenheads
greeniest1039033greeniest
greening103112533greening
greenish1247073greenish
greenlets1044703greenlets
greenlit945803greenlit
greenness1046793greenness
greensand1142863greensand
greenths1295213greenths
greenway1543853greenway
greenwood1443083greenwood
grees65132473gr_e_es
greet65835323gr_e_et
greeters92610113greeters
greets75117423gree_ts
greige847203greige_
greiges937733greiges
greisen856503greisen
grenade938413gr_enade
greyer104510093gr_eyer
greyhen1443193greyhen
greyness1235243greyness
gridded11387583gridded
grided95117043gr_ided
grieve1047243grieve_
griever1136033griever
grieves1137323grieves
grifted12379583grifted
grilled94012833grilled
grimed104714093gr_imed
grind75917563gr_in_d
grinded104210633grinded
grinner8329233grinner
griped104114713gr_iped
gripped13419343gripped
gritted94110903gritted
groaner82510133groaner
grokked1233673grokked
groomed11379503groomed
grooved12347253grooved
groped107515053gr_oped
grossed93812253grossed
ground82310273groun_d
grounded1136573grounded
grouped11419193grouped
groused94712833groused
grouted94111503grouted
groved114413703gr_oved
groveled13345453groveled
growled12278163growled
groyne1037213groyne_
groynes1137823groynes
grubbed13406433grubbed
grudged11317163grudged
grueler837023grueler
gruelled1034893gruelled
gruffed1544943gruffed
grumped13337333grumped
grunted9339283grunted
guessed9176603guessed
guested9157713guested
gunned83513093g_unned
gyrene10227243gyrene_
gyrenes11267523gyrenes
hardened1338613hardened
harkened1637483harkened
havened14429243havened
heeded114215763_heeded
heeled104018413_heeled
heezed194210513_heezed
ironed74916013ir_oned
jeaned143813463_jeaned
jeeped16469843_jeeped
jeered143912793_jeered
jereed144012063jere_ed
keeked104810113_keeked
keeled114414263_keeled
keener104012833_keener
kenned114411263_kenned
kerned114112923_kerned
kleenex1842383kleenex
kneeled12328063kneeled
ladened979053ladened
latened8711923latened
leaned73422543_leaned
leered73816223_leered
likened12267353likened
livened11238933livened
needed84114443_needed
neoned7311483_neoned
omened93711003_omened
opened94311863_opened
ordered9108533ordered
oriented937483oriented
peeked134314573_peeked
peeled94119703_peeled
peeped113915383_peeped
peered93819483_peered
peeved124112883_peeved
peined94918843_peined
penned94217613_penned
prawned1346743prawned
preaged11612333preaged
prebend12319443preben_d
preceded1438283preceded
precented14310693precented
preed85128113pr_e_ed
preen75925053preen__
preeners102712813preeners
preens85020113preen_s
premed114617753pr_emed
preowned1435213preowned
prepped11329893prepped
presented12311633presented
pressed103317313pressed
pretend104011013preten_d
pretended1337193pretended
prevented1539003prevented
prevued1337143prevued
preyed125313193pr_eyed
pruned93413113pr_uned
queered17117213queered
rained75024603_rained
ravened115012283ravened
reamed94326123_reamed
reaped94122453_reaped
reared75930013_reared
reaved104523923_reaved
rebred95816353_rebred
recaned102817203_recaned
receded112713043_receded
recked134821803_recked
redded94019543_redded
reddened1136423_reddened
reded74829113_r_eded
redenied10511283_redenied
redyed114611233_redyed
reearned948883_reearned
reed55549623_r_e_ed
reefer93314363_reefer
reeker103715593_reeker
reeler63822573_reeler
reenter73217793_reenter
reested82916233_reested
reeve84121323_reeve_
reeves94721493_reeves
refed93921923_r_efed
refeed104717623_refeed
refenced1438993_refenced
reffed134712513_reffed
refined114720003_refined
regreeted1136173regreeted
reigned949213_reigned
reinked1239793_reinked
reived104518133_reived
rekeyed1536163_rekeyed
relend76116453_relen_d
relented92614943_relented
relied74926233_relied
relined85321933_relined
remend95216553_remen_d
remended123010393_remended
rend56136573_r_en_d
rended84524103_rended
reneged92010763_reneged
renew83917513_r_enew
renewed11309993_renewed
rennet64624853_rennet
rented74426593_rented
reopened1138503_reopened
repented112614983_repented
repined104918773_repined
repled93319773_repled
repped114616723_repped
rerented92516163_rerented
reseed74823293_reseed
resend75016773_resen_d
resented92716963_resented
resewed113011823_resewed
resined84522653_resined
rested74430783_rested
retene69224273_retene_
retenes76324623_retenes
retied75924983_retied
retted74826313_retted
retuned86613973_retuned
reused75419563_reused
reveled113917753_reveled
revenged1337553_revenged
revenued1237223_revenued
revered112819333_revered
revved13469723_revved
rewed95425453_r_ewed
rezoned173611163_rezoned
ripened1038203ripened
ruined74813323_ruined
screeded1235633screeded
screener1037563screener
seeded84520463_seeded
seeled73922093_seeled
seemed95117613_seemed
seeped94317523_seeped
seined74023063_seined
serene63522353serene_
serener73415753serener
serenes73222903serenes
sheeney13398933sheeney
sheered113515453sheered
sheeted113813033sheeted
skeined1236773skeined
sleeked123510883sleeked
sleeted83113223sleeted
sleeved11419913sleeved
smeeked14287223smeeked
sneered83113973sneered
sneezed17287793sneezed
speaned103411523speaned
speeded113310423speeded
speeled103712453speeled
speered103614813speered
steeked124010473steeked
steeled83513213steeled
steeped103412283steeped
steered83615253steered
steeved113610133steeved
streeked13246153streeked
streeled9267863streeled
sweeney13387003sweeney
teemed95114873_teemed
teener64717503_teener
threeped1454373threeped
tokened1236393tokened
trained84117203trained
treaded95014283treaded
treated83618703treated
trebled1038483trebled
treed65626733tr_e_ed
treen55622753treen__
treens65317873treen_s
trekked1134343trekked
trend64817453tr_en_d
trended94011763trended
tressed83714253tressed
triene64316383triene_
trienes74118413trienes
trined74920713tr_ined
tweener10306833tweener
tweeted11336583tweeted
tweezed20274993tweezed
unreeled91310333unreeled
unreeved12117673unreeved
veered103612743_veered
veined104413913_veined
wakened1546873wakened
weaned103816153_weaned
weeded113914873_weeded
weeted103913793_weeted
wheeled14318463wheeled
wheeped16387503wheeped
wheezed23296453wheezed
widened12328053widened
wizened20275423wizened
worsened1236053worsened
wreaked15369023wreaked
wrecked17418333wrecked
wrested113410933wrested
yeaned103813903_yeaned
yenned10409383_yenned

Search took 9 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.186960704.3
2DLD Change Limit1340274828.15616432.9
3Display Results4824820.1902536.8
 (SQL Overall)1786914828.53220943.6
 
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.