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

295 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
ordered910853(None) 
bordered1248931bordered
orderer8127941orderer
borderer1168102borderer
cornered11311132cornered
doddered1234942doddered
dormered1255672dormered
foddered1434552foddered
moldered1237172moldered
murdered1236032murdered
ochered132610282ochered
odored8399222o_dored
offered1436142offered
order65019362order__
orderers9116562orderers
orderly1135762orderly
orders74315992order_s
ordure756812ordure_
ordures856472ordures
osiered837122osiered
overed102216622o_vered
pondered126411292pondered
portered112311552portered
powdered15256892powdered
reordered1145382reordered
rodeoed937882rodeoed
rogered939552rogered
soldered1038152soldered
unordered1145292unordered
wondered13239942wondered
adhered1239233adhered
adored84714243_adored
altered83215753altered
angered93013473angered
arbored103811603arbored
armored102610473armored
badgered1336213badgered
barbered13259553barbered
bartered113113033bartered
bedewed1437153bedewed
border94419973border__
bordereau1243323bordereau
borderers1276333borderers
borders104317533border_s
bordure1035783bordure_
bordures1136173bordures
bothered142110393bothered
bouldered1344483bouldered
bowered133113043bowered
breed85526693br_e_ed
breezed19287053breezed
brewed125411873br_ewed
briefed1335743briefed
broidered1344933broidered
brokered1536083brokered
burdened1236423burdened
capered123014043capered
careered1139503careered
catered103117783catered
cered85227443__cered
cheered133713303cheered
chowdered1944013chowdered
cindered1239793cindered
cockered17710213cockered
coffered1737673coffered
cohered133514693cohered
compered153414923compered
coopered133310943coopered
coppered153410543coppered
corbeled1338373corbeled
corded105923353cord__ed
cordelled1346403cordelled
corder94322883corder__
corders104520883corder_s
cordoned12229613cordoned
corseted11311473corseted
coshered14610293coshered
cottered112511743cottered
covered133315293covered
cowered133214653cowered
cratered1149693cratered
creed85727393cr_e_ed
creeled104012013creeled
creeped12329713creeped
creped114115713cr_eped
crewed125316563cr_ewed
dandered112110963dandered
dared75935013__dared
deed65340903__de_ed
deked115718533__deked
deled75326543__deled
dere56845903__dere_
dewed105020303__dewed
disordered1344323disordered
dodderer1144203dodderer
donnered10307753donnered
dowered122811553dowered
dredged11346893dredged
dreed75222843dr_e_ed
dured75025403__dured
embordered1642493embordered
endeared1038053endeared
endured93611213endured
entered82718883entered
erred65915673er__red
fedexed1934083fedexed
fendered13258673fendered
fevered14339723fevered
fibered1337643fibered
fleered11309503fleered
forded115020393ford__ed
fostered122210453fostered
foundered1435403foundered
freed95223543fr_e_ed
frere85617723fr_ere_
freres94716173fr_eres
gandered112211173gandered
gardened1137003gardened
garnered10247123garnered
gartered10319603gartered
gendered11258873gendered
goffered1634523goffered
gorgeted1135353gorgeted
greed75125693gr_e_ed
greened93111263greened
greeted93111383greeted
greyed114610603gr_eyed
grieved1235283grieved
grueled937133grueled
hardened1338613hardened
havered144011453havered
hindered1339453hindered
hoidened1335653hoidened
hollered1237603hollered
homered133212713homered
hoovered15195413hoovered
horded115420483hord__ed
hovered143411573hovered
hoydened1644643hoydened
indeed83913563inde_ed
indexed16347363indexed
inhered11313163inhered
jeered143912793_jeered
juddered1833583juddered
koshered1636063koshered
laddered1136743laddered
ladened979053ladened
lagered92311153lagered
layered11259413layered
leered73816223_leered
levered114212303levered
livered113111633livered
loitered938183loitered
loppered13326753loppered
lorded84916733lord__ed
loudened1044693loudened
louvered1244993louvered
lowered112711913lowered
metered103514013metered
misordered1443793misordered
mitered103213233mitered
modeled1139463modeled
modemed1336723modemed
mongered1238953mongered
morseled1147193morseled
mortared1137213mortared
mothered142310103mothered
mouldered1343753mouldered
murderee1146843murderee
murderer1145263murderer
oared65030653o__ared
obeyed1235823o_beyed
observed1444383observed
obverted1435103obverted
ochred12328003o_chred
odder74515393odder__
offerer1335543offerer
older65121173older__
omened93711003o_mened
opened94311863o_pened
orated74221503or_ated
orbed85516193or__bed
orbited1037733orbited
ordained1035183ordained
ordeal779253orde_al
ordeals878003ordeals
ordering1039353ordering
orderless1044313orderless
orderlies1045453orderlies
ordines83014903ordines
oread64619603or_e_ad
oreide7311673or_eide
oriented937483oriented
ormer75218373ormer__
ormers84316143ormer_s
ornerier846043ornerier
ornery938463orner_y
orphrey15133393orphrey
orreries8310123orreries
orrery936783orrer_y
outbred10311263outbred
outdared102711513outdared
overbed132811853o_verbed
overdared1439163overdared
overfed142510253o_verfed
oystered1236923oystered
pandered121812573pandered
papered122513173papered
peered93819493_peered
perdured12287403perdured
petered103314973petered
ponderer112410193ponderer
pothered142311043pothered
pottered112311663pottered
powderer14245593powderer
powered132911643powered
predried12309573predried
preed85128123pr_e_ed
preened103214993preened
premed114617763pr_emed
preordered1443123preordered
preyed125313203pr_eyed
queered17117223queered
rared65738323_r_ared
reared75930013_reared
rebred95816353_rebred
redded94019553_redded
reded74829123_r_eded
redrew10309513_redrew
redried93714903_redried
redyed114611243_redyed
reed55549623_r_e_ed
reeded84022563_reeded
reefed103816583_reefed
reeked113717643_reeked
reeled74725533_reeled
reeved104118713_reeved
refed93921923_r_efed
rendered102512263rendered
reread71715433_r_eread
revered112819333revered
rewed95425453_r_ewed
roared75015393_roared
rodded93713703rod_ded
roweled11269863roweled
sabered103213023sabered
scowdered1643743scowdered
sered65737293__sered
severed113513863severed
sewered112911243sewered
sheered113515463sheered
smoldered1343793smoldered
sneered83113973sneered
sobered102912433sobered
soddened1144643soddened
solderer947183solderer
soldiered1143763soldiered
sorcerer1036433sorcerer
speered103614813speered
sphered133512313sphered
spiered104412463spiered
steered83615253steered
sundered10312153sundered
supered10316123supered
tabered103311593tabered
tapered102612933tapered
teddered11255183teddered
tendered102510603tendered
tiered73613973_tiered
tochered1437913tochered
tortured935843tortured
tottered9208703tottered
towered112911403towered
treed65626733tr_e_ed
truebred1142753truebred
ulcered1037973ulcered
umbered121510113umbered
underfed13311713underfed
ushered1139153ushered
uttered82712443uttered
veered103612743_veered
verderer1245373verderer
verdured13255763verdured
wafered14288433wafered
wagered12299333wagered
wandered132110793wandered
watered113014963watered
wavered142910433wavered
wedeled1237783wedeled
widened12328053widened
wildered1336633wildered
wonderer12249183wonderer
worded114316623word__ed
worsened1236053worsened
yodeled1236863yodeled

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.423422437.4
2DLD Change Limit1340272956.93619323.4
3Display Results2952950.1102681.8
 (SQL Overall)1786912957.46923924.4
 
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.