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

212 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
bordered124893(None) 
borderer1168101borderer
ordered9108531_ordered
barbered13259542barbered
bartered113113012bartered
border94419972border__
bordereau1243322bordereau
borderers1276332borderers
borders104317532border_s
bordure1035782bordure_
bordures1136172bordures
bothered142110392bothered
bouldered1344482bouldered
bowered133113042bo_wered
broidered1344932broidered
brokered1536082brokered
burdened1236422burdened
cornered11311132cornered
doddered1234942doddered
dormered1255672dormered
embordered1642492embordered
foddered1434552foddered
moldered1237172moldered
murdered1236022murdered
orderer8127942_orderer
pondered126411292pondered
portered112311542portered
powdered15256892powdered
reordered1145382reordered
soldered1038152soldered
unordered1145292unordered
wondered13239942wondered
badgered1336213badgered
bannered11299323bannered
bantered113313633bantered
barded105426423bard__ed
barred95725793bar__red
barreled1137843barreled
barterer102711633barterer
battered113315053battered
beavered1437503beavered
bedewed1437153b_edewed
bergere1068913bergere_
bergeres1189113bergeres
bettered113011843bettered
bickered17108003bickered
birded104414303bird__ed
birder94915493birder__
birders103913263birder_s
birdfeed1542443birdfeed
birdied11329433bird_ied
birdseed1243253birdseed
birred94713203bir__red
bistered112913333bistered
bittered112711833bittered
blazered2035063blazered
bloodred1234083blood_red
blundered1335193blundered
boarded113910503board__ed
boarder103910323boarder__
boarders11408623boarder_s
boded95124963bo_d__ed
bodied103814583bo_d_ied
bogeyed1435673bo_geyed
bolder94820933bolder__
bolstered1246093bolstered
bonded104719953bond__ed
bonder95324783bonder__
bonders104120663bonder_s
bonneted1136223bonneted
boodled113410933bood_led
boogeyed1543723boogeyed
borated104116363bor_ated
bordeaux1843273bordeaux
bordel94514573bord__el
bordello1144713bordello
bordels103911973borde_ls
bordereaux205993bordereaux
bordering1338833bordering
borderland1452163borderland
bored85034303bo___red
boreen8314313bor_e_en
borer75131273bor_er__
borers85122683bor_er_s
borked135117293bor__ked
borrowed1465043borrowed
boulderer1244403boulderer
boweled132810693bo_weled
breed85526693b_r_e_ed
breezed19287053b_reezed
brewed125411873b_r_ewed
briefed1335743b_riefed
broadened1364333broadened
broiderer1244353broiderer
brothered1546003brothered
buffered1764993buffered
buggered1335623buggered
bumpered1536003bumpered
bunkered15177183bunkered
burdener1136143burdener
burred95820723bur__red
burseed1049503burse_ed
burweed1347823burwe_ed
buttered112712623buttered
careered1139493careered
chowdered1944013chowdered
cindered1239793cindered
cockered17710213cockered
coffered1737673coffered
cohered133514693co_hered
compered153414923compered
coopered133310933coopered
coppered153410543coppered
corbeled1338373corbeled
corded105923353cord__ed
cordelled1346403cordelled
corder94322883corder__
corders104520883corder_s
cordoned12229613cordoned
corseted11311473corseted
coshered14610293coshered
cottered112511733cottered
covered133315293co_vered
cowered133214653co_wered
dandered112110963dandered
disordered1344323disordered
dodderer1144203dodderer
donnered10307753donnered
dowered122811553do_wered
fendered13258673fendered
forded115020393ford__ed
fostered122210453fostered
foundered1435403foundered
gandered112211173gandered
gardened1137003gardened
garnered10247113garnered
gartered10319593gartered
gendered11258873gendered
goffered1634523goffered
gorgeted1135353gorgeted
hardened1338613hardened
hindered1339453hindered
hoidened1335653hoidened
hollered1237603hollered
homered133212713ho_mered
hoovered15195413hoovered
horded115420483hord__ed
hovered143411573ho_vered
hoydened1644643hoydened
juddered1833583juddered
koshered1636063koshered
laddered1136743laddered
loitered938183loitered
loppered13326753loppered
lorded84916733lord__ed
loudened1044693loudened
louvered1244993louvered
lowered112711913lo_wered
misordered1443793misordered
modeled1139463mo_deled
modemed1336723mo_demed
mongered1238953mongered
morseled1147193morseled
mortared1137213mortared
mothered142310103mothered
mouldered1343753mouldered
murderee1146843murderee
murderer1145263murderer
ochered132610283_ochered
odored8399223_o_dored
offered1436143_offered
order65019363_order__
orderers9116563_orderers
orderly1135763_orderly
orders74315993_order_s
ordure756813_ordure_
ordures856473_ordures
osiered837123_osiered
overed102216623_o_vered
pandered121812573pandered
perdured12287403perdured
ponderer112410193ponderer
pothered142311043pothered
pottered112311663pottered
powderer14245593powderer
powered132911643po_wered
preordered1443123preordered
rendered102512263rendered
rodeoed937883ro_deoed
rogered939553ro_gered
scowdered1643743scowdered
smoldered1343793smoldered
sobered102912433so_bered
soddened1144643soddened
solderer947183solderer
soldiered1143763soldiered
sorcerer1036433sorcerer
sundered10312153sundered
teddered11255183teddered
tendered102510603tendered
tochered1437913tochered
tortured935843tortured
tottered9208703tottered
towered112911403to_wered
verderer1245373verderer
verdured13255763verdured
wandered132110793wandered
wildered1336633wildered
wonderer12249183wonderer
worded114316623word__ed
worsened1236053worsened
yodeled1236863yo_deled

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622126.36022981.4
3Display Results2122120.0932279.6
 (SQL Overall)1786912126.85926052.0
 
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.