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

158 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
powdered1525689(None) 
pondered126411291pondered
powderer14245591powderer
powered132911641pow_ered
bordered1248932bordered
bowered133113042bow_ered
chowdered1944012chowdered
cowered133214652cow_ered
doddered1234942doddered
dowered122811552dow_ered
foddered1434552foddered
lowered112711912low_ered
moldered1237172moldered
ordered9108532_ordered
pandered121812572pandered
ponderer112410192ponderer
portered112311552portered
pothered142311042pothered
pottered112311662pottered
powder123611902powder__
powderers15214792powderers
powders134111552powder_s
powdery16396122powder_y
scowdered1643742scowdered
soldered1038152soldered
towered112911402tow_ered
wondered13239942wondered
borderer1168103borderer
bothered142110393bothered
bouldered1344483bouldered
boweled132810693bow_eled
broidered1344933broidered
cindered1239793cindered
cockered17710213cockered
coffered1737673coffered
cohered133514693co_hered
compered153414923compered
coopered133310943coopered
coppered153410543coppered
cornered11311133cornered
coshered14610293coshered
cottered112511743cottered
covered133315293co_vered
cowherd1636953cowher_d
dandered112110963dandered
dodderer1144203dodderer
donnered10307753donnered
dormered1255673dormered
doweled12269773dow_eled
empowered1743053empow_ered
fendered13258673fendered
flowered1546013flow_ered
fostered122210453fostered
foundered1435403foundered
gandered112211173gandered
gendered11258873gendered
glowered1345753glow_ered
goffered1634523goffered
hindered1339453hindered
hoidened1335653hoidened
hollered1237603hollered
homered133212713ho_mered
hoovered15195413hoovered
hovered143411573ho_vered
howdied15296843howd_ied
hoydened1644643hoydened
impowered1743143impow_ered
juddered1833583juddered
koshered1636063koshered
laddered1136743laddered
lawyered1534033lawyered
loitered938183loitered
loppered13326753loppered
loudened1044693loudened
louvered1244993louvered
lowbred13225363low_bred
modeled1139463mo_deled
modemed1336723mo_demed
mongered1238953mongered
mothered142310103mothered
mouldered1343753mouldered
murdered1236033murdered
nowhere1337213nowhere_
nowheres1437513nowheres
ochered132610283_ochered
odored8399223_o_dored
offered1436143_offered
orderer8127943_orderer
osiered837123_osiered
overed102216623_o_vered
paltered113012503paltered
pampered15229233pampered
panderer112210913panderer
papered122513173p_apered
pattered112714213pattered
paupered13216943paupered
peered93819493p__eered
peltered112510453peltered
peppered1236133peppered
perdured12287403perdured
pestered112814973pestered
petered103314973p_etered
pewterer13256313pewterer
pilfered1435853pilfered
pioneered1253733pioneered
plundered1344323plundered
pocketed17147143pocketed
podded115012713po_d_ded
polder94019253polder__
polders103617373polder_s
pollened1157783pollened
pommeled1543103pommeled
ponded105218773pond__ed
ponder94521703ponder__
ponderers12248453ponderers
ponders103618853ponder_s
pondweed1543103pondweed
popeyed1535713po_peyed
pored85234513po___red
postured1139493postured
potterer102310263potterer
poured95116743po__ured
powdering16246503powdering
powderless1642593powderless
power105325953pow_er__
powers113822323pow_er_s
powter114116033powter__
powters124015663powter_s
powwowed1641693powwowed
preordered1443123preordered
proffered1843433proffered
prospered1446973prospered
puckered1736103puckered
puttered112611153puttered
rendered102512263rendered
reordered1145383reordered
repowered1544663repow_ered
rodeoed937883ro_deoed
rogered939553ro_gered
roweled11269863row_eled
sewered112911243sew_ered
showered1537013show_ered
smoldered1343793smoldered
sobered102912433so_bered
soddened1144643soddened
solderer947183solderer
soldiered1143763soldiered
sundered10312153sundered
teddered11255183teddered
tendered102510603tendered
tochered1437913tochered
tottered9208703tottered
toweled112410223tow_eled
unordered1145293unordered
wandered132110793wandered
wildered1336633wildered
wonderer12249183wonderer
yodeled1236863yo_deled

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621587.28320068.9
3Display Results1581580.0762078.9
 (SQL Overall)1786911587.77922970.9
 
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.